Exact and Approximate Aggregation in Constraint Query Languages
Summary: Proves constraint-query languages cannot define exact or approximate aggregation; VC-dimension based approximations are insufficient. Proposes FO+POLY+SUM: SUM over range-restricted queries, computes volumes for linear constraints and (with an ML tweak) probabilistic polynomial-volume approximations. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Michael Benedikt (AT&T)
- 2. Leonid Libkin (AT&T)
BibTeX Citation
@inproceedings{benedikt_pods99,
address = {New York, NY, USA},
series = {{PODS} '99},
title = {{Exact and Approximate Aggregation in Constraint Query Languages}},
url = {https://dl.acm.org/doi/10.1145/303976.303987},
doi = {10.1145/303976.303987},
booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
publisher = {Association for Computing Machinery},
author = {Benedikt, Michael and Libkin, Leonid},
year = {1999}
}Incoming Citations (Sorted by Pagerank)
Showing 5 of 5 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,716 | Offering a Precision-Performance Tradeoff for Aggregation Queries over Replicated Data | 2000 | VLDB | 9.9330086e-05 |
| 4,755 | Rectangle-Efficient Aggregation in Spatial Data Streams | 2012 | PODS | 6.5226838e-05 |
| 12,819 | Estimating the Output Cardinality of Partial Preaggregation with a Measure of Clusteredness | 2003 | VLDB | 5.093636e-05 |
| 12,876 | Linear approximation of planar spatial databases using transitive-closure logic | 2000 | PODS | 5.093636e-05 |
| 12,879 | Uniform Generation in Spatial Constraint Databases and Applications | 2000 | PODS | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 11 of 11 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 9 | Online Aggregation | 1997 | SIGMOD | 0.00077458002 |
| 149 | New Sampling-Based Summary Statistics for Improving Approximate Query Answers | 1998 | SIGMOD | 0.00029226907 |
| 1,890 | Relational Expressive Power of Constraint Query Languages | 1996 | PODS | 9.5330753e-05 |
| 2,305 | Querying Aggregate Data | 1999 | PODS | 8.7766218e-05 |
| 3,695 | Topological Queries in Spatial Databases | 1996 | PODS | 7.1911058e-05 |
| 4,165 | Variable Independence and Aggregation Closure | 1996 | PODS | 6.858392e-05 |
| 4,203 | An Expressive Language for Linear Spatial Database Queries (extended abstract) | 1998 | PODS | 6.8354052e-05 |
| 4,226 | Safe Constraint Queries | 1998 | PODS | 6.8211482e-05 |
| 4,336 | Languages for Relational Databases over Interpreted Structures | 1997 | PODS | 6.7554436e-05 |
| 5,303 | Querying Spatial Databases via Topological Invariants | 1998 | PODS | 6.2745166e-05 |
| 5,948 | Measuring Infinite Relations (Extended Abstract) | 1995 | PODS | 6.0317886e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 12,875 | Fixed-Point Query Languages for Linear Constraint Databases | 2000 | PODS |
| 2 | 2,238 | Deciding Equivalences among Aggregate Queries | 1998 | PODS |
| 3 | 11,146 | Computing Range Consistent Answers to Aggregation Queries via Rewriting | 2024 | PODS |
| 4 | 3,619 | OLAP over Imprecise Data with Domain Constraints | 2007 | VLDB |
| 5 | 4,136 | Approximating Predicates and Expressive Queries on Probabilistic Databases | 2008 | PODS |
| 6 | 12,876 | Linear approximation of planar spatial databases using transitive-closure logic | 2000 | PODS |
| 7 | 8,528 | Aggregate Queries on Sparse Databases | 2020 | PODS |
| 8 | 2,305 | Querying Aggregate Data | 1999 | PODS |
| 9 | 8,559 | Towards Practical Constraint Databases (Extended Abstract) | 1996 | PODS |
| 10 | 4,165 | Variable Independence and Aggregation Closure | 1996 | PODS |