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
