A Consensus Test Suite of Temporal Database
Queries1
Christian S. Jensen (editor) James Clifford
Shashi K. Gadia Fabio Grandi
Patrick P. Kalua Nick Kline Nikos Lorentzos
Yannis Mitsopoulos
Angelo Montanari Sunil S. Nair Elisa Peressi
Barbara Pernici
Edward L. Robertson John F. Roddick Nandlal L. Sarda
Maria Rita Scalas
Arie Segev Richard T. Snodgrass Abdullah Tansel
Paolo Tiberio
Alexander Tuzhilin Gene T. J. Wuu
Abstract
This document presents the temporal database community with an
sizable consensus test suite of temporal database queries. The
test suite is intended to be helpful when evaluating the
user-friendliness of temporal relational query languages.
The test suite consists of a database schema, an instance for the
schema, and a set of approximately 150 queries on this database.
The queries are classified according to a taxonomy, which is also
included in the document.
- Introduction
- Scope
- A Database Schema for the Test Suite
- The Test Suite Data
- Classification of Queries
- The Test-suite Queries
- Overview
- Explicit-attribute Output
- Class O1.S1 (Duration, Interval, Computed)
- Class O1.S2 (Duration, Interval, Other)
- Class O1.S3 (Duration, Element, Computed)
- Class O1.S4 (Duration, Element, Other)
- Class O1.S5 (Other, Event, Computed)
- Class O1.S6 (Other, Event, Other)
- Class O1.S7 (Other, Interval, Computed)
- Class O1.S8 (Other, Interval, Other)
- Class O1.S9 (Other, Element, Computed)
- Class O1.S10 (Other, Element, Other)
- Valid-time Output
- Class O2.S1 (Duration, Interval, Computed)
- Class O2.S2 (Duration, Element, Other)
- Class O2.S3 (Duration, Element, Computed)
- Class O2.S4 (Duration, Element, Other)
- Class O2.S5 (Other, Event, Computed)
- Class O2.S6 (Other, Event, Other)
- Class O2.S7 (Other, Interval, Computed)
- Class O2.S8 (Other, Interval, Other)
- Class O2.S9 (Other, Element, Computed)
- Class O2.S10 (Other, Element, Other)
- Explicit-attribute and Valid-time Output
- Class O3.S1 (Duration, Interval, Computed)
- Class O3.S2 (Duration, Interval, Other)
- Class O3.S3 (Duration, Element, Computed)
- Class O3.S4 (Duration, Element, Other)
- Class O3.S5 (Other, Event, Computed)
- Class O3.S6 (Other, Event, Other)
- Class O3.S7 (Other, Interval, Computed)
- Class O3.S8 (Other, Interval, Other)
- Class O3.S9 (Other, Element, Computed)
- Class O3.S10 (Other, Element, Other)
- Contributors and Acknowledgements