SQL transformation workflow

Key features

Modelio SD SQL provides a set of features specifically designed for developers working on enterprise data modeling with SQL databases.

screen modelio sd csharp

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.

uml data model

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 model transformation

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.

SQL generation reverse

Supported SQL standards

Modelio SD SQL supports the SQL-92 standard and the following RDBMS:

  • MySQL
  • Oracle
  • SQL server
  • PostgreSQL
  • DB2/AS400
SQL SGBDs

Project documentation

Because one of the main purposes of a model is to help in communication, it is often necessary to document the design of data structures. Modelio SD SQL provides automatic generation of documentation from models.

Documentation de projet