Sequence query processing

Many applications require the ability to manipulate sequences of data. We motivate the importance of sequence query processing, and present a framework for the optimization of sequence queries based on several novel techniques. These include query transformations, optimizations that utilize meta-data, and caching of intermediate results. We present a bottom-up algorithm that generates an efficient query evaluation plan based on cost estimates. This work also identifies a number of directions in which future research can be directed.

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

[2]  Won Kim,et al.  On optimizing an SQL-like nested query , 1982, TODS.

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

[4]  llsoo Ahn.  Temporal Databases , 1986 .

[5]  Shashi K. Gadia.  Toward a multihomogeheous model for a temporal database , 1986, 1986 IEEE Second International Conference on Data Engineering.

[6]  Catriel Beeri,et al.  On the power of magic , 1987, J. Log. Program..

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

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

[9]  Umeshwar Dayal,et al.  Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers , 1987, VLDB.

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

[11]  Harry K. T. Wong,et al.  Optimization of nested SQL queries revisited , 1987, SIGMOD '87.

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

[13]  David B. Lomet,et al.  Access methods for multiversion data , 1989, SIGMOD '89.

[14]  Shamkant B. Navathe,et al.  A Temporal Relational Model and a Query Language , 1989, Inf. Sci..

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

[16]  Ramez Elmasri,et al.  The Time Index: An Access Structure for Temporal Data , 1990, VLDB.

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

[18]  D. Scott Parker,et al.  Stream data analysis in Prolog , 1990 .

[19]  Michael D. Soo,et al.  Bibliography on temporal databases , 1991, SGMD.

[20]  H. Gunadhi,et al.  Query processing algorithms for temporal intersection joins , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[21]  Arie Segev,et al.  A glossary of temporal database concepts , 1992, SGMD.

[22]  Joel E. Richardson,et al.  Supporting Lists in a Data Model (A Timely Approach) , 1992, VLDB.

[23]  Narain H. Gehani,et al.  Composite Event Specification in Active Databases: Model & Implementation , 1992, VLDB.

[24]  Sumit Ganguly,et al.  Query optimization for parallel execution , 1992, SIGMOD '92.

[25]  Umeshwar Dayal,et al.  A uniform model for temporal object-oriented databases , 1992, [1992] Eighth International Conference on Data Engineering.

[26]  Sushil Jajodia,et al.  Temporal Databases: Theory, Design, and Implementation , 1993 .

[27]  Miron Livny,et al.  SEQ: A model for sequence databases , 1995, Proceedings of the Eleventh International Conference on Data Engineering.