The Community for Technology Leaders
RSS Icon
Subscribe
Issue No.05 - October (1993 vol.5)
pp: 826-842
ABSTRACT
<p>This paper defines new constructs to support aggregation in the temporal query language TQuel and presents their formal semantics in the tuple relational calculus. A formal semantics for Quel aggregates is defined in the process. Multiple aggregates; aggregates appearing in the where, when, and valid clauses; nested aggregation; and instantaneous, cumulative, moving window, and unique variants are supported. These aggregates provide a rich set of statistical functions that range over time, while requiring minimal additions to TQuel and its semantics. We show how the aggregates may be supported in an historical algebra, both in a batch and in an incremental fashion, demonstrating that implementation is straightforward and efficient.</p>
INDEX TERMS
temporal query language; TQuel; temporal database; formal semantics; tuple relational calculus; nested aggregation; unique variants; statistical functions; historical algebra; temporal partitioning; valid time; query languages; relational databases; temporal databases
CITATION
R. Snodgrass, S. Gomez, E. McKenzie, "Aggregates in the Temporal Query Language TQuel", IEEE Transactions on Knowledge & Data Engineering, vol.5, no. 5, pp. 826-842, October 1993, doi:10.1109/69.243512
24 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool