ICICLES: Self-tuning Samples for Approximate Query Answering

Summary: Introduces workload-adaptive “icicle” samples for approximate aggregate queries over foreign-key joins, allocating tuple inclusion probability by query importance rather than uniformly. Self-tuning samples exploit OLAP locality to improve accuracy under fixed storage, with analytical guarantees and experiments. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 8836
Venue: VLDB
Year: 2000
Pagerank: 0.00011850439
Overall Rank: 1,166 | 92.01%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Venkatesh Ganti (University of Wisconsin)
2. Mong Li Lee (University of Wisconsin)
3. Raghu Ramakrishnan (University of Wisconsin)

BibTeX Citation

@article{ganti_vldb00,
        title = {{ICICLES: Self-tuning Samples for Approximate Query Answering}},
        author = {Ganti, Venkatesh and Lee, Mong Li and Ramakrishnan, Raghu},
        journal = {PVLDB},
        series = {{VLDB} '00},
        year = {2000}
}

Incoming Citations (Sorted by Pagerank)

Showing 23 of 23 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
255	Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports	2001	VLDB	0.00023174541
363	Approximate Query Processing: Taming the TeraBytes! A Tutorial	2001	VLDB	0.0002005475
772	VerdictDB: Universalizing Approximate Query Processing	2018	SIGMOD	0.00014147905
909	Dynamic Sample Selection for Approximate Query Processing	2003	SIGMOD	0.00013291205
1,108	Approximate Query Processing: No Silver Bullet	2017	SIGMOD	0.00012145154
1,266	Compressing SQL Workloads	2002	SIGMOD	0.00011412078
1,582	SciBORQ: Scientific data management with Bounds On Runtime and Quality	2011	CIDR	0.00010295367
1,962	Sample + Seek: Approximating Aggregates with Distribution Precision Guarantee	2016	SIGMOD	9.3978414e-05
1,995	Database Learning: Toward a Database that Becomes Smarter Every Time	2017	SIGMOD	9.3403665e-05
2,271	Online Maintenance of Very Large Random Samples	2004	SIGMOD	8.8254873e-05
2,608	A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries	2001	SIGMOD	8.347674e-05
3,309	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD	7.5368417e-05
3,366	AQP++: Connecting Approximate Query Processing With Aggregate Precomputation for Interactive Analytics	2018	SIGMOD	7.4748604e-05
4,198	Primitives for Workload Summarization and Implications for SQL	2003	VLDB	6.8397659e-05
4,696	Error-bounded Sampling for Analytics on Big Sparse Data	2014	VLDB	6.557612e-05
4,926	Adaptive Sampling for Rapidly Matching Histograms	2018	VLDB	6.4428362e-05
5,743	Joins on Samples: A Theoretical Guide for Practitioners	2020	VLDB	6.1025457e-05
5,820	A Database System with Amnesia	2017	CIDR	6.0761631e-05
6,206	Combining Aggregation and Sampling (Nearly) Optimally for Approximate Query Processing	2021	SIGMOD	5.9443409e-05
6,654	Robust Estimation With Sampling and Approximate Pre-Aggregation	2003	VLDB	5.8131331e-05
8,204	PilotDB: Database-Agnostic Online Approximate Query Processing with A Priori Error Guarantees	2025	SIGMOD	5.4667903e-05
8,689	Adaptive Index Structures	2002	VLDB	5.3843737e-05
11,736	FlashP: An Analytical Pipeline for Real-time Forecasting of Time-Series Relational Data	2021	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 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
54	On Random Sampling over Joins	1999	SIGMOD	0.00040810225
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
327	The Aqua Approximate Query Answering System	1999	SIGMOD	0.00021091539
1,732	Caching Multidimensional Queries Using Chunks	1998	SIGMOD	9.9065981e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	149	New Sampling-Based Summary Statistics for Improving Approximate Query Answers	1998	SIGMOD
2	909	Dynamic Sample Selection for Approximate Query Processing	2003	SIGMOD
3	819	Quickr: Lazily Approximating Complex AdHoc Queries in BigData Clusters	2016	SIGMOD
4	10,634	Efficient Approximate Query Processing with Block Sampling	2025	CIDR
5	136	Join Synopses for Approximate Query Answering	1999	SIGMOD
6	6,206	Combining Aggregation and Sampling (Nearly) Optimally for Approximate Query Processing	2021	SIGMOD
7	8,108	Experiences with Approximating Queries in Microsoft’s Production Big-Data Clusters	2019	VLDB
8	2,608	A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries	2001	SIGMOD
9	1,962	Sample + Seek: Approximating Aggregates with Distribution Precision Guarantee	2016	SIGMOD
10	1,401	Knowing When You’re Wrong: Building Fast and Reliable Approximate Query Processing Systems	2014	SIGMOD