StatAdvisor: Recommending Statistical Views

Summary: StatAdvisor recommends statistical/sample views for SQL workloads to reduce cardinality-estimation errors on intermediate results. It uniquely combines view-matching and benefit models with plan-based candidate enumeration, validated in an IBM DB2 prototype. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: hd47e408b2c923d0a
Venue: VLDB
Year: 2009
Pagerank: 6.0498181e-05
Overall Rank: 5,611 | 62.39%
DOI: 10.14778/1687553.1687556

Incoming Non-self Citations Over Time

Authors

1. Amr El-Helw (University of Waterloo)
2. Ihab F. Ilyas (University of Waterloo)
3. Calisto Zuzarte (IBM Toronto Lab)

BibTeX Citation

@article{elhelw_vldb09,
        title = {{StatAdvisor: Recommending Statistical Views}},
        author = {El-Helw, Amr and Ilyas, Ihab F. and Zuzarte, Calisto},
        journal = {PVLDB},
        series = {{VLDB} '09},
        doi = {10.14778/1687553.1687556},
        url = {https://doi.org/10.14778/1687553.1687556},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,609	SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning	2019	SIGMOD	0.0001007196
1,803	SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning	2018	VLDB	9.5987229e-05
2,040	Database Learning: Toward a Database that Becomes Smarter Every Time	2017	SIGMOD	9.1319608e-05
4,252	Adaptive Statistics in Oracle 12c	2017	VLDB	6.6894038e-05
6,779	Guided automated learning for query workload re-optimization	2019	VLDB	5.6686556e-05
7,927	A Practical Approach to Groupjoin and Nested Aggregates	2021	VLDB	5.4082473e-05
9,141	Presto’s History-based Query Optimizer	2024	VLDB	5.2078543e-05

Outgoing Citations (Sorted by Pagerank)

Showing 18 of 18 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
57	On Random Sampling over Joins	1999	SIGMOD	0.0003999751
89	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035265687
91	On the Propagation of Errors in the Size of Join Results	1991	SIGMOD	0.00034691614
98	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00034050614
138	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00029532435
149	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00028910892
160	CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies	2004	SIGMOD	0.00027775994
175	Simple Random Sampling from Relational Databases	1986	VLDB	0.00026701703
189	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.00025846085
471	Robust Query Processing through Progressive Optimization	2004	SIGMOD	0.00017691682
568	Towards a Robust Query Optimizer: A Principled and Practical Approach	2005	SIGMOD	0.00016221103
646	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.00015166402
838	Proactive Re-Optimization	2005	SIGMOD	0.00013528646
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012224962
2,438	Cardinality Estimation Using Sample Views with Quality Assurance	2007	SIGMOD	8.4532693e-05
3,142	Statistics on Views	2003	VLDB	7.5858292e-05
3,371	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD	7.3493132e-05
4,672	Automated Statistics Collection in DB2 UDB	2004	VLDB	6.4593469e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	89	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB
2	10,343	Fast Approximate Computation of Statistics on Views	2006	SIGMOD
3	568	Towards a Robust Query Optimizer: A Principled and Practical Approach	2005	SIGMOD
4	3,393	A Formal Perspective on the View Selection Problem	2001	VLDB
5	3,371	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD
6	4,252	Adaptive Statistics in Oracle 12c	2017	VLDB
7	646	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD
8	676	Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques	2012	VLDB
9	189	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB
10	3,142	Statistics on Views	2003	VLDB