Mappings between data objects and UML elements

Database objects are represented in Unified Modeling Language (UML) class diagram views based on the defined mapping between database elements and UML diagram elements.

The following table illustrates 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>> The image shows the RDB database icon.
Schema Schema <<Schema>> The image shows the RDB schema icon.
View Class <<Database View>> The image shows the RDB view icon.
Table Class <<Table>> The image shows the RDB table icon.
Column Attribute <<Column>> The image shows the RBD column icon.
Stored procedure Operation <<Stored Procedure>> The image shows the RBD stored procedure icon.
User-defined function Operation <<User Defined Function>> The image shows the RDB user define function icon.
Java™ Database Connectivity (JDBC) connection Component <<Connection>> The image shows the JDBC connection icon.
Related reference
UML modeling best practices
Mappings between EJB and UML elements
Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.