Database Tuning: principles, experiments, and troubleshooting techniques

Summary: Principled, experimentally-driven study of database tuning that moves beyond ad-hoc indexing. Reports lessons from building a tuning book, with public experiment code and a tutorial on core tuning techniques for data-management researchers. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3412
Venue: SIGMOD
Year: 2002
Pagerank: 6.995825e-05
Overall Rank: 3,538 | 75.39%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Dennis Shasha
2. Philippe Bonnet

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
846	Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering	2002	VLDB	0.00015997985
1,286	Photon: Fault-tolerant and Scalable Joining of Continuous Data Streams	2013	SIGMOD	0.0001282373
3,812	Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation	2022	VLDB	6.7373184e-05
4,343	Quantifying Isolation Anomalies	2009	VLDB	6.2757607e-05
6,151	An Efficient Transfer Learning Based Configuration Adviser for Database Tuning	2024	VLDB	5.183652e-05
6,398	Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty	2022	VLDB	5.0819209e-05
7,010	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	4.8634875e-05
7,518	Getting Priorities Straight: Improving Linux Support for Database I/O	2005	VLDB	4.7180617e-05
10,247	Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents	2026	VLDB	4.1945683e-05
10,301	DOT: Dynamic Knob Selection and Online Sampling for Automated Database Tuning	2026	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 0 of 0 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
7,445	An Automated, Yet Interactive and Portable DB Designer	2010	SIGMOD	4.7278675e-05
2,787	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB	8.1263608e-05
3,284	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD	7.2790444e-05
9,893	Foundations of Automated Database Tuning	2005	SIGMOD	4.2612967e-05
424	Tuning Database Configuration Parameters with iTuned	2009	VLDB	0.00023616398
5,060	Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications	2009	VLDB	5.7273583e-05
6,520	Foundations of Automated Database Tuning	2006	VLDB	5.0307595e-05
3,812	Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation	2022	VLDB	6.7373184e-05
7,862	Database Tuning	1992	VLDB	4.6330193e-05
13,771	Database Tuning: principles, experiments, and troubleshooting techniques	2002	SIGMOD	-