An equijoin-optimization technique for Malaysian Hydrological Information System (MHIS) data
Malaysian Hydrological Information System (MHIS) is one of the GIS applications that storing a large amount of data (such as rainfall, water level, evaporation and water quality). In such situation, it is important to ensure that the storage, retrieval and manipulation of these data are efficiently...
| Main Authors: | , , , |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English |
| Published: |
2005
|
| Subjects: | |
| Online Access: | http://eprints.utm.my/3355/1/Harihodin%2C_Haji_Taib_-_An_Equijoin-Optimization_Technique_For.pdf |
| _version_ | 1796853554321817600 |
|---|---|
| author | Kurmin, Norazrin Selamat, Harihodin Wahid, Mohd. Taib Mohd. Rahim, Mohd. Shafry |
| author_facet | Kurmin, Norazrin Selamat, Harihodin Wahid, Mohd. Taib Mohd. Rahim, Mohd. Shafry |
| author_sort | Kurmin, Norazrin |
| collection | ePrints |
| description | Malaysian Hydrological Information System (MHIS) is one of the GIS applications that storing a large amount of data (such as rainfall, water level, evaporation and water quality). In such situation, it is important to ensure that the storage, retrieval and manipulation of these data are efficiently handled. However, the problem in MHIS is inefficient on retrieval data where it takes a long time to retrieve data. MHIS was developed based on cube system concept. The main objective introduced the cube system is to describe how the hydrology data will be store and retrieve in relational database. However, it is still lacking to handle a large amount of data. Thus, this paper proposed an Equijoin Optimization Technique to solve that problem. This technique was introduced based on modification of an equijoin method where an entity will be joined based on equijoin algorithm. In other words, the result relation is a new entity, T, contains tuples t made up of two tuples r and s, where r must be tuple in entity R and s must be tuple in entity S. Then, there are entity will be classified to other entity based on the appropriate attribute. Based on this technique, a SQL statement was created for data retrieval processing which is referring to the optimized entity. There are four main function in that process i) Select ii) Initialize iii) Operation and iv) Output. Also, in this research, testing and comparison analysis has been done between proposed technique, an Equijoin optimization and the previous technique MHIS Cube System. The result of the testing shows that the proposed technique can improve an execution time for query processing, then solve the issue has been discussed on this research. |
| first_indexed | 2024-03-05T18:01:15Z |
| format | Conference or Workshop Item |
| id | utm.eprints-3355 |
| institution | Universiti Teknologi Malaysia - ePrints |
| language | English |
| last_indexed | 2024-03-05T18:01:15Z |
| publishDate | 2005 |
| record_format | dspace |
| spelling | utm.eprints-33552017-08-30T07:31:59Z http://eprints.utm.my/3355/ An equijoin-optimization technique for Malaysian Hydrological Information System (MHIS) data Kurmin, Norazrin Selamat, Harihodin Wahid, Mohd. Taib Mohd. Rahim, Mohd. Shafry G Geography (General) QA75 Electronic computers. Computer science Malaysian Hydrological Information System (MHIS) is one of the GIS applications that storing a large amount of data (such as rainfall, water level, evaporation and water quality). In such situation, it is important to ensure that the storage, retrieval and manipulation of these data are efficiently handled. However, the problem in MHIS is inefficient on retrieval data where it takes a long time to retrieve data. MHIS was developed based on cube system concept. The main objective introduced the cube system is to describe how the hydrology data will be store and retrieve in relational database. However, it is still lacking to handle a large amount of data. Thus, this paper proposed an Equijoin Optimization Technique to solve that problem. This technique was introduced based on modification of an equijoin method where an entity will be joined based on equijoin algorithm. In other words, the result relation is a new entity, T, contains tuples t made up of two tuples r and s, where r must be tuple in entity R and s must be tuple in entity S. Then, there are entity will be classified to other entity based on the appropriate attribute. Based on this technique, a SQL statement was created for data retrieval processing which is referring to the optimized entity. There are four main function in that process i) Select ii) Initialize iii) Operation and iv) Output. Also, in this research, testing and comparison analysis has been done between proposed technique, an Equijoin optimization and the previous technique MHIS Cube System. The result of the testing shows that the proposed technique can improve an execution time for query processing, then solve the issue has been discussed on this research. 2005-05-17 Conference or Workshop Item PeerReviewed application/pdf en http://eprints.utm.my/3355/1/Harihodin%2C_Haji_Taib_-_An_Equijoin-Optimization_Technique_For.pdf Kurmin, Norazrin and Selamat, Harihodin and Wahid, Mohd. Taib and Mohd. Rahim, Mohd. Shafry (2005) An equijoin-optimization technique for Malaysian Hydrological Information System (MHIS) data. In: Postgraduate Annual Research Seminar 2005, May 2005. |
| spellingShingle | G Geography (General) QA75 Electronic computers. Computer science Kurmin, Norazrin Selamat, Harihodin Wahid, Mohd. Taib Mohd. Rahim, Mohd. Shafry An equijoin-optimization technique for Malaysian Hydrological Information System (MHIS) data |
| title | An equijoin-optimization technique for Malaysian Hydrological Information System (MHIS) data |
| title_full | An equijoin-optimization technique for Malaysian Hydrological Information System (MHIS) data |
| title_fullStr | An equijoin-optimization technique for Malaysian Hydrological Information System (MHIS) data |
| title_full_unstemmed | An equijoin-optimization technique for Malaysian Hydrological Information System (MHIS) data |
| title_short | An equijoin-optimization technique for Malaysian Hydrological Information System (MHIS) data |
| title_sort | equijoin optimization technique for malaysian hydrological information system mhis data |
| topic | G Geography (General) QA75 Electronic computers. Computer science |
| url | http://eprints.utm.my/3355/1/Harihodin%2C_Haji_Taib_-_An_Equijoin-Optimization_Technique_For.pdf |
| work_keys_str_mv | AT kurminnorazrin anequijoinoptimizationtechniqueformalaysianhydrologicalinformationsystemmhisdata AT selamatharihodin anequijoinoptimizationtechniqueformalaysianhydrologicalinformationsystemmhisdata AT wahidmohdtaib anequijoinoptimizationtechniqueformalaysianhydrologicalinformationsystemmhisdata AT mohdrahimmohdshafry anequijoinoptimizationtechniqueformalaysianhydrologicalinformationsystemmhisdata AT kurminnorazrin equijoinoptimizationtechniqueformalaysianhydrologicalinformationsystemmhisdata AT selamatharihodin equijoinoptimizationtechniqueformalaysianhydrologicalinformationsystemmhisdata AT wahidmohdtaib equijoinoptimizationtechniqueformalaysianhydrologicalinformationsystemmhisdata AT mohdrahimmohdshafry equijoinoptimizationtechniqueformalaysianhydrologicalinformationsystemmhisdata |