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...
| Main Author: | |
|---|---|
| Format: | Thesis |
| Language: | English |
| Published: |
2006
|
| Subjects: | |
| Online Access: | http://eprints.utm.my/3712/ http://eprints.utm.my/3712/1/NorazrinKurminMFSKSM2006.pdf |
| _version_ | 1848890631912423424 |
|---|---|
| author | Kurmin, Norazrin |
| author_facet | Kurmin, Norazrin |
| author_sort | Kurmin, Norazrin |
| building | UTeM Institutional Repository |
| collection | Online Access |
| 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. |
| first_indexed | 2025-11-15T20:45:09Z |
| format | Thesis |
| id | utm-3712 |
| institution | Universiti Teknologi Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T20:45:09Z |
| publishDate | 2006 |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | utm-37122018-01-10T04:27:29Z http://eprints.utm.my/3712/ Pengoptimuman skema logikal pangkalan data hubungan : kajian kes pangkalan data sistem maklumat hidrologi Malaysia 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 NonPeerReviewed application/pdf en http://eprints.utm.my/3712/1/NorazrinKurminMFSKSM2006.pdf 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. |
| spellingShingle | QA75 Electronic computers. Computer science Kurmin, Norazrin Pengoptimuman skema logikal pangkalan data hubungan : kajian kes pangkalan data sistem maklumat hidrologi Malaysia |
| title | 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_short | 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 |
| topic | QA75 Electronic computers. Computer science |
| url | http://eprints.utm.my/3712/ http://eprints.utm.my/3712/1/NorazrinKurminMFSKSM2006.pdf |