Comparing Data Retrieval in RDBMS and ORDBMS Using Company Directory Database

Abstract

There are different types of Database Management System. Each has their own model and architecture for data storage. In this paper, we compare Data Retrieval efficiency between Relational Database Management System (RDBMS) and Object-Relational Database Management System (ORDBMS), and the Data Model, Data Definition Language (DDL),Data Manipulation Language (DML), Key Constraint, Index Structure are also compared. ORDBMS supports many types and structures of object models. The two structures of object models; object types and reference types (REF) for ORDBMS arealso compared. The case study for database uses company directory database. The experimental results show that the ORDBMS outperform in data retrieval for complex query statements because of direct linkage between data records in storage instead of logical linking (table join).Oracle 11 g database software is used to build both RDBMS and ORDBMS