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.
- Cattell, R. G. G. The Object Database Standard: ODMG 3.0, Morgan Kaufmann, 2000. Google ScholarDigital Library
- Dietrich, S. W. and Urban, S. D., and Kyriakides, I., "JDBC Demonstration Courseware Using Servlets and Java Server Pages," ACM SIGCSE Conference, Kentucky, Feb. 2002, pp. 266--270. Google ScholarDigital Library
- Dietrich, S. W., Suceava, D., Cherekuri, C., and Urban, S. D., "A Reusable Graphical Interface for Manipulating Object-Oriented Databases Using Java and XML," ACM SIGCSE Conference, North Carolina, Feb. 2001, pp. 362--366. Google ScholarDigital Library
- Elmasri, R. and Navathe, S. Fundamentals of Database Systems, 3rd ed., Addison Wesley, 2000. Google ScholarDigital Library
- Gulutzan, P. and Pelzer, T., SQL-99 Complete: Really!, R&D Books, Lawrence, Kansas, 1999.Google Scholar
- Objectivity/DB Version 7, Objectivity, Inc., Mountain View, CA.Google Scholar
- Rumbaugh, J., Jacobson, I., and G. Booch, The Unified Modeling Language Reference Manual, Addison Wesley, Upper Saddle River, New Jersey, 1999. Google ScholarDigital Library
- Sunderraman, R., Oracle 8 Programming: A Primer, Addison Wesley, 2000. Google ScholarDigital Library
Index Terms
- Using UML class diagrams for a comparative analysis of relational, object-oriented, and object-relational database mappings
Recommendations
Model transformation for object-relational database development
SAC '07: Proceedings of the 2007 ACM symposium on Applied computingIn this paper we define and formalize the model transformations that complete the methodological approach for the development of Object-Relational (OR) Databases (DB) proposed in MIDAS, a model driven methodology for the development of Web Information ...
Using UML class diagrams for a comparative analysis of relational, object-oriented, and object-relational database mappings
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 ...
Transforming UML class diagrams into relational data models
UML and the unified processThe Entity-Relationship (ER) method is the most popular method for relational database design. On the other hand, the Unified Modeling Language (UML) is widely used in object-oriented analysis and design. Despite the increasing use of object-oriented ...
Comments