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
9318
Venue
VLDB
Year
2004
Pagerank
0.00026256101
Overall Rank
184 | 98.74%
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 18 of 68 citing papers.

Rank Citing Paper Year Venue Pagerank
8,193 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.4696038e-05
8,452 A Storage Advisor for Hybrid-Store Databases 2012 VLDB 5.4230061e-05
8,601 Goals and Benchmarks for Autonomic Configuration Recommenders 2005 SIGMOD 5.4048965e-05
8,703 Divergent Physical Design Tuning for Replicated Databases 2012 SIGMOD 5.3813751e-05
9,715 Kaizen: A Semi-Automatic Index Advisor 2012 SIGMOD 5.2337048e-05
9,953 Amoeba: A Shape changing Storage System for Big Data 2016 VLDB 5.1901412e-05
10,003 Adaptive Schema Databases 2017 CIDR 5.1814573e-05
10,059 Progressive Partitioning for Parallelized Query Execution in Google’s Napa 2023 VLDB 5.1664022e-05
10,773 Physical Visualization Design: Decoupling Interface and System Design 2025 SIGMOD 5.093636e-05
11,019 SQL:Trek Automated Index Design at Airbnb 2025 VLDB 5.093636e-05
11,277 Index Advisors on Quantum Platforms 2024 VLDB 5.093636e-05
11,613 Budget-Conscious Fine-Grained Configuration Optimization for Spatio-Temporal Applications 2022 VLDB 5.093636e-05
12,333 Building User-defined Runtime Adaptation Routines for Stream Processing Applications 2012 VLDB 5.093636e-05
12,496 A Framework for Testing Query Transformation Rules 2009 SIGMOD 5.093636e-05
12,597 When is it Time to Rethink the Aggregate Configuration of Your OLAP Server? 2008 VLDB 5.093636e-05
12,616 The Data Ring: Community Content Sharing 2007 CIDR 5.093636e-05
12,644 Online AutoAdmin (Physical Design Tuning) 2007 SIGMOD 5.093636e-05
12,668 Deadline and QoS Aware Data Warehouse 2007 VLDB 5.093636e-05
Previous Page 2 / 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
87 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035281619
199 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025612088
246 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023457421
387 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019442332
1,034 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00012516197
1,266 Compressing SQL Workloads 2002 SIGMOD 0.00011412078
1,870 Microsoft Index Tuning Wizard for SQL Server 7.0 1998 SIGMOD 9.579726e-05
2,197 Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 2003 SIGMOD 8.9684812e-05
2,444 An Overview of DB2 Parallel Edition 1995 SIGMOD 8.5743744e-05
2,952 The Value of Merge-Join and Hash-Join in SQL Server 1999 VLDB 7.9255489e-05
7,770 Automated design of multidimensional clustering tables for relational databases 2004 VLDB 5.5474421e-05
12,846 SMART: Making DB2 (More) Autonomic 2002 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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