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.0718206e-05
Overall Rank: 5,597 | 62.37%
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,603	SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning	2019	SIGMOD	0.00010097649
1,800	SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning	2018	VLDB	9.6093317e-05
2,027	Database Learning: Toward a Database that Becomes Smarter Every Time	2017	SIGMOD	9.1618139e-05
4,234	Adaptive Statistics in Oracle 12c	2017	VLDB	6.7134191e-05
6,764	Guided automated learning for query workload re-optimization	2019	VLDB	5.6873334e-05
7,907	A Practical Approach to Groupjoin and Nested Aggregates	2021	VLDB	5.4287568e-05
9,113	Presto’s History-based Query Optimizer	2024	VLDB	5.2276066e-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.00040108301
88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035351639
91	On the Propagation of Errors in the Size of Join Results	1991	SIGMOD	0.0003475226
98	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00034106982
138	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00029627449
149	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00028981723
160	CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies	2004	SIGMOD	0.00027837289
175	Simple Random Sampling from Relational Databases	1986	VLDB	0.00026784195
187	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.0002592488
481	Robust Query Processing through Progressive Optimization	2004	SIGMOD	0.00017603972
569	Towards a Robust Query Optimizer: A Principled and Practical Approach	2005	SIGMOD	0.00016245271
646	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.0001520859
836	Proactive Re-Optimization	2005	SIGMOD	0.00013557047
1,054	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012269068
2,433	Cardinality Estimation Using Sample Views with Quality Assurance	2007	SIGMOD	8.4766785e-05
3,133	Statistics on Views	2003	VLDB	7.6127492e-05
3,361	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD	7.3760492e-05
4,659	Automated Statistics Collection in DB2 UDB	2004	VLDB	6.4822228e-05

Semantically Similar Papers

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