DBScholar

Back to papers

DB2 Design Advisor: Integrated Automatic Physical Database Design

Summary: Integrated automatic physical design of four features: indexes, materialized views, shared-nothing partitioning, and multidimensional clustering. Hybrid design with modular components and workload reduction for scalable, near-optimal recommendations. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hd232ccb6ffbb0929
Venue
VLDB
Year
2004
Pagerank
0.0002592488
Overall Rank
187 | 98.75%
DOI
10.1016/B978-012088469-8.50095-4

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{zilio_vldb04,
        title = {{DB2 Design Advisor: Integrated Automatic Physical Database Design}},
        author = {Zilio, Daniel C. and Rao, Jun and Lightstone, Sam and Lohman, Guy and Storm, Adam and Garcia-Arellano, Christian and Fadden, Scott},
        journal = {PVLDB},
        series = {{VLDB} '04},
        pages = {1087--1098},
        doi = {10.1016/B978-012088469-8.50095-4},
        url = {https://doi.org/10.1016/B978-012088469-8.50095-4},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 68 citing papers.

Rank Citing Paper Year Venue Pagerank
224 Self-Driving Database Management Systems 2017 CIDR 0.00024013745
314 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00021282642
472 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.00017692264
508 Adaptive Self-Tuning Memory in DB2 2006 VLDB 0.00017089907
702 Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct 2009 VLDB 0.00014673738
751 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.0001425375
1,069 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.00012185253
1,132 Qd-tree: Learning Data Layouts for Big Data Analytics 2020 SIGMOD 0.00011898257
1,279 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011226878
1,397 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB 0.00010789242
1,516 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010402594
1,694 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8562172e-05
1,815 CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads 2011 VLDB 9.5791737e-05
1,883 Automated Partitioning Design in Parallel Database Systems 2011 SIGMOD 9.4391795e-05
1,925 Here are my Data Files. Here are my Queries. Where are my Results? 2011 CIDR 9.3670488e-05
2,023 Efficient Use of the Query Optimizer for Automated Physical Design 2007 VLDB 9.1669658e-05
2,250 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7533306e-05
2,275 Active Learning for ML Enhanced Database Systems 2020 SIGMOD 8.7090584e-05
2,373 To Tune or not to Tune? A Lightweight Physical Design Alerter 2006 VLDB 8.5606392e-05
2,478 Learning a Partitioning Advisor for Cloud Databases 2020 SIGMOD 8.4079121e-05
2,775 Automatic Physical Design Tuning: Workload as a Sequence 2006 SIGMOD 8.0312847e-05
2,857 Constrained Physical Design Tuning 2008 VLDB 7.9380294e-05
2,882 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.9116043e-05
3,041 Configuration-Parametric Query Optimization for Physical Design Tuning 2008 SIGMOD 7.7215151e-05
3,367 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.3719456e-05
3,406 Native Store Extension for SAP HANA 2019 VLDB 7.3281944e-05
3,445 Slalom: Coasting Through Raw Data via Adaptive Partitioning and Indexing 2017 VLDB 7.2943981e-05
3,446 Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing 2019 SIGMOD 7.2942885e-05
3,590 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.1865343e-05
3,606 Updating a Cracked Database 2007 SIGMOD 7.1686756e-05
3,878 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 6.9512776e-05
4,007 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.8592987e-05
4,116 Resource Elasticity for Large-Scale Machine Learning 2015 SIGMOD 6.7961306e-05
4,533 AdaptDB: Adaptive Partitioning for Distributed Joins 2017 VLDB 6.5565658e-05
4,569 COLT: Continuous On-Line Database Tuning 2006 SIGMOD 6.5298888e-05
4,607 Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications 2009 VLDB 6.5037336e-05
4,690 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.4687131e-05
4,711 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB 6.4573842e-05
5,131 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.2602133e-05
5,248 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.211056e-05
5,597 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.0718206e-05
5,674 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 6.0430252e-05
5,853 Compression Aware Physical Database Design 2011 VLDB 5.9710387e-05
6,208 Efficient Detection of Empty-Result Queries 2006 VLDB 5.8497045e-05
6,636 Physical Visualization Design: Decoupling Interface and System Design 2025 SIGMOD 5.7262507e-05
6,764 Guided automated learning for query workload re-optimization 2019 VLDB 5.6873334e-05
6,970 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 5.6311067e-05
7,157 Sibyl: Forecasting Time-Evolving Query Workloads 2024 SIGMOD 5.5972283e-05
7,231 QueryScope: Visualizing Queries for Repeatable Database Tuning 2008 VLDB 5.5793e-05
7,403 Index Advisors on Quantum Platforms 2024 VLDB 5.5357529e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

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

Rank Cited Paper Year Venue Pagerank
88 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035351639
195 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025628849
243 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023358891
378 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019549382
1,054 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00012269068
1,242 Compressing SQL Workloads 2002 SIGMOD 0.00011373611
1,905 Microsoft Index Tuning Wizard for SQL Server 7.0 1998 SIGMOD 9.3983929e-05
2,233 Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 2003 SIGMOD 8.7931449e-05
2,479 An Overview of DB2 Parallel Edition 1995 SIGMOD 8.4072014e-05
2,994 The Value of Merge-Join and Hash-Join in SQL Server 1999 VLDB 7.7710643e-05
7,845 Automated design of multidimensional clustering tables for relational databases 2004 VLDB 5.4420146e-05
13,136 SMART: Making DB2 (More) Autonomic 2002 VLDB 4.9793485e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 491 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB
2 2,373 To Tune or not to Tune? A Lightweight Physical Design Alerter 2006 VLDB
3 1,262 A Framework for Automating Physical Database Design 1991 VLDB
4 12,856 An XML Index Advisor for DB2 2008 SIGMOD
5 751 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD
6 2,233 Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 2003 SIGMOD
7 7,425 An Automated, Yet Interactive and Portable DB Designer 2010 SIGMOD
8 5,597 StatAdvisor: Recommending Statistical Views 2009 VLDB
9 4,607 Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications 2009 VLDB
10 7,845 Automated design of multidimensional clustering tables for relational databases 2004 VLDB