Different Data Models

I have been using VP for about a month now and I have still yet to figure out the difference between the conceptual, logical and physical data models as implemented in Visual Paradigm. Aside from it being a selection in the diagram’s properties, and a change in the entity’s color, I cannot see any practical difference between the 3 models.

Ordinarily, a CASE tool, System Architect for example, lets you use one diagram for all three purposes by changing the view of the model. For example, in conceptual mode, only the entity’s logical name is shown. For the logical view, the entitys and columns are displayed using logical names. And lastly, the physical model, the actual table and column names as well as the column attributes (size, type, etc.) are displayed.

In VP it appears that you would have to create 3 separate diagrams to accomplish the same results. Is this correct? Can anyone shed some light on this subject for me please?

Thanks,

Ricky Miller
Chouest Offshore

Hi Ricky,

Different CASE tool vendor have different approach on handing the conceptual, logical and physical data models. You are correct that VP using different diagrams for conceptual, logical and physical data models.

In VP, actually conceptual, logical and physical data models are having their own set of ER models. They are related to each other using the Model Transitor. The Model Transitor establish the trace between different models. One of the typical case is you create a conceptual model with some entities, then transit to logical model and do some enhancement. The Model Transitor helps to to keep track on the transformation of the ER model.

Only the physical model will be involved in database generation.

More details about establish transition between conceptual, logical and physical data model can be found at http://www.visual-paradigm.com/highlight/erddatamodel.jsp

And to know more about the Model Transitor, please visit http://www.visual-paradigm.com/product/vpuml/demos/modeltransitor/

Hi Rain,

Thank you the speedy response and help in this matter.

Then my suspicions were correct: I need to create 3 separate models. Our use of the 3 models is as follows:

Conceptual - Communicates the ‘concept’ of the data requirements as an undefined collection during discovery in the analysis phase of the development process.

Logical - an embellishment of the above model by the addition of the logically needed pieces of information that further define (and refine) the conceptual entity.

Physical - Contains actual table and column names, along with the other required column properties (type, size, primary key inclusion, foreign key designation, etc) needed to generate the actual database within the DBMS.

Thank you for clarifying that matter for me.

Best Regards,

Ricky Miller
Edison Chouest Offshore

Hello Ricky,

Actually you don’t need to create 3 separate models. Assume you start from conceptual model, you can simply select conceptual model when create ERD (see data_model.png). After you create the conceptual model, you can right click on your ERD and select Transit to Logical/Physical ERD. This will create a new ERD based on your conceptual model (all the entity are linked with transitor automatically). And you can then simply modify the new ERD, with all the trace established automatically.

Best regards,
Rain
data_model.png

Hi Rain,

I will give this technique a try. If it works, than i will indeed have what I need.

Thank you so much for the information.

Best Regards,

Ricky

You are welcome.