Database Paper Browser

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
9127
Venue
VLDB
Year
2004
Pagerank
0.0003022091
Overall Rank
258 | 98.21%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 18 of 68 citing papers.

Rank Citing Paper Year Venue Pagerank
8,272 Divergent Physical Design Tuning for Replicated Databases 2012 SIGMOD 4.5452316e-05
8,389 A Storage Advisor for Hybrid-Store Databases 2012 VLDB 4.5296588e-05
8,391 Goals and Benchmarks for Autonomic Configuration Recommenders 2005 SIGMOD 4.5287897e-05
8,416 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 4.5196199e-05
9,579 Kaizen: A Semi-Automatic Index Advisor 2012 SIGMOD 4.3236869e-05
9,801 Amoeba: A Shape changing Storage System for Big Data 2016 VLDB 4.2815507e-05
9,851 Adaptive Schema Databases 2017 CIDR 4.2721228e-05
9,905 Progressive Partitioning for Parallelized Query Execution in Google's Napa 2023 VLDB 4.258022e-05
10,496 Physical Visualization Design: Decoupling Interface and System Design 2025 SIGMOD 4.1945683e-05
10,790 SQL:Trek Automated Index Design at Airbnb 2025 VLDB 4.1945683e-05
11,071 Index Advisors on Quantum Platforms 2024 VLDB 4.1945683e-05
11,415 Budget-Conscious Fine-Grained Configuration Optimization for Spatio-Temporal Applications 2022 VLDB 4.1945683e-05
12,137 Building User-defined Runtime Adaptation Routines for Stream Processing Applications 2012 VLDB 4.1945683e-05
12,302 A Framework for Testing Query Transformation Rules 2009 SIGMOD 4.1945683e-05
12,403 When is it Time to Rethink the Aggregate Configuration of Your OLAP Server? 2008 VLDB 4.1945683e-05
12,422 The Data Ring: Community Content Sharing 2007 CIDR 4.1945683e-05
12,450 Online AutoAdmin (Physical Design Tuning) 2007 SIGMOD 4.1945683e-05
12,474 Deadline and QoS Aware Data Warehouse 2007 VLDB 4.1945683e-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
158 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00040071492
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
516 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00021196031
1,059 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00014382575
1,443 Compressing SQL Workloads 2002 SIGMOD 0.00011947004
1,710 Microsoft Index Tuning Wizard for SQL Server 7.0 1998 SIGMOD 0.00010807871
1,857 An Overview of DB2 Parallel Edition 1995 SIGMOD 0.00010304962
2,045 Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 2003 SIGMOD 9.6939983e-05
2,518 The Value of Merge-Join and Hash-Join in SQL Server 1999 VLDB 8.6089125e-05
7,603 Automated design of multidimensional clustering tables for relational databases 2004 VLDB 4.6985903e-05
12,653 SMART: Making DB2 (More) Autonomic 2002 VLDB 4.1945683e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
661 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00018481174
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
12,373 An XML Index Advisor for DB2 2008 SIGMOD 4.1945683e-05
1,017 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014634307
2,045 Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 2003 SIGMOD 9.6939983e-05
7,445 An Automated, Yet Interactive and Portable DB Designer 2010 SIGMOD 4.7278675e-05
5,815 StatAdvisor: Recommending Statistical Views 2009 VLDB 5.3165295e-05
5,060 Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications 2009 VLDB 5.7273583e-05
7,603 Automated design of multidimensional clustering tables for relational databases 2004 VLDB 4.6985903e-05