Cover Image

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

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

Full description

Saved in:
Bibliographic Details
Main Author: Alakari, Salim Tahir
Format: Thesis
Language:English
English
English
Published: 2014
Subjects:
QA76 Computer software
QA75-76.95 Calculating machines
Online Access:http://eprints.uthm.edu.my/1672/1/24p%20SALIM%20TAHIR%20ALAKARI.pdf
http://eprints.uthm.edu.my/1672/2/SALIM%20TAHIR%20ALAKARI%20COPYRIGHT%20DECLARATION.pdf
http://eprints.uthm.edu.my/1672/3/SALIM%20TAHIR%20ALAKARI%20WATERMARK.pdf
http://eprints.uthm.edu.my/1672/
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.uthm.eprints.1672
record_format eprints
spelling my.uthm.eprints.16722021-10-04T08:32:00Z http://eprints.uthm.edu.my/1672/ A comparative analysis of data redundancy and execution time between relational and object oriented schema table Alakari, Salim Tahir QA76 Computer software QA75-76.95 Calculating machines 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. 2014-12 Thesis NonPeerReviewed text en http://eprints.uthm.edu.my/1672/1/24p%20SALIM%20TAHIR%20ALAKARI.pdf text en http://eprints.uthm.edu.my/1672/2/SALIM%20TAHIR%20ALAKARI%20COPYRIGHT%20DECLARATION.pdf text en http://eprints.uthm.edu.my/1672/3/SALIM%20TAHIR%20ALAKARI%20WATERMARK.pdf 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.
institution Universiti Tun Hussein Onn Malaysia
building UTHM Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Tun Hussein Onn Malaysia
content_source UTHM Institutional Repository
url_provider http://eprints.uthm.edu.my/
language English
English
English
topic QA76 Computer software
QA75-76.95 Calculating machines
spellingShingle QA76 Computer software
QA75-76.95 Calculating machines
Alakari, Salim Tahir
A comparative analysis of data redundancy and execution time between relational and object oriented schema table
description 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.
format Thesis
author Alakari, Salim Tahir
author_facet Alakari, Salim Tahir
author_sort Alakari, Salim Tahir
title A comparative analysis of data redundancy and execution time between relational and object oriented schema table
title_short A comparative analysis of data redundancy and execution time between relational and object oriented schema table
title_full A comparative analysis of data redundancy and execution time between relational and object oriented schema table
title_fullStr A comparative analysis of data redundancy and execution time between relational and object oriented schema table
title_full_unstemmed A comparative analysis of data redundancy and execution time between relational and object oriented schema table
title_sort comparative analysis of data redundancy and execution time between relational and object oriented schema table
publishDate 2014
url http://eprints.uthm.edu.my/1672/1/24p%20SALIM%20TAHIR%20ALAKARI.pdf
http://eprints.uthm.edu.my/1672/2/SALIM%20TAHIR%20ALAKARI%20COPYRIGHT%20DECLARATION.pdf
http://eprints.uthm.edu.my/1672/3/SALIM%20TAHIR%20ALAKARI%20WATERMARK.pdf
http://eprints.uthm.edu.my/1672/
_version_ 1738580890319060992
score 13.211869

Similar Items