topic Re: Realization of an ERD in Alfresco Model Manager in Alfresco Forum

Realization of an ERD in Alfresco Model Manager

kwiesinger — Wed, 10 Jul 2019 07:58:59 GMT

Hi,I currently have an Entity Relationship Diagram which I want to realize in my Model Manager.I created the Model and added my tables but I don't know how to implement my connections between the tables (Foreign-keys). I tried associations already but I'm not sure about how or if I can connect my ta

Re: Realization of an ERD in Alfresco Model Manager

kintu_barot — Wed, 10 Jul 2019 08:14:13 GMT

You have mentioned Model Manager, so you must be talking about the content model.

Content Model in Alfresco is to bind the set of metadata to content(document or folder).

However, you can build an association between different contents within Alfresco.

But it is difficult to understand what exactly you want to do by creating tables.

Which kind of tables?

Can you please explain a bit more about this?

Regards,

Kintu

ContCentric

Re: Realization of an ERD in Alfresco Model Manager

kwiesinger — Wed, 10 Jul 2019 09:04:38 GMT

Luckily I found a solution for my problem, thanks for your help.

Regards,

Katharina

Re: Realization of an ERD in Alfresco Model Manager

abhinavmishra14 — Wed, 10 Jul 2019 14:53:21 GMT

Are you trying to map a table and its columns with content model ?

Re: Realization of an ERD in Alfresco Model Manager

lcolorado — Thu, 11 Jul 2019 14:28:18 GMT

In my experience, the document content model in Alfresco does not adapt well to the relational database paradigms. Although you may adapt most of the relational DB concepts, Alfresco is not really designed with that purpose in mind. After completing your content model using ERD and RDB concepts, you will probably realize that performing some relational queries can be difficult or impossible, and the performance of some queries can be very poor.

I don't have a methodology of my own, but I have found that you may benefit from abandoning, at least temporarily, your relational DB experience, and trying to understand and embrace Alfresco's model.

You may feel uncomfortable abandoning the RDB paradigms, but the Alfresco content model has interesting features that a RDB doesn't have. The content model is conceptually closer to Object Oriented Programming, Aspect Oriented Programming, and hierarchical databases.