Modelio SD SQL provides a set of features specifically designed for developers working on enterprise data modeling with SQL databases.
Conceptual, Logical, and Physical Data Models editors
Modelio SD SQL supports:
- standard UML and dedicated diagrams to help master data models
- dedicated editors for persistency modeling and physical SQL schema design
This provides data designers with the level of abstraction or precision they require to generate the appropriate data schemas.
Modelio SD SQL synchronizes different levels of models to guarantee permanent consistency. Dedicated consistency checks ensure that the model is correct for data modeling.
Automatic transformations between models
Modelio SD SQL supports data modeling using UML. This enables business analysts to start data modeling activities during business analysis, combining it with other business modeling activities (BPM, architecture, and so on) using the integrated UML and BPMN modeling support.
Modelio SD SQL will then transform models into persistent class diagrams, where the model will be further annotated for persistency purposes. Finally, this model can be transformed to an SQL table diagram to generate SQL schemas.
SQL schema generation and reverse
Modelio SD SQL boosts productivity and quality by generating database schemas from high level models. It helps:
- understand and modernize current database schemas,
- raise their abstraction level to carry out business analysis.
From your existing databases, Modelio rebuilds the corresponding model, linking the enterprise architecture to already defined data.
Need more information? We can help you