UML Specification of Relational Database
Liwu Li, University of Windsor, Canada
Xin Zhao, FundMonitor, Canada
|
 |
REFEREED
ARTICLE

PDF Version |
Abstract
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

|
 |
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 mailto:liwu@uwindsor.ca.
|
 |
|
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 mailto:timzhao@fundmonitor.com.
|
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. http://www.jot.fm/issues/issue_2003_09/article1
|