DOI : https://doi.org/10.18517/ijaseit.7.4-2.3401

Comparative Analysis of Data Redundancy and Execution Time between Relational and Object-Oriented Schema Table

Salim Tahir Alakari (1), Mohd Zainuri Saringat (2), Aida Mustapha (3), Ahmad Najmi Amerhaider Nuar (4)
(1) Soft Computing and Data Mining Centre, Faculty of Computer Science and Information Technology, Universiti Tun Hussein Onn Malaysia, 86400 Batu Pahat, Johor, Malaysia
(2) Faculty of Computer Science and Information Technology, Universiti Tun Hussein Onn Malaysia, 86400 Batu Pahat, Johor, Malaysia
(3) Soft Computing and Data Mining Centre, Faculty of Computer Science and Information Technology, Universiti Tun Hussein Onn Malaysia, 86400 Batu Pahat, Johor, Malaysia
(4) Tagme Solutions, No 24 -1, Jalan Universiti 1, Taman Universiti 86400 Parit Raja, Batu Pahat Johor, Malaysia
Fulltext View | Download
How to cite (IJASEIT) :
Alakari, Salim Tahir, et al. “Comparative Analysis of Data Redundancy and Execution Time Between Relational and Object-Oriented Schema Table”. International Journal on Advanced Science, Engineering and Information Technology, vol. 7, no. 4-2, Sept. 2017, pp. 1562-6, doi:10.18517/ijaseit.7.4-2.3401.
Citation Format :
Database design is one of the important phases in designing software because database is where the data is stored inside 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 class diagram and generating schema tables. An advantage of 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.
Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Authors who publish with this journal agree to the following terms:

    1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
    2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
    3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).