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

Full description

Saved in:
Bibliographic Details
Main Authors: Mohd Rahim, Mohd Shafry, Kurmin, A., Wahid, T., Daman, Daut
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!
Institution: Universiti Teknologi Malaysia
Description
Summary: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.