• Journal of Internet Computing and Services
    ISSN 2287 - 1136(Online) / ISSN 1598 - 0170 (Print)
    http://jics.or.kr/

UML Extension for Object-Relational Database Design - Focusing on Oracle11g -


Kyung-Soo Joo, Do-Hyung Jho, Journal of Internet Computing and Services, Vol. 12, No. 6, pp. 149-160, Dec. 2011
Full Text:
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
Show / Hide Statistics

Statistics (Cumulative Counts from November 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


Cite this article
[APA Style]
Kyung-Soo Joo and Do-Hyung Jho (2011). UML Extension for Object-Relational Database Design - Focusing on Oracle11g -. Journal of Internet Computing and Services, 12(6), 149-160.

[IEEE Style]
K. Joo and D. Jho, "UML Extension for Object-Relational Database Design - Focusing on Oracle11g -," Journal of Internet Computing and Services, vol. 12, no. 6, pp. 149-160, 2011.

[ACM Style]
Kyung-Soo Joo and Do-Hyung Jho. 2011. UML Extension for Object-Relational Database Design - Focusing on Oracle11g -. Journal of Internet Computing and Services, 12, 6, (2011), 149-160.