Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models, propagate changes from one model to the other in both directions, create database scripts, and reverse-engineer databases.
However, not all data modeling tools are equal. It s the advanced yet critical features that separate a suitable data model from an excellent data model.
Here are four features that distinguish ER/Studio Data Architect from the rest of the data modeling tools in the industry:
- Roll up and roll down multiple relationships
ER/Studio can roll up and roll down multiple relationships in physical data models when collapsing levels in supertype-subtype hierarchies.
- Roll up and roll down not for every entity
ER/Studio does not apply roll ups or roll downs for supertype-subtype hierarchies to every entity at that level of the hierarchy. This is important when models have a lot of subtyping and provide control to the user.
- Logical data models views
ER/Studio can include views in the logical data model, which users can then generate into the physical data models. Or, you can mark views in the logical data model as logical-only (perhaps for reporting or integration requirements).
- Break data definition language (DDL) scripts into smaller files
ER/Studio can break data definition language scripts into smaller, more manageable files when creating the databases.
View this web page to see more unique features of ER/Studio Data Architect that make it the best data modeling tool.
The best way to learn more about how ER/Studio can help you and your organization is to download a free, fully functional, 14-day trial. You do not need to provide any credit card information.
You can also schedule a personalized product demonstration with an IDERA industry expert.