Previous article

Next article

UML Specification of Relational Database

Liwu Li, University of Windsor, Canada
Xin Zhao, FundMonitor, Canada



PDF Icon
PDF Version


Database reverse engineering (DBRE) recovers a database design using a semantic data model. Most of the existing works and tools for DBRE and database design specify relational database schemas with extended ER models. The Unified Modeling Language (UML) is a standard language for modeling software and database systems. We discuss how to extend the UML metamodel with elements for modeling relational dependencies. We also present techniques for converting structures of relational dependencies to UML constructs. The introduced metaelements and conversion techniques can be used in relational database design that is presented in the UML. They unify object-oriented software design and relational database design.

Note: Due to the typographical sophistication of this article, no HTML version is available. Please use the PDF version.

About the authors

space Dr. Liwu Li is a faculty member in School of Computer Science at University of Windsor, Canada. His research interests include object-oriented language design and implementation, object-oriented software analysis and design, and software process design and execution. He can be reached at

Xin Zhao received his M. Sc. Degree in Computer Science in 2001 from University Of Windsor, Canada. He is currently working at FundMonitor as a software engineer. His skills include RDBMS (SQL server), several programming languages (Java, PowerBuilder), and UML. He can be reached at

Cite this article as follows: Liwu Li, Xin Zhao: “UML Specification of Relational Database”, in Journal of Object Technology, vol. 2, no. 5, September-October 2003, pp. 87-100.

Previous article

Next article