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: 9095
Venue: VLDB
Year: 2002
Pagerank: 5.093636e-05
Overall Rank: 12,846 | 11.87%
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
184	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.00026256101

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
87	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035281619
100	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00034385207
246	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.00023457421
387	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00019442332
1,870	Microsoft Index Tuning Wizard for SQL Server 7.0	1998	SIGMOD	9.579726e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	14,192	IBM's DB2 Universal Database demonstrations at VLDB '98	1998	VLDB
2	12,739	SMART: A Tool for Semantic-Driven Creation of Complex XML Mappings	2005	SIGMOD
3	5,930	Experience from a Real Life Query Optimizer	1992	SIGMOD
4	234	Self-Driving Database Management Systems	2017	CIDR
5	6,131	Foundations of Automated Database Tuning	2006	VLDB
6	4,591	Automated Statistics Collection in DB2 UDB	2004	VLDB
7	184	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB
8	9,441	Db2une: Tuning Under Pressure via Deep Learning	2024	VLDB
9	523	Adaptive Self-Tuning Memory in DB2	2006	VLDB
10	6,700	Self-Managing Technology in Database Management Systems	2004	VLDB