Containment of aggregate queries

It is now common for databases to contain many gigabytes, or even many terabytes, of data. Scientific experiments in areas such as high energy physics produce data sets of enormous size, while in the business sector the emergence of decision-support systems and data warehouses has led organizations to build up gigantic collections of data. Aggregate queries allow one to retrieve concise information from such a database, since they can cover many data items while returning a small result. OLAP queries, used extensively in data warehousing, are based almost entirely on aggregation [4, 16]. Aggregate queries have also been studied in a variety of settings beyond relational databases, such as mobile computing [1], global information systems [21], stream data analysis [12], sensor networks [22] and constraint databases [2].

[1]  David S. Johnson,et al.  Optimizing Conjunctive Queries that Contain Untyped Variables , 1983, SIAM J. Comput..

[2]  Surajit Chaudhuri,et al.  Optimization of real conjunctive queries , 1993, PODS '93.

[3]  David E. Culler,et al.  Supporting aggregate queries over ad-hoc wireless sensor networks , 2002, Proceedings Fourth IEEE Workshop on Mobile Computing Systems and Applications.

[4]  Werner Nutt,et al.  Equivalences among aggregate queries with negation , 2005, TOCL.

[5]  Per-Åke Larson,et al.  Query Transformation for PSJ-Queries , 1987, VLDB.

[6]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[7]  Maurizio Rafanelli,et al.  On the equivalence and rewriting of aggregate queries , 2004, Acta Informatica.

[8]  Werner Nutt,et al.  Containment of Aggregate Queries , 2003, ICDT.

[9]  Alon Y. Halevy,et al.  Answering queries using views: A survey , 2001, The VLDB Journal.

[10]  Kenneth A. Ross,et al.  Foundations of Aggregation Constraints , 1994, PPCP.

[11]  Kenneth A. Ross,et al.  Materialized view maintenance and integrity constraint checking: trading space for time , 1996, SIGMOD '96.

[12]  Kyuseok Shim,et al.  Optimizing queries with materialized views , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[13]  Divesh Srivastava,et al.  Data model and query evaluation in global information systems , 1995, Journal of Intelligent Information Systems.

[14]  Ashok K. Chandra,et al.  Optimal implementation of conjunctive queries in relational data bases , 1977, STOC '77.

[15]  Divesh Srivastava,et al.  Answering Queries with Aggregation Using Views , 1996, VLDB.

[16]  Yehoshua Sagiv,et al.  Semantic query optimization in Datalog programs (extended abstract) , 1995, ILPS Workshop: Constraints and Databases.

[17]  Werner Nutt,et al.  Algorithms for Rewriting Aggregate Queries Using Views, Proc. Of East-European Conference on Advances in Databases and Information Systems , 2000 .

[18]  Ashish Gupta,et al.  Materialized views: techniques, implementations, and applications , 1999 .

[19]  Divesh Srivastava,et al.  Answering Queries Using Views. , 1999, PODS 1995.

[20]  Werner Nutt,et al.  Rewriting aggregate queries using views , 1999, PODS.

[21]  Michael Benedikt,et al.  Exact and approximate aggregation in constraint query languages , 1999, PODS '99.

[22]  Serge Abiteboul,et al.  Complexity of answering queries using materialized views , 1998, PODS.

[23]  Werner Nutt,et al.  Deciding equivalences among aggregate queries , 1998, PODS '98.

[24]  Lauri Hella,et al.  Logics with aggregate operators , 1999, Proceedings. 14th Symposium on Logic in Computer Science (Cat. No. PR00158).

[25]  Joann J. Ordille,et al.  Querying Heterogeneous Information Sources Using Source Descriptions , 1996, VLDB.

[26]  Ashish Gupta,et al.  Aggregate-Query Processing in Data Warehousing Environments , 1995, VLDB.

[27]  Sara Cohen Equivalence, Containment and Rewriting of Aggregate Queries , 2004 .

[28]  Werner Nutt,et al.  Algorithms for Rewriting Aggregate Queries Using Views , 2000, DMDW.

[29]  Michael R. Genesereth,et al.  Answering recursive queries using views , 1997, PODS '97.

[30]  Françoise Fabret,et al.  Eliminating costly redundant computations from SQL trigger executions , 1997, SIGMOD '97.

[31]  Jeffrey D. Ullman,et al.  Principles of Database and Knowledge-Base Systems, Volume II , 1988, Principles of computer science series.

[32]  Tomasz Imielinski,et al.  Sleepers and workaholics: caching strategies in mobile environments , 1994, SIGMOD '94.

[33]  Ron van der Meyden,et al.  The complexity of querying indefinite data about linearly ordered domains , 1992, J. Comput. Syst. Sci..

[34]  Alon Y. Halevy,et al.  MiniCon: A scalable algorithm for answering queries using views , 2000, The VLDB Journal.

[35]  Divesh Srivastava,et al.  Answering Queries Using Views. , 1999, PODS 1995.

[36]  Stéphane Grumbach,et al.  On the content of materialized aggregate views , 2000, PODS '00.

[37]  Raghu Ramakrishnan,et al.  Containment of conjunctive queries: beyond relations as sets , 1995, TODS.

[38]  Alon Y. Halevy,et al.  Semantic query optimization in Datalog programs (extended abstract) , 1995, PODS '95.

[39]  Rajeev Rastogi,et al.  Processing complex aggregate queries over data streams , 2002, SIGMOD '02.

[40]  Maurizio Rafanelli,et al.  Querying aggregate data , 1999, PODS '99.