UDC 004.652.4, DOI:10.2298/CSIS101020035S
Advanced Indexing Technique for Temporal Data
- Institute for Integrated and Intelligent Systems, Griffith University
Queensland, Australia
{b.stantic, r.topor, j.terry, a.sattar}@griffith.edu.au
Abstract
The need for efficient access and management of time dependent data in modern database applications is well recognised and researched. Existing access methods are mostly derived from the family of spatial R-tree indexing techniques. These techniques are particularly not suitable to handle data involving open ended intervals, which are common in temporal databases. This is due to overlapping between nodes and huge dead space found in the database. In this study, we describe a detailed investigation of a new approach called "Triangular Decomposition Tree" (TD-Tree). The underlying idea for the TD-Tree is to manage temporal intervals by virtual index structures relying on geometric interpretations of intervals, and a space partition method that results in an unbalanced binary tree. We demonstrate that the unbalanced binary tree can be efficiently manipulated using a virtual index. We also show that the single query algorithm can be applied uniformly to different query types without the need of dedicated query transformations. In addition to the advantages related to the usage of a single query algorithm for different query types and better space complexity, the empirical performance of the TDtree has been found to be superior to its best known competitors.
Key words
Temporal Databases, Access Methods, Performance Evaluation.
Digital Object Identifier (DOI)
https://doi.org/10.2298/CSIS101020035S
Publication information
Volume 7, Issue 4 (December 2010)
Year of Publication: 2010
ISSN: 2406-1018 (Online)
Publisher: ComSIS Consortium
Full text
Available in PDF
Portable Document Format
How to cite
Stantic, B., Topor, R., Terry, J., Sattar, A.: Advanced Indexing Technique for Temporal Data. Computer Science and Information Systems, Vol. 7, No. 4, 679-703. (2010), https://doi.org/10.2298/CSIS101020035S