Abstract: This paper introduces how to use the object-relational database management system (ORDBMS) to solve relational database (RDB) problems in an advanced database course. The purpose of the paper is to provide a guideline for database instructors who desire to incorporate the ORDB technology in their traditional database courses. The paper presents how to use the specific object-relational database (ORDB) technology to solve three normalization problems: Transitive dependency, Multi-value attributes, and Non-1st Normal Form. The paper also provides the solutions to data complexity problems with three specific ORDBMS techniques: object view, object inheritance, and object integration. The paper summarizes the significance and advantages of teaching ORDBMSs in advanced database courses. Course contents and students’ learning outcomes are discussed. To be more helpful to database educators, the paper presents a complete object-relational database development case study from the UML class diagram design to Oracle ORDBMS implementation.
Keywords: classroom cases, IS Curriculum, Object-relational database, Database, Oracle Database , Normalization
Download this article: ISEDJ - V9 N4 Page 80.pdf
Recommended Citation: Wang, M. (2011). Sovling Relational Database Problems with ORDBMS in an Advanced Database Course. Information Systems Education Journal, 9(4) pp 80-90. http://isedj.org/2011-9/ ISSN: 1545-679X. (A preliminary version appears in The Proceedings of ISECON 2010)