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

Abdelsalam Maatuk; Akhtar Ali; Raja A. Moftah; Mohammed R. Elkobaisi

doi:10.1109/ICEMIS.2016.7745312

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

Abdelsalam Maatuk, Akhtar Ali, Raja A. Moftah, Mohammed R. Elkobaisi

Computer and Information Sciences Department

Research output: Contribution to conference › Paper

1 Citation (Scopus)

28 Downloads (Pure)

Abstract

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.

Original language	English
DOIs	https://doi.org/10.1109/ICEMIS.2016.7745312
Publication status	Published - 22 Sept 2016
Event	ICEMIS 2016 - International Conference on Engineering & MIS - Agadir, Morocco Duration: 22 Sept 2016 → …

Conference

Conference	ICEMIS 2016 - International Conference on Engineering & MIS
Period	22/09/16 → …

Keywords

Relational database
Object-relational database
benchmarks

Access to Document

10.1109/ICEMIS.2016.7745312

Maatuk et al - Performance evaluation of an RDB and an ORDBFinal published version, 284 KB

Cite this

@conference{a1af4c17452d4c87b06615a35f408414,

title = "Performance evaluation of an RDB and an ORDB: A comparative study using the BUCKY benchmark",

abstract = "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.",

keywords = "Relational database, Object-relational database, benchmarks",

author = "Abdelsalam Maatuk and Akhtar Ali and Moftah, {Raja A.} and Elkobaisi, {Mohammed R.}",

year = "2016",

month = sep,

day = "22",

doi = "10.1109/ICEMIS.2016.7745312",

language = "English",

note = "ICEMIS 2016 - International Conference on Engineering & MIS ; Conference date: 22-09-2016",

}

TY - CONF

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

AU - Maatuk, Abdelsalam

AU - Ali, Akhtar

AU - Moftah, Raja A.

AU - Elkobaisi, Mohammed R.

PY - 2016/9/22

Y1 - 2016/9/22

N2 - 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.

AB - 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.

KW - Relational database

KW - Object-relational database

KW - benchmarks

U2 - 10.1109/ICEMIS.2016.7745312

DO - 10.1109/ICEMIS.2016.7745312

M3 - Paper

T2 - ICEMIS 2016 - International Conference on Engineering & MIS

Y2 - 22 September 2016

ER -

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

Abstract

Conference

Keywords

Access to Document

Fingerprint

Cite this