Reverse process modeling

Asked

Viewed 97 times

2

Always, or almost, if the Conceptual ER is made and then we model the Logical ER, in the BR Modelo It is possible to create the Conceptual ER and generate the Logical ER automatically, but when there is the need to do the reverse process? how can we do this? there is some tool that makes this process?

database modeling der

  • Are you sure you’re using the correct terms? Don’t you mean logical and physical model? https://www.1keydata.com/datawarehousing/data-modeling-levels.html https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model

  • I didn’t find anything in this software that he manages the logical model from the conceptual, nor could he, has no way of guessing. At most it avoids the repetition of what is equal in both. It is not possible to generate something without having all possible information. The opposite is easier. This is obviously academic and limited software. Certainly several other software on the market do this. But I do not know if it is so advantage the difference between these two models is minimal and rarely a change in logic will affect the conceptual. It makes more sense from the physical to the logical. This is usually called reverse engineering.

  • @bigown, Yes these are the conceptual and logical models, in the BR template when you create a conceptual diagram and right click on the menu that appear the first option is to generate logical scheme...

2 answers

5


There are several more complete tools, most pay (but have free, even closed source). All I know do reverse engineering from physical model to logical and logical to conceptual. The best starting point is the wikipedia page about this.

Has a most complete list.

1

Hello

From the Logical schema in the BR MODEL it is possible to generate only the Physical, which in the BR MODEL is the SQL code. This is a particularly academic software, I do not consider the ideal software for producing database modeling.

I particularly consider the Workbench that is more productive, effective and offers more complete and professional tools.

Browser other questions tagged database modeling der

You are not signed in. Login or sign up in order to post.