Querying Aggregate Data
Summary: FO over reals with polynomial arithmetic and count/iterated sum/product aggregates: expressive, tractable data complexity, and quantifier elimination holds. Define “isomorphism modulo a product” to characterize aggregate-view equivalence; show NP‑completeness of that test and of complete count‑view rewriting, and give arithmetic-based rewritings to recover counts for automatic aggregation. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 10 of 10 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 48 | Data Integration: A Theoretical Perspective | 2002 | PODS | 0.00069720859 |
| 731 | Optimizing Queries Using Materialized Views: A Practical, Scalable Solution | 2001 | SIGMOD | 0.00017468889 |
| 1,059 | Answering Complex SQL Queries Using Automatic Summary Tables | 2000 | SIGMOD | 0.00014382575 |
| 1,155 | A Scalable Algorithm for Answering Queries Using Views | 2000 | VLDB | 0.00013616518 |
| 2,034 | Views and Queries: Determinacy and Rewriting | 2005 | PODS | 9.7156155e-05 |
| 4,082 | On the Content of Materialized Aggregate Views | 2000 | PODS | 6.4639136e-05 |
| 4,723 | Exact and Approximate Aggregation in Constraint Query Languages | 1999 | PODS | 5.9714196e-05 |
| 8,704 | Equivalence of Nested Queries with Mixed Semantics | 2009 | PODS | 4.4647149e-05 |
| 10,690 | Authenticated Aggregate Queries with Boolean Range Predicates on Blockchains | 2025 | VLDB | 4.1945683e-05 |
| 12,432 | Index-Based Multidimensional Array Queries: Safety and Equivalence | 2007 | PODS | 4.1945683e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 8 of 8 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 11 | Implementing Data Cubes Efficiently | 1996 | SIGMOD | 0.0011708144 |
| 82 | Answering Queries Using Views (Extended Abstract) | 1995 | PODS | 0.00054402763 |
| 218 | Aggregate-Query Processing in Data Warehousing Environments | 1995 | VLDB | 0.00033503922 |
| 335 | Optimization of Real Conjunctive Queries | 1993 | PODS | 0.00027036073 |
| 584 | Answering Queries with Aggregation Using Views | 1996 | VLDB | 0.0001971526 |
| 2,103 | Deciding Equivalences among Aggregate Queries | 1998 | PODS | 9.5385023e-05 |
| 2,295 | OLAP and Statistical Databases: Similarities and Differences | 1997 | PODS | 9.0782994e-05 |
| 5,709 | On the Containment and Equivalence of Database Queries with Linear Constraints* (Extended Abstract) | 1997 | PODS | 5.3602702e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,082 | On the Content of Materialized Aggregate Views | 2000 | PODS | 6.4639136e-05 |
| 1,952 | Deciding Containment for Queries with Complex Objects (Extended Abstract) | 1997 | PODS | 9.9677831e-05 |
| 4,723 | Exact and Approximate Aggregation in Constraint Query Languages | 1999 | PODS | 5.9714196e-05 |
| 5,897 | Answering Aggregate Queries in Data Exchange | 2008 | PODS | 5.2842198e-05 |
| 8,704 | Equivalence of Nested Queries with Mixed Semantics | 2009 | PODS | 4.4647149e-05 |
| 10,928 | Computing Range Consistent Answers to Aggregation Queries via Rewriting | 2024 | PODS | 4.1945683e-05 |
| 11,557 | Aggregate Queries on Sparse Databases | 2020 | PODS | 4.1945683e-05 |
| 13,814 | Equivalences Among Aggregate Queries with Negation | 2001 | PODS | - |
| 2,103 | Deciding Equivalences among Aggregate Queries | 1998 | PODS | 9.5385023e-05 |
| 971 | Rewriting Aggregate Queries Using Views | 1999 | PODS | 0.00014925576 |