+2
Completed

Super type and sub type representation

Ted Manasa 6 years ago updated by Jarosław Błąd (CEO) 4 years ago 3

Hi, I run Enterprise Data Warehouse for Indeed. We subscribed to your tool for its collaboration and model versioning capabilities. Because we use our data models to reach mutual understanding of data with the business, we would benefit greatly from being able to represent super type and sub type relationships in our Vertabelo diagrams; the business understands that an "advertiser" is a sub type of "customer", but has a harder time understanding why we might put those two things in separate tables. Can this functionality be added?

Answer

Answer
Completed

Generalization relationship has been already added to the logical database model. We forgot to mark this issue as solved.

+1
Started

Hi Ted,

On physical data model there is no such notation to indicate generalization relationship, so it is not possible. However we are working now on introducing logical data model to Vertabelo, which will have such feature. Logical data model represents a higer lever of abstraction and it is especially dedicated to work with the business. This type of model should be available within three months.

The only way to show that two tables are in "generalization relationship" on physical data model is to use short text notes on diagram.

Best regards

Jarosław

Thanks for the response. I'm very encouraged to hear about logical modeling functionality being added this quarter. If there is a beta tester program, I and my team would be interested.

Answer
Completed

Generalization relationship has been already added to the logical database model. We forgot to mark this issue as solved.