UDC 004.652.4, DOI:10.2298/CSIS101020035S

Advanced Indexing Technique for Temporal Data

Bela Stantic1, Rodney Topor1, Justin Terry1 and Abdul Sattar1

  1. 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: 1820-0214 (Print) 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

DownloadAvailable 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