Universiti Teknologi Malaysia Institutional Repository

Pengoptimuman skema logikal pangkalan data hubungan : kajian kes pangkalan data sistem maklumat hidrologi Malaysia

Kurmin, Norazrin (2006) Pengoptimuman skema logikal pangkalan data hubungan : kajian kes pangkalan data sistem maklumat hidrologi Malaysia. Masters thesis, Universiti Teknologi Malaysia, Faculty of Computer Science and Information System.

[img] PDF (Full text)
Restricted to Repository staff only

1567Kb
[img] PDF
72Kb
[img] PDF
85Kb
[img] PDF
83Kb

Abstract

It is important to ensure that storing, retrieving, and data manipulating could be done efficiently in a database. This research is focused on the data access in Sistem Maklumat Hidrologi Malaysia (SMHM). The main issue that attracts researchers is low execution time in accessing data. The factor that causes the problem is the structure of the database. Besides, there is such a huge amount of data in SMHM database. Hence, this research produces an optimization technique of relational database logical scheme in order to fix the problem. The technique that has been produced is based on equijoin technique in which two entities that hold the same attribute will be joined and also the tuple classification. In addition, query will be analyzed in order to produce a maximum optimal execution. Comparison has been done on the techniques that have been developed and the SMHM cube system which is the previous technique. The results of the research prove that the technique that has been produced could improve the execution time for query processor, and solve the issue that has been discussed.

Item Type:Thesis (Masters)
Additional Information:Sarjana Sains (Sains Komputer) - Universiti Teknologi Malaysia, 2006; Supervisor I : Assoc. Prof. Dr. Harihoddin Selamat; Supervisor II : Mohd. Shafry Mohd. Rahim; Supervisor III : Mohd. Taib Wahid
Uncontrolled Keywords:Query optimization; hydrology data, database, join, retrieval
Subjects:Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Divisions:Computer Science and Information System (Formerly known)
ID Code:3712
Deposited By: Ms Zalinda Shuratman
Deposited On:26 Jun 2007 03:11
Last Modified:11 Jul 2012 01:16

Repository Staff Only: item control page