Robust Estimation With Sampling and Approximate Pre-Aggregation

Summary: Introduces Approximate Pre-Aggregation (APA) for aggregate estimation on categorical or mixed data, where wavelets and histograms are ill-suited. Skew-aware sampling and pre-aggregation greatly reduce SUM/AVG error versus random and stratified sampling. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 9223
Venue: VLDB
Year: 2003
Pagerank: 5.8131331e-05
Overall Rank: 6,654 | 54.35%
DOI: 10.1016/B978-012722442-8/50083-5

Incoming Non-self Citations Over Time

Authors

1. Christopher Jermaine (University of Florida)

BibTeX Citation

@article{jermaine_vldb03,
        title = {{Robust Estimation With Sampling and Approximate Pre-Aggregation}},
        author = {Jermaine, Christopher},
        journal = {PVLDB},
        series = {{VLDB} '03},
        doi = {10.1016/B978-012722442-8/50083-5},
        url = {https://doi.org/10.1016/B978-012722442-8/50083-5},
        year = {2003}
}

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,271	Online Maintenance of Very Large Random Samples	2004	SIGMOD	8.8254873e-05
3,366	AQP++: Connecting Approximate Query Processing With Aggregate Precomputation for Interactive Analytics	2018	SIGMOD	7.4748604e-05
5,460	Derby/S: A DBMS for Sample-Based Query Answering	2006	SIGMOD	6.2106757e-05
6,206	Combining Aggregation and Sampling (Nearly) Optimally for Approximate Query Processing	2021	SIGMOD	5.9443409e-05

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 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
101	Selectivity Estimation Without the Attribute Value Independence Assumption	1997	VLDB	0.00034376651
136	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00030123303
149	New Sampling-Based Summary Statistics for Improving Approximate Query Answers	1998	SIGMOD	0.00029226907
213	Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets	1999	SIGMOD	0.00024723025
235	Fast Incremental Maintenance of Approximate Histograms	1997	VLDB	0.00023783792
267	Optimal Histograms with Quality Guarantees	1998	VLDB	0.00022798161
553	Congressional Samples for Approximate Answering of Group-By Queries	2000	SIGMOD	0.00016590619
850	Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes	2000	SIGMOD	0.00013619394
952	Recovering Information from Summary Data	1997	VLDB	0.00013010681
1,156	Wavelet Synopses with Error Guarantees	2002	SIGMOD	0.00011929041
1,166	ICICLES: Self-tuning Samples for Approximate Query Answering	2000	VLDB	0.00011850439
2,493	Applying the Golden Rule of Sampling for Query Estimation	2001	SIGMOD	8.5070756e-05
2,608	A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries	2001	SIGMOD	8.347674e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	435	Histogram-Based Approximation of Set-Valued Query Answers	1999	VLDB
2	3,241	Optimal and Approximate Computation of Summary Statistics for Range Aggregates	2001	PODS
3	3,215	Every Row Counts: Combining Sketches and Sampling for Accurate Group-By Result Estimates	2019	CIDR
4	55	Statistical Estimators for Relational Algebra Expressions	1988	PODS
5	2,413	A Sampling Algebra for Aggregate Estimation	2013	VLDB
6	909	Dynamic Sample Selection for Approximate Query Processing	2003	SIGMOD
7	850	Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes	2000	SIGMOD
8	6,206	Combining Aggregation and Sampling (Nearly) Optimally for Approximate Query Processing	2021	SIGMOD
9	1,962	Sample + Seek: Approximating Aggregates with Distribution Precision Guarantee	2016	SIGMOD
10	2,608	A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries	2001	SIGMOD