---
title: "UML Database Modeling in UModel 2011"
date: "2010-09-14"
tags: 
  - "database-tool"
  - "databasespy"
  - "missionkit"
  - "uml"
  - "uml-tool"
  - "umodel"
  - "v2011"
description: Explore how UModel 2011 enhances UML database modeling by supporting various relational databases, enabling easy import, modification, and synchronization of database diagrams.
---
Status: #blog

Tags:  #database-tool #databasespy #missionkit #uml #uml-tool #umodel #v2011

Categories: [Altova](/blog/category/altova.md) 
# UML Database Modeling in UModel 2011

**As software applications interact with growing amounts of data, database designs and structures become critical to development of successful projects. UModel® 2011, just launched on September 8, 2010, adds a new feature that empowers users to extend software modeling functionality by modeling relational databases along with Java, C#, and Visual Basic software applications.** [UModel 2011](https://www.altova.com/umodel.html) accelerates database modeling with features that permits users to:

- Import existing tables from all popular relational databases to create UML database diagrams
- Modify diagrams for existing tables and generate SQL database change scripts to synchronize the database
- Design new database tables and relationships from scratch and issue SQL CREATE scripts

[![UML database diagram](https://lh4.ggpht.com/_REdrfeVqYdU/TI9_Dy0Ba2I/AAAAAAAAAOk/eRbWozXWC3Q/clip_image001%5B6%5D.gif?imgmax=800 "UML database diagram")](https://www.altova.com/umodel.html) **UModel Database Diagram Supported Databases** The UModel 2011 database diagram functionality supports multiple databases and automatically adjusts SQL dialects, data types, and other specialized features for the following databases:

- Microsoft® SQL Server® 2000, 2005, 2008
- IBM DB2® 8, 9
- IBM DB2 for iSeries® v5.4, 6.1
- Oracle® 9i, 10g, 11g
- Sybase® 12
- MySQL® 4, 5
- PostgreSQL 8
- Microsoft Access™ 2003, 2007

**UModel Database Diagram Elements** UModel 2011 database diagrams support all the following database elements:

- Database schemas
- Tables
- Views
- Check Constraints
- Primary / Foreign / Unique keys
- Indexes
- Stored procedures
- Functions
- Triggers
- Database Relationship Associations
- Database Relationship with Attributes

**Import Existing Database Structures** Users can import an existing relational database via a selection in the UModel 2011 Project menu. [![UModel Project menu](https://lh3.ggpht.com/_REdrfeVqYdU/TI9_EGm_m3I/AAAAAAAAAOo/thfTID36-sM/clip_image002%5B5%5D.gif?imgmax=800 "UModel Project menu")](https://www.altova.com/umodel.html) The Import SQL Database option opens the UModel 2011 Database Connection dialog, with the Database Connection Wizard and all the additional connection options available in [DatabaseSpy](https://www.altova.com/databasespy.html) and other [Altova MissionKit](https://www.altova.com/missionkit/software-development-tools.html) tools that interact with popular relational databases. 

![UModel database connection dialog](https://lh5.ggpht.com/_REdrfeVqYdU/TI9_ESl0WtI/AAAAAAAAAOs/Nu4A9LgWqOM/clip_image003%5B6%5D.gif?imgmax=800 "UModel database connection dialog")

When importing a database, UModel 2011 also automatically adds a database profile to the project. UModel 2011 database diagrams are displayed in a special category in the Diagram Tree Helper window. 

![UModel Diagram Tree helper window](https://lh3.ggpht.com/_REdrfeVqYdU/TI9_Ekm9rgI/AAAAAAAAAOw/mGXDK_4inc8/clip_image004%5B5%5D.gif?imgmax=800 "UModel Diagram Tree helper window")


**Modifying Databases in the Model** UModel 2011 database diagrams use a dedicated toolbar with icons indicating database elements that are shared with DatabaseSpy, easing the learning curve between tools. 

[![UModel database diagram toolbar](https://lh4.ggpht.com/_REdrfeVqYdU/TI9_EwyVGPI/AAAAAAAAAO0/iHEVllPnWdU/clip_image005%5B4%5D.gif?imgmax=800 "UModel database diagram toolbar")](https://www.altova.com/umodel.html) 

As editing proceeds in UModel 2011, the SQL Auto-completion helper window assists with creation of diagrams valid for the SQL database type. 

[![UModel database diagram SQL autocompletion window](https://lh4.ggpht.com/_REdrfeVqYdU/TI9_FDaAskI/AAAAAAAAAO4/VWi3Cf9sKis/clip_image006%5B5%5D.gif?imgmax=800 "UModel database diagram SQL autocompletion window")](https://www.altova.com/umodel.html) 

As an alternative to working directly in the diagram, users can also edit database elements in the Properties helper window. 

[![UModel database diagram Properties helper window](https://lh5.ggpht.com/_REdrfeVqYdU/TI9_Flk_jLI/AAAAAAAAAO8/7YSLYfrCjm8/clip_image007%5B6%5D.gif?imgmax=800 "UModel database diagram Properties helper window")](https://www.altova.com/umodel.html) 

**Database Change Scripts** When a developer synchronizes program code from the UModel project, changes in any database diagram generate a Database Change Script with SQL commands to implement the revisions. Database Change Scripts created in UModel can be saved as SQL files, executed directly in the database, or opened in a DatabaseSpy [SQL Editor](https://www.altova.com/databasespy/sql-editor.html) window via a convenient button in the UModel Database Change Script dialog.

[![UModel Database Change Script](https://lh5.ggpht.com/_REdrfeVqYdU/TI9_F3G62yI/AAAAAAAAAPA/VSCY_u4gq1k/clip_image008%5B6%5D.gif?imgmax=800 "UModel Database Change Script")](https://www.altova.com/umodel.html) 

Conversely, if another team member modifies a table directly in the database, a developer can update the UML model by merging the database changes. 

[![UModel Message window](https://lh6.ggpht.com/_REdrfeVqYdU/TI9_GJkqjFI/AAAAAAAAAPE/BXEAAAk7WJ4/clip_image009%5B6%5D.gif?imgmax=800 "UModel Message window")](https://www.altova.com/umodel.html) 

After synchronization of the UML model with the latest version of the database, the database diagram shows a new column in the Teachers table. 

[![UModel updated database diagram](https://lh3.ggpht.com/_REdrfeVqYdU/TI9_GfFu32I/AAAAAAAAAPI/DMNuMrOoay8/clip_image010%5B6%5D.gif?imgmax=800 "UModel updated database diagram")](https://www.altova.com/umodel.html) 

Like all other UModel diagram types, UModel 2011 lets users save database diagrams as image files and include them in automatically-generated [project documentation](https://www.altova.com/umodel/uml-project-documentation.html). Visit the Altova [What’s New page](https://www.altova.com/whatsnew.html) to learn more about all the new features in the Altova MissionKit 2011. **Model databases along with system requirements, business rules, and application code for your next development project –** [**click here to download a free 30-day trial**](https://www.altova.com/download/umodel/uml_tool_enterprise.html) **of UModel 2011 today!**