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: h70bbbf3ace0c26ad
Venue: VLDB
Year: 2000
Pagerank: 0.00011581468
Overall Rank: 1,186 | 92.06%
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
268	Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports	2001	VLDB	0.00022654182
374	Approximate Query Processing: Taming the TeraBytes! A Tutorial	2001	VLDB	0.00019698889
770	VerdictDB: Universalizing Approximate Query Processing	2018	SIGMOD	0.00014086699
935	Dynamic Sample Selection for Approximate Query Processing	2003	SIGMOD	0.00012968914
1,065	Approximate Query Processing: No Silver Bullet	2017	SIGMOD	0.00012181098
1,246	Compressing SQL Workloads	2002	SIGMOD	0.00011355447
1,614	SciBORQ: Scientific data management with Bounds On Runtime and Quality	2011	CIDR	0.00010054823
2,014	Sample + Seek: Approximating Aggregates with Distribution Precision Guarantee	2016	SIGMOD	9.1775869e-05
2,040	Database Learning: Toward a Database that Becomes Smarter Every Time	2017	SIGMOD	9.1319608e-05
2,335	Online Maintenance of Very Large Random Samples	2004	SIGMOD	8.6050778e-05
2,661	A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries	2001	SIGMOD	8.1414177e-05
3,371	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD	7.3493132e-05
3,435	AQP++: Connecting Approximate Query Processing With Aggregate Precomputation for Interactive Analytics	2018	SIGMOD	7.2845431e-05
4,268	Primitives for Workload Summarization and Implications for SQL	2003	VLDB	6.6784565e-05
4,815	Error-bounded Sampling for Analytics on Big Sparse Data	2014	VLDB	6.3890155e-05
5,049	Adaptive Sampling for Rapidly Matching Histograms	2018	VLDB	6.287033e-05
5,841	Joins on Samples: A Theoretical Guide for Practitioners	2020	VLDB	5.9569427e-05
5,941	A Database System with Amnesia	2017	CIDR	5.9218052e-05
6,198	Combining Aggregation and Sampling (Nearly) Optimally for Approximate Query Processing	2021	SIGMOD	5.8362492e-05
6,800	Robust Estimation With Sampling and Approximate Pre-Aggregation	2003	VLDB	5.662589e-05
7,745	PilotDB: Database-Agnostic Online Approximate Query Processing with A Priori Error Guarantees	2025	SIGMOD	5.4457135e-05
8,883	Adaptive Index Structures	2002	VLDB	5.2436823e-05
12,089	FlashP: An Analytical Pipeline for Real-time Forecasting of Time-Series Relational Data	2021	VLDB	4.9605343e-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.00076079812
57	On Random Sampling over Joins	1999	SIGMOD	0.0003999751
138	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00029532435
153	New Sampling-Based Summary Statistics for Improving Approximate Query Answers	1998	SIGMOD	0.0002855087
222	Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets	1999	SIGMOD	0.00024136952
337	The Aqua Approximate Query Answering System	1999	SIGMOD	0.00020593498
1,779	Caching Multidimensional Queries Using Chunks	1998	SIGMOD	9.6641413e-05

Semantically Similar Papers

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