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...
Saved in:
Main Authors: | , , , |
---|---|
Format: | Article |
Published: |
Zarqa Private University
2007
|
Subjects: | |
Online Access: | http://eprints.utm.my/id/eprint/8424/ http://ccis2k.org/iajit/PDF/vol.4,no.3/12-Shafry.pdf |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my.utm.8424 |
---|---|
record_format |
eprints |
spelling |
my.utm.84242017-10-16T07:58:35Z http://eprints.utm.my/id/eprint/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 |
institution |
Universiti Teknologi Malaysia |
building |
UTM Library |
collection |
Institutional Repository |
continent |
Asia |
country |
Malaysia |
content_provider |
Universiti Teknologi Malaysia |
content_source |
UTM Institutional Repository |
url_provider |
http://eprints.utm.my/ |
topic |
Q Science (General) QA75 Electronic computers. Computer science |
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 |
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.
|
format |
Article |
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 |
title |
Equi-join table optimization technique for temporal data
|
title_short |
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_sort |
equi-join table optimization technique for temporal data |
publisher |
Zarqa Private University |
publishDate |
2007 |
url |
http://eprints.utm.my/id/eprint/8424/ http://ccis2k.org/iajit/PDF/vol.4,no.3/12-Shafry.pdf |
_version_ |
1643644987536048128 |
score |
13.209306 |