Browse > Article

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

Joo, Kyung-Soo (순천향대학교 컴퓨터소프트웨어공학과)
Jho, Do-Hyung (순천향대학교 컴퓨터소프트웨어공학과)
Publication Information
Journal of Internet Computing and Services / v.12, no.6, 2011 , pp. 149-159 More about this Journal
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.
Keywords
Object-Relational; Database; UML; SQL:1999; Oracle 11g;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 Eric Pardede, J. Wenny Rahayu, David Taniar, "Mapping Methodos and Query for Aggregation and Association in Object- Relational Database using Collection", Proceedings of the International Conference on Information Technology : Cooding and Computing(ITCC'04), 2004.
2 김인철, 김영웅, "확장된 UML 클래스 다이어그램을 이용한 객체 관계형 데이터베이스 설계 기법", 정보처리학회 추계학술발표회, 제 12권, 제2호, pp.91-94, 2005.
3 Eisenberg and Melton, "SQL:1999, formerly known as SQL3", ACM SIGMOD Record, Vol. 28, No. 1, pp. 131-138, 1999.   DOI
4 Mattos, N. M, "SQL:1999, SQL/MM and SQLJ: An Overview of the SQL Standards", IBM Database Common Technology, 1999.
5 Oracle Corporation, Oracle11g SQL Reference Release 2 (11.2), In: www.oracle.com. 2011.
6 J. Conallen, "Building Web Application with UML", Addison-Wesley, 2000.
7 Ambler, Persistence Modeling in the UML, In: http://www.sdmagazine.com/articles/1999/0008/0008 q/0008q.htm, 1999.
8 Atzeni, Ceri, Paraboschi and Torlone, "Database Systems. Concepts, Languages and Architectures", McGraw-Hill, 1999.
9 E. Marcos, B. Vela and J. M. Cavero, "A Methodology for Object-Relational Database Design Using UML", submitted to 12th International Conference and Workshop on Database and Expert Systems and Applications, 2001.
10 E. Marcos, B. Vela and J. M. Cavero, "Aggregation and Composition in Object-Relational Database Design", submitted to Fifth East European Conference on Advances in Databases and Information Systems, 2001.
11 Bertino and Marcos, "Object Oriented Database Systems", In Advanced Databases: Technology and Design, O. Diaz and M. Piattini (Eds. Artech House), 2000.
12 Stonebraker and Brown, "Object-Relational DBMSs", Traking the Next Great Wave, Morgan Kauffman, 1999.
13 Blaha and Premerlani, "Object-Oriented Modeling and Design for Database Applications", Prentice Hall, 1998.
14 C. Kovacs and P. Van Bommel, "Conceptual modelling-based design of objectoriented databases", Information and Software Technology, Vol. 40, No. 1, pp. 1-14, 1998.   DOI   ScienceOn
15 Muller, "Database Design for Smarties", Morgan Kaufmann, 1999.
16 Silva and Carlson, "MOODD, a method for object-oriented database design", Data & Knowledge Engineering, Vol. 17, pp.159-181, 1995.   DOI   ScienceOn
17 Ullman and Widom, "A First Course in Database Systems", Prentice-Hall, 1997.
18 Booch, Rumbaugh and Jacobson, "The Unified Modeling Language User Guide", Addison Wesley. 1999.
19 김영규, 양해술, 최형진, "객체지향 환경에 서 소프트웨어 생산성 향상을 위한 프레임워크 모델", 한국산학기술학회 논문지, 제 9권, 제6호, 2008.
20 이현우, 박찬석, 고석하, "객체지향 개발 프로세스에서 비즈니스 프로세스 모델과 소프트웨어 아키텍처의 관계 연구를 위한 접근방법의 제언", Entrue Journal of Information Technology, Vol. 8, No. 2, 2009.
21 E. Marcos, B. Vela and J. M. Cavero, "Extending UML for Object-Relational Database Design", Kybele Research Group, Rey Juan Carlos University, Madrid. UML 2001, LNCS 2185, pp. 225-239, 2001.