Database Paper Browser

Back to papers

Automated Statistics Collection in DB2 UDB

Summary: Introduces Automated Statistics Collection (ASC) in DB2 UDB, an autonomic engine replacing manual DBA maintenance. ASC leverages UDI activity and query feedback to auto-tune which statistics to collect and when, improving query performance without administrator intervention. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
9132
Venue
VLDB
Year
2004
Pagerank
5.7533741e-05
Overall Rank
5,025 | 65.05%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 14 of 14 citing papers.

Rank Citing Paper Year Venue Pagerank
2,156 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2018 VLDB 9.4170209e-05
2,219 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2019 SIGMOD 9.2623533e-05
2,356 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 8.9620762e-05
2,549 GORDIAN: Efficient and Scalable Discovery of Composite Keys 2006 VLDB 8.5641554e-05
2,665 Statistical Learning Techniques for Costing XML Queries 2005 VLDB 8.3498101e-05
3,952 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 6.5939652e-05
5,668 A Pay-As-You-Go Framework for Query Execution Feedback 2008 VLDB 5.3806337e-05
5,815 StatAdvisor: Recommending Statistical Views 2009 VLDB 5.3165295e-05
6,049 POP/FED: Progressive Query Optimization for Federated Queries in DB2 2006 VLDB 5.2360942e-05
7,415 Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g 2008 SIGMOD 4.7355557e-05
9,187 POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance 2024 VLDB 4.3780059e-05
9,524 Detecting Attribute Dependencies from Query Feedback 2007 VLDB 4.3310217e-05
12,060 Statistics Collection in Oracle Spatial and Graph: Fast Histogram Construction for Complex Geometry Objects 2013 VLDB 4.1945683e-05
13,656 Automated Statistics Collection in Action 2005 SIGMOD -
Previous Page 1 / 1 Next

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
64 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00063612837
182 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00036962631
224 CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies 2004 SIGMOD 0.00032746205
512 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00021380733
529 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00020828852
790 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.0001663283
2,137 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB 9.4719326e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
6,433 Self-Managing Technology in Database Management Systems 2004 VLDB 5.0642403e-05
716 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00017723171
7,603 Automated design of multidimensional clustering tables for relational databases 2004 VLDB 4.6985903e-05
6,520 Foundations of Automated Database Tuning 2006 VLDB 5.0307595e-05
6,197 O-O, What Have They Done to DB2? 1999 VLDB 5.1614115e-05
258 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.0003022091
4,571 Adaptive Statistics in Oracle 12c 2017 VLDB 6.0773174e-05
6,548 Query Sampling in DB2 Universal Database 2004 SIGMOD 5.0181595e-05
8,167 Maintenance of Cube Automatic Summary Tables 2000 SIGMOD 4.5705919e-05
13,656 Automated Statistics Collection in Action 2005 SIGMOD -