Modeling Relational Databases in UML
Database designs and structures are a critical component to many development projects. Support for UML database diagrams in UModel makes it easy to extend the advantages of visual UML modeling to databases, whether you need to create UML diagrams from existing tables, modify diagrams to and sychronize the database, or design new tables and relationships.
UModel supports all major relational databases:
- Firebird 2.5, 3, 4
- IBM DB2 for iSeries® v6.1, 7.1, 7.2, 7.3, 7.4
- IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5, 11.5, 11.5.7
- Informix® 11.70, 12.10, 14.10
- MariaDB 10, 10.3, 10.4, 10.5, 10.6.5, 10.9.2, 10.11, 11.2, 11.4
- Microsoft Access™ 2003, 2007, 2010, 2013, 2019
- Microsoft® Azure SQL
- Microsoft® SQL Server® 2005-2022
- MySQL® 5, 5.1, 5.5, 5.6, 5.7, 8, 8.0.25, 8.0.28, 8.2, 8.3, 8.4
- Oracle® 9i, 10g, 11g, 12c, 18, 19
- PostgreSQL 8, 9, 10, 11, 12, 13, 14, 15, 16
- Progress OpenEdge 11.6
- SQLite 3.x
- Sybase® ASE 15, 16
- Teradata 16
You can easily import an entire relational database in a single step, or choose only the tables in the database that are relevant to your project, to model data structures along with your software application. The UModel Database Connection Wizard makes it easy to connect to your databases quickly.
The UML database diagram functionality in UModel supports multiple databases and automatically adjusts SQL dialects, data types and other specialized features based on the database type. UModel supports these database elements: database schemas, tables, views, check constraints, primary / foreign / unique keys, indexes, stored procedures, functions, triggers, database relationship associations, and database relationships with attributes.