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)
Incoming Non-self Citations Over Time
Authors
- 1. Sanjay Agrawal
- 2. Eric Chu
- 3. Vivek Narasayya
Incoming Citations (Sorted by Pagerank)
Showing 11 of 11 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,855 | AI Meets AI: Leveraging Query Executions to Improve Index Recommendations | 2019 | SIGMOD | 0.00010315245 |
| 2,533 | DeepLens: Towards a Visual Data Management System | 2019 | CIDR | 8.5899934e-05 |
| 3,354 | An Object Placement Advisor for DB2 Using Solid State Storage | 2009 | VLDB | 7.1837096e-05 |
| 4,415 | Semi-Automatic Index Tuning: Keeping DBAs in the Loop | 2012 | VLDB | 6.205081e-05 |
| 4,802 | Resource Elasticity for Large-Scale Machine Learning | 2015 | SIGMOD | 5.9114415e-05 |
| 5,506 | Exploring Change – A New Dimension of Data Analytics | 2019 | VLDB | 5.473324e-05 |
| 6,920 | Towards Cost-Effective Storage Provisioning for DBMSs | 2012 | VLDB | 4.8925595e-05 |
| 8,859 | Pipemizer: An Optimizer for Analytics Data Pipelines | 2022 | VLDB | 4.4344107e-05 |
| 9,579 | Kaizen: A Semi-Automatic Index Advisor | 2012 | SIGMOD | 4.3236869e-05 |
| 12,001 | Thoth: Towards Managing a Multi-System Cluster | 2014 | VLDB | 4.1945683e-05 |
| 12,461 | Bridging the Application and DBMS Profiling Divide for Database Application Developers | 2007 | VLDB | 4.1945683e-05 |
Previous
Page 1 / 1
Next
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.00031726304 |
| 258 | DB2 Design Advisor: Integrated Automatic Physical Database Design | 2004 | VLDB | 0.0003022091 |
| 285 | Automating Physical Database Design in a Parallel Database | 2002 | SIGMOD | 0.0002899128 |
| 286 | Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design | 2004 | SIGMOD | 0.00028990057 |
| 496 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB | 0.00021728655 |
| 661 | Database Tuning Advisor for Microsoft SQL Server 2005 | 2004 | VLDB | 0.00018481174 |
| 874 | Index Selection in a Self-Adaptive Data Base Management System | 1976 | SIGMOD | 0.00015728533 |
| 1,017 | Automatic Physical Database Tuning: A Relaxation-based Approach | 2005 | SIGMOD | 0.00014634307 |
| 5,413 | QUIET: Continuous Query-driven Index Tuning | 2003 | VLDB | 5.5203159e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 13,738 | Coarse-Grained Optimization: Techniques for Rewriting SQL Statement Sequences | 2003 | VLDB | - |
| 2,065 | Towards Automated Performance Tuning For Complex Workloads | 1994 | VLDB | 9.6410693e-05 |
| 12,450 | Online AutoAdmin (Physical Design Tuning) | 2007 | SIGMOD | 4.1945683e-05 |
| 285 | Automating Physical Database Design in a Parallel Database | 2002 | SIGMOD | 0.0002899128 |
| 2,787 | To Tune or not to Tune? A Lightweight Physical Design Alerter | 2006 | VLDB | 8.1263608e-05 |
| 1,006 | A Framework for Automating Physical Database Design | 1991 | VLDB | 0.00014688178 |
| 6,520 | Foundations of Automated Database Tuning | 2006 | VLDB | 5.0307595e-05 |
| 3,284 | Configuration-Parametric Query Optimization for Physical Design Tuning | 2008 | SIGMOD | 7.2790444e-05 |
| 3,072 | Constrained Physical Design Tuning | 2008 | VLDB | 7.6114086e-05 |
| 1,017 | Automatic Physical Database Tuning: A Relaxation-based Approach | 2005 | SIGMOD | 0.00014634307 |