Using UML class diagrams for a comparative analysis of relational, object-oriented, and object-relational database mappings

Authors:
Susan D. Urban;Suzanne W. Dietrich
Affiliations:
Arizona State University, Tempe, AZ;Arizona State University, Tempe, AZ
Venue:
SIGCSE '03 Proceedings of the 34th SIGCSE technical symposium on Computer science education
Year:
2003

Citing 6
Cited 0

The Unified Modeling Language reference manual

The Unified Modeling Language reference manual
The object data standard: ODMG 3.0

The object data standard: ODMG 3.0
A reusable graphical user interface for manipulating object-oriented databases using Java and XML

Proceedings of the thirty-second SIGCSE technical symposium on Computer Science Education
Oracle Programming: A Primer

Oracle Programming: A Primer
Fundamentals of Database Systems

Fundamentals of Database Systems
JDBC demonstration courseware using Servlets and Java Server Pages

SIGCSE '02 Proceedings of the 33rd SIGCSE technical symposium on Computer science education

Quantified Score

Hi-index	0.00

Visualization

Abstract

This paper illustrates the manner in which UML can be used to study mappings to different types of database systems. After introducing UML through a comparison to the EER model, UML diagrams are used to teach different approaches for mapping conceptual designs to the relational model. As we cover object-oriented and object-relational database systems, different features of UML are used over the same enterprise example to help students understand mapping alternatives for each model. Students are required to compare and contrast the mappings in each model as part of the learning process. For object-oriented and object-relational database systems, we address mappings to the ODMG and SQL99 standards in addition to specific commercial implementations.