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 |
|---|---|---|---|---|
| 47 | Data Integration: A Theoretical Perspective | 2002 | PODS | 0.00069691761 |
| 728 | Optimizing Queries Using Materialized Views: A Practical, Scalable Solution | 2001 | SIGMOD | 0.00017459654 |
| 1,059 | Answering Complex SQL Queries Using Automatic Summary Tables | 2000 | SIGMOD | 0.00014370009 |
| 1,155 | A Scalable Algorithm for Answering Queries Using Views | 2000 | VLDB | 0.00013606507 |
| 2,039 | Views and Queries: Determinacy and Rewriting | 2005 | PODS | 9.7059912e-05 |
| 4,084 | On the Content of Materialized Aggregate Views | 2000 | PODS | 6.4581296e-05 |
| 4,719 | Exact and Approximate Aggregation in Constraint Query Languages | 1999 | PODS | 5.9659829e-05 |
| 8,699 | Equivalence of Nested Queries with Mixed Semantics | 2009 | PODS | 4.4604187e-05 |
| 10,698 | Authenticated Aggregate Queries with Boolean Range Predicates on Blockchains | 2025 | VLDB | 4.1905499e-05 |
| 12,441 | Index-Based Multidimensional Array Queries: Safety and Equivalence | 2007 | PODS | 4.1905499e-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.0011695087 |
| 82 | Answering Queries Using Views (Extended Abstract) | 1995 | PODS | 0.00054430106 |
| 218 | Aggregate-Query Processing in Data Warehousing Environments | 1995 | VLDB | 0.00033489004 |
| 335 | Optimization of Real Conjunctive Queries | 1993 | PODS | 0.00027012705 |
| 583 | Answering Queries with Aggregation Using Views | 1996 | VLDB | 0.00019705383 |
| 2,105 | Deciding Equivalences among Aggregate Queries | 1998 | PODS | 9.5309231e-05 |
| 2,301 | OLAP and Statistical Databases: Similarities and Differences | 1997 | PODS | 9.0699585e-05 |
| 5,719 | On the Containment and Equivalence of Database Queries with Linear Constraints* (Extended Abstract) | 1997 | PODS | 5.3551435e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,084 | On the Content of Materialized Aggregate Views | 2000 | PODS | 6.4581296e-05 |
| 1,959 | Deciding Containment for Queries with Complex Objects (Extended Abstract) | 1997 | PODS | 9.958725e-05 |
| 4,719 | Exact and Approximate Aggregation in Constraint Query Languages | 1999 | PODS | 5.9659829e-05 |
| 5,901 | Answering Aggregate Queries in Data Exchange | 2008 | PODS | 5.2791434e-05 |
| 8,699 | Equivalence of Nested Queries with Mixed Semantics | 2009 | PODS | 4.4604187e-05 |
| 10,931 | Computing Range Consistent Answers to Aggregation Queries via Rewriting | 2024 | PODS | 4.1905499e-05 |
| 11,561 | Aggregate Queries on Sparse Databases | 2020 | PODS | 4.1905499e-05 |
| 13,828 | Equivalences Among Aggregate Queries with Negation | 2001 | PODS | - |
| 971 | Rewriting Aggregate Queries Using Views | 1999 | PODS | 0.00014915911 |
| 2,105 | Deciding Equivalences among Aggregate Queries | 1998 | PODS | 9.5309231e-05 |