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,767 | Offering a Precision-Performance Tradeoff for Aggregation Queries over Replicated Data | 2000 | VLDB | 9.6850758e-05 |
| 4,888 | Rectangle-Efficient Aggregation in Spatial Data Streams | 2012 | PODS | 6.3522397e-05 |
| 13,156 | Estimating the Output Cardinality of Partial Preaggregation with a Measure of Clusteredness | 2003 | VLDB | 4.9605343e-05 |
| 13,213 | Linear approximation of planar spatial databases using transitive-closure logic | 2000 | PODS | 4.9605343e-05 |
| 13,216 | Uniform Generation in Spatial Constraint Databases and Applications | 2000 | PODS | 4.9605343e-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.00076079812 |
| 153 | New Sampling-Based Summary Statistics for Improving Approximate Query Answers | 1998 | SIGMOD | 0.0002855087 |
| 1,962 | Relational Expressive Power of Constraint Query Languages | 1996 | PODS | 9.2843518e-05 |
| 2,301 | Querying Aggregate Data | 1999 | PODS | 8.6620636e-05 |
| 3,781 | Topological Queries in Spatial Databases | 1996 | PODS | 7.0032193e-05 |
| 4,262 | Variable Independence and Aggregation Closure | 1996 | PODS | 6.6817915e-05 |
| 4,311 | An Expressive Language for Linear Spatial Database Queries (extended abstract) | 1998 | PODS | 6.6568143e-05 |
| 4,336 | Safe Constraint Queries | 1998 | PODS | 6.6429071e-05 |
| 4,448 | Languages for Relational Databases over Interpreted Structures | 1997 | PODS | 6.5789235e-05 |
| 5,449 | Querying Spatial Databases via Topological Invariants | 1998 | PODS | 6.1105815e-05 |
| 6,086 | Measuring Infinite Relations (Extended Abstract) | 1995 | PODS | 5.8743333e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 13,212 | Fixed-Point Query Languages for Linear Constraint Databases | 2000 | PODS |
| 2 | 2,284 | Deciding Equivalences among Aggregate Queries | 1998 | PODS |
| 3 | 3,700 | OLAP over Imprecise Data with Domain Constraints | 2007 | VLDB |
| 4 | 11,552 | Computing Range Consistent Answers to Aggregation Queries via Rewriting | 2024 | PODS |
| 5 | 13,213 | Linear approximation of planar spatial databases using transitive-closure logic | 2000 | PODS |
| 6 | 4,232 | Approximating Predicates and Expressive Queries on Probabilistic Databases | 2008 | PODS |
| 7 | 8,725 | Aggregate Queries on Sparse Databases | 2020 | PODS |
| 8 | 2,301 | Querying Aggregate Data | 1999 | PODS |
| 9 | 8,754 | Towards Practical Constraint Databases (Extended Abstract) | 1996 | PODS |
| 10 | 4,262 | Variable Independence and Aggregation Closure | 1996 | PODS |