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: 3474
Venue: SIGMOD
Year: 2002
Pagerank: 7.5421438e-05
Overall Rank: 3,298 | 77.38%
DOI: 10.1145/564691.564798

Incoming Non-self Citations Over Time

Authors

1. Dennis Shasha (New York University)
2. Philippe Bonnet (University of Copenhagen)

BibTeX Citation

@inproceedings{shasha_sigmod02,
        title = {{Database Tuning: principles, experiments, and troubleshooting techniques}},
        author = {Shasha, Dennis and Bonnet, Philippe},
        series = {{SIGMOD} '02},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/564691.564798},
        url = {https://dl.acm.org/doi/10.1145/564691.564798},
        year = {2002}
}

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
781	Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering	2002	VLDB	0.00014085674
1,171	Photon: Fault-tolerant and Scalable Joining of Continuous Data Streams	2013	SIGMOD	0.00011826434
2,740	Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation	2022	VLDB	8.1855759e-05
3,940	Quantifying Isolation Anomalies	2009	VLDB	7.0080239e-05
5,171	An Efficient Transfer Learning Based Configuration Adviser for Database Tuning	2024	VLDB	6.3347618e-05
5,766	Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty	2022	VLDB	6.094771e-05
7,098	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	5.7046615e-05
7,938	Getting Priorities Straight: Improving Linux Support for Database I/O	2005	VLDB	5.5181056e-05
10,535	Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents	2026	VLDB	5.093636e-05
10,599	DOT: Dynamic Knob Selection and Online Sampling for Automated Database Tuning	2026	VLDB	5.093636e-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
1	7,346	An Automated, Yet Interactive and Portable DB Designer	2010	SIGMOD
2	2,364	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB
3	3,003	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD
4	10,047	Foundations of Automated Database Tuning	2005	SIGMOD
5	347	Tuning Database Configuration Parameters with iTuned	2009	VLDB
6	4,550	Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications	2009	VLDB
7	6,131	Foundations of Automated Database Tuning	2006	VLDB
8	2,740	Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation	2022	VLDB
9	7,649	Database Tuning	1992	VLDB
10	13,972	Database Tuning: principles, experiments, and troubleshooting techniques	2002	SIGMOD