Data Modelling Structure

The DataModellingStructure diagram is used to create model of datastructures.

The diagram is used to assemble the subject areas of your datamodel and it will keep track of all level of abstractions from highest level concept models, all the way through the physical representation of a database.

The diagram can be used to reverse and forward engineer databases.

The diagram consist of one or multiple SubjectArea that can be broken down to logical level using DataModelDiagram and physical level using RelationalDiagram.

First time you create a SubjectArea you are asked to create the logical model (this can be added later).

From the SubjectArea there are links to (Breaks Down To) the available models on the different abstraction levels:

 

On the Physical Implementation tab, you can link to DataConversionTemplate and add a DataSourceConnection.

When you double click on the SubjectArea you can select to open the dialog, or go to the available models directly:

 

Video

The Data Modelling Structure can together with the DataSourceConnection be used to reverse engineering of databases.

Reverse engineering of SQL Server database

Leave a Comment