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:
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.
You can import an existing relational database via database table selection dialog, UModel also automatically adds a database profile to your project.
UModel database diagrams are organized in a special category in the Diagram Tree Helper window. Database diagrams are displayed in a form similar to class diagrams with table relationship lines similar to class associations.
As you edit your database diagram in UModel, for instance to revise a column datatype, the SQL Auto-completion helper window assists with creation of diagrams valid for the SQL database type.
The database diagram toolbar shares icons with DatabaseSpy, easing the learning curve. You can work directly in the diagram, or edit in the Properties window.
Your project model provides a level of abstraction between the design and the database, just as UML diagrams provide an abstraction for the project source code.
When you generate source code from your UModel project, any changes or additions to your database diagrams generate a Database Change Scripts with SQL commands to implement your enhancements.
Database Change Scripts created in UModel can be saved as SQL files, executed directly in the database, or opened in a DatabaseSpy SQL Editor window via a convenient button in the UModel Database Change Script dialog.
Conversely, if another team member modifies a table directly in the database, you can update the UML model by merging the database changes.
“UModel brings the 'Wow factor' to UML!”
If your project requires extensive database design, you'll want to check out the graphical database design features of DatabaseSpy, Altova's affordable multi-database query, design, and database comparison tool.
A database architect on your team can use DatabaseSpy or any other tool, and other developers can synchronize their UML models by round-trip engineering the revisions.