topic Replace DDBB with Alfresco in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/replace-ddbb-with-alfresco/m-p/266012#M219142 <HTML><HEAD></HEAD><BODY><SPAN>Hi there</SPAN><BR /><SPAN>I'm involved in a new project and we are evaluating the possibility to complete substitute our database and relay in Alfresco for saving all out entities, using it as a query environment.</SPAN><BR /><SPAN>For example, we would create custom entities like cars, car parts, users…. then we would like to make queries like give me all the car parts related to the user x. We would use this approach for everything, even for entities with no files involved.</SPAN><BR /><BR /><SPAN>What do you think? Is it feasible? Will I be able to substitute all my normal SQL queries for Cmis queries or Xpath ones?. Will I run into performance issues if I have a lot of entity types and joins?</SPAN><BR /><BR /><SPAN>Thanks a lot in advance for your response.</SPAN></BODY></HTML> Mon, 28 Feb 2011 10:00:50 GMT nnotario 2011-02-28T10:00:50Z Replace DDBB with Alfresco https://connect.hyland.com/t5/alfresco-archive/replace-ddbb-with-alfresco/m-p/266012#M219142 Hi thereI'm involved in a new project and we are evaluating the possibility to complete substitute our database and relay in Alfresco for saving all out entities, using it as a query environment.For example, we would create custom entities like cars, car parts, users…. then we would like to make que Mon, 28 Feb 2011 10:00:50 GMT https://connect.hyland.com/t5/alfresco-archive/replace-ddbb-with-alfresco/m-p/266012#M219142 nnotario 2011-02-28T10:00:50Z Re: Replace DDBB with Alfresco https://connect.hyland.com/t5/alfresco-archive/replace-ddbb-with-alfresco/m-p/266013#M219143 <HTML><HEAD></HEAD><BODY><SPAN>It may work depending upon your use cases.&nbsp;&nbsp;&nbsp; However Alfresco wants to manage "content", does your solution involve managing content.</SPAN><BR /><BR /><SPAN>One fly in the ointment is that JOIN is not (yet?) supported.</SPAN></BODY></HTML> Mon, 28 Feb 2011 11:45:12 GMT https://connect.hyland.com/t5/alfresco-archive/replace-ddbb-with-alfresco/m-p/266013#M219143 mrogers 2011-02-28T11:45:12Z Re: Replace DDBB with Alfresco https://connect.hyland.com/t5/alfresco-archive/replace-ddbb-with-alfresco/m-p/266014#M219144 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for the quick replay, actually it would hold some content sometimes, but we wouldn't be mainly using it for that, we would mainly be using it to store properties.</SPAN></BODY></HTML> Mon, 28 Feb 2011 13:06:07 GMT https://connect.hyland.com/t5/alfresco-archive/replace-ddbb-with-alfresco/m-p/266014#M219144 nnotario 2011-02-28T13:06:07Z