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...
| Main Author: | |
|---|---|
| Format: | Thesis |
| Language: | English English English |
| Published: |
2014
|
| Subjects: | |
| 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 |
| _version_ | 1796868505451102208 |
|---|---|
| author | Alakari, Salim Tahir |
| author_facet | Alakari, Salim Tahir |
| author_sort | Alakari, Salim Tahir |
| collection | UTHM |
| 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. |
| first_indexed | 2024-03-05T21:40:47Z |
| format | Thesis |
| id | uthm.eprints-1672 |
| institution | Universiti Tun Hussein Onn Malaysia |
| language | English English English |
| last_indexed | 2024-03-05T21:40:47Z |
| publishDate | 2014 |
| record_format | dspace |
| spelling | 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. |
| 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 |
| title | 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_short | 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 |
| topic | QA76 Computer software QA75-76.95 Calculating machines |
| 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 |
| work_keys_str_mv | AT alakarisalimtahir acomparativeanalysisofdataredundancyandexecutiontimebetweenrelationalandobjectorientedschematable AT alakarisalimtahir comparativeanalysisofdataredundancyandexecutiontimebetweenrelationalandobjectorientedschematable |