Object-Relational Indexing for General Interval Relationships

  • Authors:
  • Hans-Peter Kriegel;Marco Pötke;Thomas Seidl

  • Affiliations:
  • -;-;-

  • Venue:
  • SSTD '01 Proceedings of the 7th International Symposium on Advances in Spatial and Temporal Databases
  • Year:
  • 2001

Quantified Score

Hi-index 0.00

Visualization

Abstract

Intervals represent a fundamental data type for temporal, scientific, and spatia l databases where time stamp s and point data are extended to time spans and range data, respectively. For OLTP a nd OLAP applications on large amount s of data, no t only intersection queries have to be processed efficiently but also general interval relationships including before, meets, overlaps, starts, finishes, contains, equals, during, startedBy, finishedBy, overlappedBy, metBy, and after. Our new algorithms use the Relational Interval Tree, a purely SQL-base d and object-relationally wrapped index structure. The technique therefore pre serves the industrial strength of the underlying RDBMS including stability, transactions, and performance. The efficiency of our approach is demonstrated by an experimental evaluation on a real weblog data set containing one million sessions.