Query processing algorithms for temporal intersection joins

Intersection join processing in temporal relational databases is investigated. An analysis is presented of the characteristics and processing requirements of three types of intersection join operators: the time-join temporal equijoin on the surrogate, and temporal equijoin on the temporal attribute. Based on the physical organization of the database and on the semantics of the operators, several algorithms were developed to process these joins efficiently. The primary cost variables were identified for each algorithm and their performance is compared to that of a conventional nested-loop join procedure. It is shown that the algorithms developed can reduce processing costs significantly.<<ETX>>

[1]  Curtis P. Kolovson.  Indexing techniques for historical databases , 1989, [1989] Proceedings. Fifth International Conference on Data Engineering.

[2]  Richard R. Muntz,et al.  Query processing for temporal databases , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[3]  Albert Croker,et al.  The historical relational data model (HRDM) and algebra based on lifespans , 1986, 1987 IEEE Third International Conference on Data Engineering.

[4]  Richard T. Snodgrass,et al.  Performance Analysis of Temporal Queries , 1989, Inf. Sci..

[5]  Robert Kooi,et al.  Query Optimization in INGRES. , 1982 .

[6]  Arie Shoshani,et al.  Logical modeling of temporal data , 1987, SIGMOD '87.

[7]  Patricia G. Selinger,et al.  Access path selection in a relational database management system , 1979, SIGMOD '79.

[8]  Arie Shoshani,et al.  The Representation of a Temporal Data Model in the Relational Environment , 1988, SSDBM.

[9]  Richard T. Snodgrass,et al.  The temporal query language TQuel , 1987, TODS.

[10]  Arie Segev,et al.  Event-Join Optimization in Temporal Relational Databases , 1989, VLDB.

[11]  Arie Segev,et al.  Physical organization of temporal data , 1987, 1987 IEEE Third International Conference on Data Engineering.

[12]  Carlo Zaniolo,et al.  Optimization of Nonrecursive Queries , 1986, VLDB.

[13]  Richard T. Snodgrass,et al.  A taxonomy of time databases , 1985, SIGMOD Conference.

[14]  James F. Allen.  Maintaining knowledge about temporal intervals , 1983, CACM.

[15]  Arie Segev,et al.  A Framework for Query Optimization in Temporal Databases , 1990, SSDBM.