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: 3413
Venue: SIGMOD
Year: 2002
Pagerank: 6.9972756e-05
Overall Rank: 3,533 | 75.45%
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
841	Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering	2002	VLDB	0.00015987128
1,284	Photon: Fault-tolerant and Scalable Joining of Continuous Data Streams	2013	SIGMOD	0.00012820565
3,655	Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation	2022	VLDB	6.8723042e-05
4,340	Quantifying Isolation Anomalies	2009	VLDB	6.269792e-05
5,834	An Efficient Transfer Learning Based Configuration Adviser for Database Tuning	2024	VLDB	5.3082111e-05
6,394	Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty	2022	VLDB	5.0770427e-05
7,010	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	4.8589148e-05
7,517	Getting Priorities Straight: Improving Linux Support for Database I/O	2005	VLDB	4.7135369e-05
10,247	Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents	2026	VLDB	4.1905499e-05
10,313	DOT: Dynamic Knob Selection and Online Sampling for Automated Database Tuning	2026	VLDB	4.1905499e-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.7235588e-05
2,788	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB	8.121027e-05
3,276	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD	7.2880761e-05
9,892	Foundations of Automated Database Tuning	2005	SIGMOD	4.2572136e-05
423	Tuning Database Configuration Parameters with iTuned	2009	VLDB	0.00023628474
5,055	Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications	2009	VLDB	5.72317e-05
6,494	Foundations of Automated Database Tuning	2006	VLDB	5.0334983e-05
3,655	Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation	2022	VLDB	6.8723042e-05
7,834	Database Tuning	1992	VLDB	4.6361103e-05
13,785	Database Tuning: principles, experiments, and troubleshooting techniques	2002	SIGMOD	-