Automatic Physical Design Tuning: Workload as a Sequence

Summary: Treat workload as a sequence, not a bag of statements, to guide automatic physical design tuning. Introduces techniques to exploit ordering in workloads and validates gains on Microsoft SQL Server. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3793
Venue: SIGMOD
Year: 2006
Pagerank: 8.0468556e-05
Overall Rank: 2,834 | 80.31%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 11 of 11 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,856	AI Meets AI: Leveraging Query Executions to Improve Index Recommendations	2019	SIGMOD	0.00010319105
2,536	DeepLens: Towards a Visual Data Management System	2019	CIDR	8.5817195e-05
3,358	An Object Placement Advisor for DB2 Using Solid State Storage	2009	VLDB	7.1724434e-05
4,412	Semi-Automatic Index Tuning: Keeping DBAs in the Loop	2012	VLDB	6.1999789e-05
4,807	Resource Elasticity for Large-Scale Machine Learning	2015	SIGMOD	5.9045148e-05
5,520	Exploring Change – A New Dimension of Data Analytics	2019	VLDB	5.4680662e-05
6,922	Towards Cost-Effective Storage Provisioning for DBMSs	2012	VLDB	4.8878659e-05
8,859	Pipemizer: An Optimizer for Analytics Data Pipelines	2022	VLDB	4.4301601e-05
9,578	Kaizen: A Semi-Automatic Index Advisor	2012	SIGMOD	4.3195435e-05
12,009	Thoth: Towards Managing a Multi-System Cluster	2014	VLDB	4.1905499e-05
12,470	Bridging the Application and DBMS Profiling Divide for Database Application Developers	2007	VLDB	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
237	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00031727601
258	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.00030196528
283	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00029024583
285	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.00028978423
495	Automatic SQL Tuning in Oracle 10g	2004	VLDB	0.00021712703
662	Database Tuning Advisor for Microsoft SQL Server 2005	2004	VLDB	0.00018478597
845	Index Selection in a Self-Adaptive Data Base Management System	1976	SIGMOD	0.00015953779
1,018	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD	0.00014626746
5,421	QUIET: Continuous Query-driven Index Tuning	2003	VLDB	5.5152497e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
13,752	Coarse-Grained Optimization: Techniques for Rewriting SQL Statement Sequences	2003	VLDB	-
2,069	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB	9.6356256e-05
12,459	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD	4.1905499e-05
285	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.00028978423
2,788	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB	8.121027e-05
1,007	A Framework for Automating Physical Database Design	1991	VLDB	0.00014683533
6,494	Foundations of Automated Database Tuning	2006	VLDB	5.0334983e-05
3,276	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD	7.2880761e-05
3,077	Constrained Physical Design Tuning	2008	VLDB	7.6043371e-05
1,018	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD	0.00014626746