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.

Authors

• Isabella Merlo
• Elisa Bertino
• Elena Ferrari 0001
• Shashi K. Gadia
• Giovanna Guerrini

Keywords

• Object oriented databases
• Database languages
• Object oriented modeling
• Data models
• Relational databases
• Computer science
• Information management
• Proposals
• Temporal Data
• Temporal Granularity
• Multiple Granularities
• Semantic
• Data Conversion
• Query Language
• Substantial Body Of Work
• Set Of Values
• Time Domain
• Set Of Types
• Part Of Function
• Temporal Information
• Types Of Values
• Expression Of Set
• Time Instants
• Monthly Time
• Query Data
• Aggregation Function
• Disjoint Sets
• Semantic Map
• Relaxation Function
• Query Results
• Temporal Elements
• Legal Value
• Boolean Expression