SMART: Making DB2 (More) Autonomic

Summary: SMART advances DB2 toward autonomic operation, reducing DBA effort and total cost of ownership. It targets end-to-end administration—deployment, physical design, maintenance, problem diagnosis, availability, and recovery—rather than only query tuning. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: hc7aa5ba342a1993f
Venue: VLDB
Year: 2002
Pagerank: 4.9793485e-05
Overall Rank: 13,136 | 11.69%
DOI: 10.1016/B978-155860869-6/50085-8

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Guy M. Lohman (IBM)
2. Sam S. Lightstone (IBM)

BibTeX Citation

@article{lohman_vldb02,
        title = {{SMART: Making DB2 (More) Autonomic}},
        author = {Lohman, Guy M. and Lightstone, Sam S.},
        journal = {PVLDB},
        series = {{VLDB} '02},
        doi = {10.1016/B978-155860869-6/50085-8},
        url = {https://doi.org/10.1016/B978-155860869-6/50085-8},
        year = {2002}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
187	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.0002592488

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035351639
98	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00034106982
243	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.00023358891
378	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00019549382
1,905	Microsoft Index Tuning Wizard for SQL Server 7.0	1998	SIGMOD	9.3983929e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	14,503	IBM's DB2 Universal Database demonstrations at VLDB '98	1998	VLDB
2	13,029	SMART: A Tool for Semantic-Driven Creation of Complex XML Mappings	2005	SIGMOD
3	6,047	Experience from a Real Life Query Optimizer	1992	SIGMOD
4	224	Self-Driving Database Management Systems	2017	CIDR
5	6,251	Foundations of Automated Database Tuning	2006	VLDB
6	4,659	Automated Statistics Collection in DB2 UDB	2004	VLDB
7	187	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB
8	9,620	Db2une: Tuning Under Pressure via Deep Learning	2024	VLDB
9	508	Adaptive Self-Tuning Memory in DB2	2006	VLDB
10	6,823	Self-Managing Technology in Database Management Systems	2004	VLDB