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...
Saved in:
| 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 http://eprints.uthm.edu.my/1672/ |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Summary: | 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. |
|---|