Kyung-Soo Joo, Do-Hyung Jho, Journal of Internet Computing and Services, Vol. 12, No. 6, pp. 149-160, Dec. 2011
Full Text:  HTML
Keywords: Object-Relational, database, UML, SQL:1999, Oracle 11g

Abstract

The current applications can be characterized as consisting of complex objects related by complex relationship. Therefore the relational database has been extended to object-relational database because of the complex objects. Accordingly, we need database design methodology for object-relational database. In this pager, we develop an integrated design methodology based on a extended UML class diagram for object-relational database. We make the extend UML class diagram by adding new stereotypes for object-relational database. Also we propose a guideline for transforming the extended UML class diagram to object-relational database schema. We use SQL:1999 as a object-relational data model and Oracle11g as a target object-relational database. We can build more easily and efficiently object-relational database for Oracle11g by using our methodology. Finally we applied our methodology on a computer classroom reservation system for evaluation the methodology.

Statistics
Cite this article