Performance evaluation of an RDB and an ORDB: A comparative study using the BUCKY benchmark

• Published in: 2016 International Conference on Engineering & MIS (ICEMIS) pp. 1 - 7
• Main Authors: Maatuk, Abdelsalam M., Ali, M. Akhtar, Moftah, Raja A., Elkobaisi, Mohammed R.
• Format: Conference Proceeding
• Language: English
• Published: IEEE 01-09-2016
• Subjects: Benchmark testing; benchmarks; Buildings; Indexes; Loading; Object-relational database; Performance evaluation; Relational database
• DOI: 10.1109/ICEMIS.2016.7745312

This paper highlights the functionality of object-based database systems by comparing the performance of relational database (RDB) and object-relational database (ORDB) systems. The study focuses on assessing the efficiency of database systems based on query processing and object complexity. We conducted an experiment that includes running the queries on the RDB and ORDB that were used in the BUCKY benchmark and implemented on Oracle 11g. The findings of this research show that the performance of both database systems depends on various factors, such as the size and type of databases, the schema and query structures, the number of tuples scanned in tables, indexes as well as the environment, in which the experiment was carried out.