Equi-join table optimization technique for temporal data
Temporal data management is significant to applications such as environmental management systems. It is to ensure that the process of data storing, retrieving and manipulation can be conducted in an efficient manner. The main focus of this research is on the retrieval of temporal data. Evidently, i...
| Main Authors: | , , , |
|---|---|
| Format: | Article |
| Published: |
Zarqa Private University
2007
|
| Subjects: |
| _version_ | 1796854382036254720 |
|---|---|
| author | Mohd Rahim, Mohd Shafry Kurmin, A. Wahid, T. Daman, Daut |
| author_facet | Mohd Rahim, Mohd Shafry Kurmin, A. Wahid, T. Daman, Daut |
| author_sort | Mohd Rahim, Mohd Shafry |
| collection | ePrints |
| description | Temporal data management is significant to applications such as environmental management systems. It is to ensure that the process of data storing, retrieving and manipulation can be conducted in an efficient manner. The main focus of this research is on the retrieval of temporal data. Evidently, in the area of temporal data retrieval, the issue that is given most attention by researchers is how to speed up data retrieval time. In our research, we attempt to tackle this issue in an information system which stores hydrological data using a database that utilizes the cube method. As an end result, we managed to establish a technique called the equi-join table optimization technique that was implemented to an existing database system. This technique will also analyze a query statement with several possible query executions to determine the most possible optimum implementation. The outcome indicated that there is indeed an improvement concerning the data retrieval response time.
|
| first_indexed | 2024-03-05T18:13:28Z |
| format | Article |
| id | utm.eprints-8424 |
| institution | Universiti Teknologi Malaysia - ePrints |
| last_indexed | 2024-03-05T18:13:28Z |
| publishDate | 2007 |
| publisher | Zarqa Private University |
| record_format | dspace |
| spelling | utm.eprints-84242017-10-16T07:58:35Z http://eprints.utm.my/8424/ Equi-join table optimization technique for temporal data Mohd Rahim, Mohd Shafry Kurmin, A. Wahid, T. Daman, Daut Q Science (General) QA75 Electronic computers. Computer science Temporal data management is significant to applications such as environmental management systems. It is to ensure that the process of data storing, retrieving and manipulation can be conducted in an efficient manner. The main focus of this research is on the retrieval of temporal data. Evidently, in the area of temporal data retrieval, the issue that is given most attention by researchers is how to speed up data retrieval time. In our research, we attempt to tackle this issue in an information system which stores hydrological data using a database that utilizes the cube method. As an end result, we managed to establish a technique called the equi-join table optimization technique that was implemented to an existing database system. This technique will also analyze a query statement with several possible query executions to determine the most possible optimum implementation. The outcome indicated that there is indeed an improvement concerning the data retrieval response time. Zarqa Private University 2007-07 Article PeerReviewed Mohd Rahim, Mohd Shafry and Kurmin, A. and Wahid, T. and Daman, Daut (2007) Equi-join table optimization technique for temporal data. International Arab Journal of Information Technology, 4 (3). pp. 272-280. ISSN 1683-3198 http://ccis2k.org/iajit/PDF/vol.4,no.3/12-Shafry.pdf |
| spellingShingle | Q Science (General) QA75 Electronic computers. Computer science Mohd Rahim, Mohd Shafry Kurmin, A. Wahid, T. Daman, Daut Equi-join table optimization technique for temporal data |
| title | Equi-join table optimization technique for temporal data
|
| title_full | Equi-join table optimization technique for temporal data
|
| title_fullStr | Equi-join table optimization technique for temporal data
|
| title_full_unstemmed | Equi-join table optimization technique for temporal data
|
| title_short | Equi-join table optimization technique for temporal data
|
| title_sort | equi join table optimization technique for temporal data |
| topic | Q Science (General) QA75 Electronic computers. Computer science |
| work_keys_str_mv | AT mohdrahimmohdshafry equijointableoptimizationtechniquefortemporaldata AT kurmina equijointableoptimizationtechniquefortemporaldata AT wahidt equijointableoptimizationtechniquefortemporaldata AT damandaut equijointableoptimizationtechniquefortemporaldata |