The mapping between data objects and UML elements
Databases are visualized in Unified Modeling Language (UML) class diagrams based on the defined mapping between database elements and UML diagram elements.
The following table shows how relational database (RDB) elements map to UML elements and stereotypes with icons in UML class diagrams. A stereotype is an extension mechanism that broadens the vocabulary of UML and gives more specific meaning to a database element.
| RDB element | UML element | Stereotype | Icon |
|---|---|---|---|
| Database | Component | <<Database>> |
|
| Schema | Schema | <<Schema>> |
|
| View | Class | <<Database View>> |
|
| Table | Class | <<Table>> |
|
| Column | Attribute | <<Column>> |
|
| Stored procedure | Operation | <<Stored Procedure>> |
|
| User-defined function | Operation | <<User Defined Function>> |
|
| Java Database Connectivity (JDBC) connection | Component | <<Connection>> |
|
Parent topic
UML visualization reference