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
Tags:	Add Tag No Tags, Be the first to tag this record!

id	my-uthm-ep.1672
record_format	uketd_dc
spelling	my-uthm-ep.16722021-10-04T08:32:00Z A comparative analysis of data redundancy and execution time between relational and object oriented schema table 2014-12 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 http://eprints.uthm.edu.my/1672/ http://eprints.uthm.edu.my/1672/1/24p%20SALIM%20TAHIR%20ALAKARI.pdf text en public http://eprints.uthm.edu.my/1672/2/SALIM%20TAHIR%20ALAKARI%20COPYRIGHT%20DECLARATION.pdf text en staffonly http://eprints.uthm.edu.my/1672/3/SALIM%20TAHIR%20ALAKARI%20WATERMARK.pdf text en validuser mphil masters Universiti Tun Hussein Onn Malaysia Fakulti Sains Komputer dan Teknologi Maklumat
institution	Universiti Tun Hussein Onn Malaysia
collection	UTHM Institutional Repository
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
qualification_name	Master of Philosophy (M.Phil.)
qualification_level	Master's degree
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
granting_institution	Universiti Tun Hussein Onn Malaysia
granting_department	Fakulti Sains Komputer dan Teknologi Maklumat
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
_version_	1747830843478376448

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

Similar Items