A comparative analysis of data redundancy and execution time between relational and object oriented schema table

Alakari, Salim Tahir (2014) A comparative analysis of data redundancy and execution time between relational and object oriented schema table. Masters thesis, Universiti Tun Hussein Onn Malaysia.

[img]PDF
756Kb

Abstract

The design of database is one of the important parts in building software, because database is the data storage inside the system. There are some techniques that allow the programmer to improve design of the database. One of the most popular techniques being used for database is the relational technique, which content entity relationship diagram and normalization. The relational technique is easy to use and useful for reducing data redundancy because the normalization technique solves the data redundancy by applying normalization normal forms on the schema tables. The second technique is the object oriented technique, which content class diagram and generate schema table. An advantage of object oriented technique is its closeness to programming languages like C++ or C#. This project is starting with applying relational technique and object oriented technique to define which technique uses less data redundancy during design database. Based on experimental results for total data redundancy in HMS case study was 336 for relational technique and 364 for object oriented technique as well as, course database case study was 186 for relational technique and 204 for object oriented technique. Also, this project is focus on query execution time between relational databases and object oriented database by using user friendly window. The experimental result for query execution time in HMS case study was 107.25 milliseconds for RDBMS and 80.5 milliseconds for OODBMS. In course database case study was 46.75 milliseconds for RDBMS and 31.75 milliseconds for OODBMS. However, the comparative analysis in this project is explaining the result of comparison between relational and object oriented techniques specifically with data redundancy and query execution time.

Item Type:Thesis (Masters)
Subjects:Q Science > QA Mathematics > QA75 Calculating machines > QA75.5 Electronic computers. Computer science
ID Code:7059
Deposited By:Normajihan Abd. Rahman
Deposited On:09 Nov 2015 14:42
Last Modified:09 Nov 2015 14:42

Repository Staff Only: item control page