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: 9133
Venue: VLDB
Year: 2004
Pagerank: 5.7492033e-05
Overall Rank: 5,019 | 65.12%
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,154	SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning	2018	VLDB	9.4176683e-05
2,222	SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning	2019	SIGMOD	9.2598438e-05
2,359	Consistently Estimating the Selectivity of Conjuncts of Predicates	2005	VLDB	8.967267e-05
2,551	GORDIAN: Efficient and Scalable Discovery of Composite Keys	2006	VLDB	8.5553153e-05
2,667	Statistical Learning Techniques for Costing XML Queries	2005	VLDB	8.3444649e-05
3,943	Exact Cardinality Query Optimization for Optimizer Testing	2009	VLDB	6.6067351e-05
5,676	A Pay-As-You-Go Framework for Query Execution Feedback	2008	VLDB	5.3768269e-05
5,824	StatAdvisor: Recommending Statistical Views	2009	VLDB	5.311975e-05
6,053	POP/FED: Progressive Query Optimization for Federated Queries in DB2	2006	VLDB	5.2310929e-05
7,414	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD	4.7312542e-05
9,191	POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance	2024	VLDB	4.3738237e-05
9,525	Detecting Attribute Dependencies from Query Feedback	2007	VLDB	4.326879e-05
12,068	Statistics Collection in Oracle Spatial and Graph: Fast Histogram Construction for Complex Geometry Objects	2013	VLDB	4.1905499e-05
13,670	Automated Statistics Collection in Action	2005	SIGMOD	-

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
63	Improved Histograms for Selectivity Estimation of Range Predicates	1996	SIGMOD	0.00063595699
181	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00036970794
224	CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies	2004	SIGMOD	0.00032743209
512	STHoles: A Multidimensional Workload-Aware Histogram	2001	SIGMOD	0.00021385343
527	Self-tuning Histograms: Building Histograms Without Looking at Data	1999	SIGMOD	0.00020862475
786	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.00016624743
2,136	SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads	2003	VLDB	9.4668797e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
704	Query-based Workload Forecasting for Self-Driving Database Management Systems	2018	SIGMOD	0.00017785557
6,429	Self-Managing Technology in Database Management Systems	2004	VLDB	5.0595863e-05
7,591	Automated design of multidimensional clustering tables for relational databases	2004	VLDB	4.6986414e-05
6,494	Foundations of Automated Database Tuning	2006	VLDB	5.0334983e-05
6,199	O-O, What Have They Done to DB2?	1999	VLDB	5.1564406e-05
258	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.00030196528
4,566	Adaptive Statistics in Oracle 12c	2017	VLDB	6.073045e-05
6,543	Query Sampling in DB2 Universal Database	2004	SIGMOD	5.0139217e-05
8,169	Maintenance of Cube Automatic Summary Tables	2000	SIGMOD	4.5662628e-05
13,670	Automated Statistics Collection in Action	2005	SIGMOD	-