Querying multiple temporal granularity data

Managing and querying information with varying temporal granularities is an important problem in databases. Although there is a substantial body of work on temporal granularities for the relational data model (Snodgrass, 1995), a comprehensive framework is lacking for the object-oriented paradigm. To the best of our knowledge, a formal treatment of temporal queries with multiple granularities has not been considered in the literature. We make a step in this direction. We formally introduce the syntax and semantics of expressions involving data with multiple granularities, comparison between data with different granularities, and conversion of data from one granularity to another. We believe that this is an important step towards the development of an object-oriented query language that supports multiple granularities.

[1]  Richard T. Snodgrass,et al.  The TSQL2 Temporal Query Language , 1995 .

[2]  Shashi K. Gadia,et al.  A homogeneous relational model and query languages for temporal databases , 1988, TODS.

[3]  Umeshwar Dayal,et al.  A Uniform Model for Temporal and Versioned Object-oriented Databases , 1993, Temporal Databases.

[4]  Ramez Elmasri,et al.  A temporal object query language , 1998, Proceedings. Fifth International Workshop on Temporal Representation and Reasoning (Cat. No.98EX157).

[5]  David Jordan,et al.  The Object Database Standard: ODMG 2.0 , 1997 .

[6]  Arie Segev,et al.  TOODM - A Temporal Object-Oriented Data Model with Temporal Constraints , 1991, ER.

[7]  Francesco Pinciroli,et al.  Applying object-oriented technologies in modeling and querying temporally oriented clinical databases dealing with temporal granularity and indeterminacy , 1997, IEEE Transactions on Information Technology in Biomedicine.

[8]  Elisa Bertino,et al.  A temporal object-oriented data model with multiple granularities , 1999, Proceedings. Sixth International Workshop on Temporal Representation and Reasoning. TIME-99.

[9]  Duane Szafron,et al.  TIGUKAT: A uniform behavioral objectbase management system , 1995, The VLDB Journal.

[10]  Curtis E. Dyreson,et al.  A Glossary of Time Granularity Concepts , 1997, Temporal Databases, Dagstuhl.