DBScholar

Back to papers

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
10095
Venue
VLDB
Year
2009
Pagerank
6.1901666e-05
Overall Rank
5,514 | 62.17%
DOI
10.14778/1687553.1687556

Incoming Non-self Citations Over Time

Authors

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,712 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2019 SIGMOD 9.9492299e-05
1,815 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2018 VLDB 9.6894541e-05
1,995 Database Learning: Toward a Database that Becomes Smarter Every Time 2017 SIGMOD 9.3403665e-05
4,277 Adaptive Statistics in Oracle 12c 2017 VLDB 6.7873816e-05
6,938 Guided automated learning for query workload re-optimization 2019 VLDB 5.733869e-05
7,787 A Practical Approach to Groupjoin and Nested Aggregates 2021 VLDB 5.5449593e-05
11,290 Presto’s History-based Query Optimizer 2024 VLDB 5.093636e-05
Previous Page 1 / 1 Next

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
54 On Random Sampling over Joins 1999 SIGMOD 0.00040810225
87 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035281619
89 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00035031529
100 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034385207
136 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00030123303
151 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00029161879
159 CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies 2004 SIGMOD 0.00028129426
173 Simple Random Sampling from Relational Databases 1986 VLDB 0.00027273858
184 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.00026256101
492 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.0001756877
566 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016436005
664 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00015167825
829 Proactive Re-Optimization 2005 SIGMOD 0.00013769838
1,034 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00012516197
2,404 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 8.6225576e-05
3,093 Statistics on Views 2003 VLDB 7.7664764e-05
3,309 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.5368417e-05
4,591 Automated Statistics Collection in DB2 UDB 2004 VLDB 6.614318e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 87 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB
2 10,090 Fast Approximate Computation of Statistics on Views 2006 SIGMOD
3 566 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD
4 3,330 A Formal Perspective on the View Selection Problem 2001 VLDB
5 3,309 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD
6 4,277 Adaptive Statistics in Oracle 12c 2017 VLDB
7 664 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 184 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB
10 3,093 Statistics on Views 2003 VLDB