Comparing Data Retrieval in RDBMS and ORDBMS Using Company Directory Database

• Main Authors: Lwin, May Thet, Tun, Khin Mar Lar
• Language: unknown
• Published: 2017
• Subjects: DML
• Online Access: https://hdl.handle.net/20.500.12678/0000003230; https://meral.edu.mm/records/3230

There are different types of DatabaseManagement System. Each has their own modeland architecture for data storage. In this paper,we compare Data Retrieval efficiency betweenRelational Database Management System(RDBMS) and Object-Relational DatabaseManagement System (ORDBMS), and the DataModel, Data Definition Language (DDL),DataManipulation Language (DML), Key Constraint,Index Structure are also compared. ORDBMSsupports many types and structures of objectmodels. The two structures of object models;object types and reference types (REF) forORDBMS arealso compared. The case study fordatabase uses company directory database. Theexperimental results show that the ORDBMSoutperform in data retrieval for complex querystatements because of direct linkage between datarecords in storage instead of logical linking (tablejoin).Oracle 11 g database software is used tobuild both RDBMS and ORDBMS