Temporal aggregates and temporal universal quantification in standard SQL

Although it has been acknowledged for many years that querying and updating time-varying information using standard (i.e., non-temporal) SQL is a challenging task, the proposed temporal extensions of SQL have not reach acceptance in the standardization committees. Therefore, nowadays database practitioners must still use standard SQL for manipulating time-varying information. This paper shows how to realize temporal aggregates and temporal universal quantifiers using standard SQL.

• Type: Conference
• Year: 2006
• Where: SIGMOD
• Authors: Esteban Zimányi
• Keywords: Database, SIGMOD 2006, Standard Sql, Temporal Aggregates, Temporal Universal Quantifiers