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

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

Full description

Saved in:

Bibliographic Details
Main Author:	Kurmin, Norazrin
Format:	Thesis
Language:	English
Published:	2006
Subjects:	QA75 Electronic computers Computer science
Online Access:	http://eprints.utm.my/id/eprint/3712/1/NorazrinKurminMFSKSM2006.pdf
Tags:	Add Tag No Tags, Be the first to tag this record!

id	my-utm-ep.3712
record_format	uketd_dc
spelling	my-utm-ep.37122018-01-10T04:27:29Z Pengoptimuman skema logikal pangkalan data hubungan : kajian kes pangkalan data sistem maklumat hidrologi Malaysia 2006-03 Kurmin, Norazrin QA75 Electronic computers. Computer science 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. 2006-03 Thesis http://eprints.utm.my/id/eprint/3712/ http://eprints.utm.my/id/eprint/3712/1/NorazrinKurminMFSKSM2006.pdf application/pdf en public masters Universiti Teknologi Malaysia, Faculty of Computer Science and Information System Faculty of Computer Science and Information System
institution	Universiti Teknologi Malaysia
collection	UTM Institutional Repository
language	English
topic	QA75 Electronic computers Computer science
spellingShingle	QA75 Electronic computers Computer science Kurmin, Norazrin Pengoptimuman skema logikal pangkalan data hubungan : kajian kes pangkalan data sistem maklumat hidrologi Malaysia
description	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.
format	Thesis
qualification_level	Master's degree
author	Kurmin, Norazrin
author_facet	Kurmin, Norazrin
author_sort	Kurmin, Norazrin
title	Pengoptimuman skema logikal pangkalan data hubungan : kajian kes pangkalan data sistem maklumat hidrologi Malaysia
title_short	Pengoptimuman skema logikal pangkalan data hubungan : kajian kes pangkalan data sistem maklumat hidrologi Malaysia
title_full	Pengoptimuman skema logikal pangkalan data hubungan : kajian kes pangkalan data sistem maklumat hidrologi Malaysia
title_fullStr	Pengoptimuman skema logikal pangkalan data hubungan : kajian kes pangkalan data sistem maklumat hidrologi Malaysia
title_full_unstemmed	Pengoptimuman skema logikal pangkalan data hubungan : kajian kes pangkalan data sistem maklumat hidrologi Malaysia
title_sort	pengoptimuman skema logikal pangkalan data hubungan : kajian kes pangkalan data sistem maklumat hidrologi malaysia
granting_institution	Universiti Teknologi Malaysia, Faculty of Computer Science and Information System
granting_department	Faculty of Computer Science and Information System
publishDate	2006
url	http://eprints.utm.my/id/eprint/3712/1/NorazrinKurminMFSKSM2006.pdf
_version_	1747814467060629504

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

Similar Items