Aggregates in the temporal query language TQuel
- 1 January 1993
- journal article
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Transactions on Knowledge and Data Engineering
- Vol. 5 (5) , 826-842
- https://doi.org/10.1109/69.243512
Abstract
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.Keywords
This publication has 30 references indexed in Scilit:
- Formal semantics of SQL queriesACM Transactions on Database Systems, 1991
- Translation with optimization from relational calculus to relational algebra having aggregate functionsACM Transactions on Database Systems, 1990
- Schema evolution and the relational algebraInformation Systems, 1990
- A temporal relational model and a query languageInformation Sciences, 1989
- Processing aggregate relational queries with hard time constraintsPublished by Association for Computing Machinery (ACM) ,1989
- An extension of the relational model to support generic intervalsPublished by Springer Nature ,1988
- A performance analysis of view materialization strategiesACM SIGMOD Record, 1987
- Performance evaluation of a temporal database management systemPublished by Association for Computing Machinery (ACM) ,1986
- Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate FunctionsJournal of the ACM, 1982
- LEGOL 2.0: A relational specification language for complex rulesInformation Systems, 1979