UTHM Institutional Repository

Comparative analysis of data redundancy and execution time between relational and object-oriented schema table

Alakari, Salim Tahir and Saringat, Mohd Zainuri and Mustapha, Aida and Amerhaider Nuar, Ahmad Najmi (2017) Comparative analysis of data redundancy and execution time between relational and object-oriented schema table. International Journal on Advanced Science, Engineering and Information Technology, 7 (4-2). pp. 1562-1566. ISSN 20885334

Full text not available from this repository.


Database design is one of the important phases in designing software because the database is where the data is stored in the system. One of the most popular techniques used in database design is the relational technique, which focuses on entity relationship diagram and normalization. The relational technique is useful for eliminating data redundancy because normalization produces normal forms on the schema tables. The second technique is the object-oriented technique, which focuses on a class diagram and generating schema tables. An advantage of the object-oriented technique is its close implementation to programming languages like C++ or Java. This paper is set to compare the performance of both relational and object-oriented techniques in terms of solving data redundancy during the database design phase as well as measuring query execution time. The experimental results based on a course database case study traced 186 redundant records using the relational technique and 204 redundant records when using the object oriented technique. The query execution time measured was 46.75ms and 31.75ms for relational and object-oriented techniques, respectively.

Item Type: Article
Uncontrolled Keywords: Database design; relational technique; object-oriented technique; data redundancy; query execution time
Subjects: Q Science > QA Mathematics > QA76 Computer software
Divisions: Faculty of Computer Science and Information Technology > Department of Software Engineering
Depositing User: Mr. Mohammad Shaifulrip Ithnin
Date Deposited: 31 Mar 2019 07:37
Last Modified: 31 Mar 2019 07:37
URI: http://eprints.uthm.edu.my/id/eprint/10901
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item