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.00025846085
Overall Rank
189 | 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
7,451 An Automated, Yet Interactive and Portable DB Designer 2010 SIGMOD 5.5106847e-05
7,838 Automated design of multidimensional clustering tables for relational databases 2004 VLDB 5.4264579e-05
8,372 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.3287108e-05
8,630 A Storage Advisor for Hybrid-Store Databases 2012 VLDB 5.2843511e-05
8,780 Goals and Benchmarks for Autonomic Configuration Recommenders 2005 SIGMOD 5.2650571e-05
8,892 Divergent Physical Design Tuning for Replicated Databases 2012 SIGMOD 5.2420764e-05
9,718 Progressive Partitioning for Parallelized Query Execution in Google’s Napa 2023 VLDB 5.1232608e-05
9,895 Kaizen: A Semi-Automatic Index Advisor 2012 SIGMOD 5.1000511e-05
10,165 Amoeba: A Shape changing Storage System for Big Data 2016 VLDB 5.0561788e-05
10,216 Adaptive Schema Databases 2017 CIDR 5.0468526e-05
11,443 SQL:Trek Automated Index Design at Airbnb 2025 VLDB 4.9605343e-05
11,971 Budget-Conscious Fine-Grained Configuration Optimization for Spatio-Temporal Applications 2022 VLDB 4.9605343e-05
12,673 Building User-defined Runtime Adaptation Routines for Stream Processing Applications 2012 VLDB 4.9605343e-05
12,835 A Framework for Testing Query Transformation Rules 2009 SIGMOD 4.9605343e-05
12,935 When is it Time to Rethink the Aggregate Configuration of Your OLAP Server? 2008 VLDB 4.9605343e-05
12,954 The Data Ring: Community Content Sharing 2007 CIDR 4.9605343e-05
12,982 Online AutoAdmin (Physical Design Tuning) 2007 SIGMOD 4.9605343e-05
13,006 Deadline and QoS Aware Data Warehouse 2007 VLDB 4.9605343e-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
89 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035265687
196 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025581936
243 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023296011
380 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019530546
1,059 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00012224962
1,246 Compressing SQL Workloads 2002 SIGMOD 0.00011355447
1,916 Microsoft Index Tuning Wizard for SQL Server 7.0 1998 SIGMOD 9.3655818e-05
2,245 Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 2003 SIGMOD 8.7628897e-05
2,490 An Overview of DB2 Parallel Edition 1995 SIGMOD 8.3779406e-05
3,007 The Value of Merge-Join and Hash-Join in SQL Server 1999 VLDB 7.7452155e-05
7,838 Automated design of multidimensional clustering tables for relational databases 2004 VLDB 5.4264579e-05
13,183 SMART: Making DB2 (More) Autonomic 2002 VLDB 4.9605343e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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