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
9128
Venue
VLDB
Year
2004
Pagerank
0.00030196528
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,268 Divergent Physical Design Tuning for Replicated Databases 2012 SIGMOD 4.5408509e-05
8,378 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 4.5275731e-05
8,387 A Storage Advisor for Hybrid-Store Databases 2012 VLDB 4.5255213e-05
8,390 Goals and Benchmarks for Autonomic Configuration Recommenders 2005 SIGMOD 4.524666e-05
9,578 Kaizen: A Semi-Automatic Index Advisor 2012 SIGMOD 4.3195435e-05
9,804 Amoeba: A Shape changing Storage System for Big Data 2016 VLDB 4.2774538e-05
9,851 Adaptive Schema Databases 2017 CIDR 4.2680295e-05
9,904 Progressive Partitioning for Parallelized Query Execution in Google's Napa 2023 VLDB 4.2539423e-05
10,506 Physical Visualization Design: Decoupling Interface and System Design 2025 SIGMOD 4.1905499e-05
10,796 SQL:Trek Automated Index Design at Airbnb 2025 VLDB 4.1905499e-05
11,074 Index Advisors on Quantum Platforms 2024 VLDB 4.1905499e-05
11,418 Budget-Conscious Fine-Grained Configuration Optimization for Spatio-Temporal Applications 2022 VLDB 4.1905499e-05
12,145 Building User-defined Runtime Adaptation Routines for Stream Processing Applications 2012 VLDB 4.1905499e-05
12,310 A Framework for Testing Query Transformation Rules 2009 SIGMOD 4.1905499e-05
12,412 When is it Time to Rethink the Aggregate Configuration of Your OLAP Server? 2008 VLDB 4.1905499e-05
12,431 The Data Ring: Community Content Sharing 2007 CIDR 4.1905499e-05
12,459 Online AutoAdmin (Physical Design Tuning) 2007 SIGMOD 4.1905499e-05
12,483 Deadline and QoS Aware Data Warehouse 2007 VLDB 4.1905499e-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
160 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00040053897
283 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00029024583
285 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00028978423
517 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00021193179
1,059 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00014370009
1,443 Compressing SQL Workloads 2002 SIGMOD 0.00011944621
1,709 Microsoft Index Tuning Wizard for SQL Server 7.0 1998 SIGMOD 0.00010799651
1,860 An Overview of DB2 Parallel Edition 1995 SIGMOD 0.00010300482
2,092 Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 2003 SIGMOD 9.5635999e-05
2,521 The Value of Merge-Join and Hash-Join in SQL Server 1999 VLDB 8.6038917e-05
7,591 Automated design of multidimensional clustering tables for relational databases 2004 VLDB 4.6986414e-05
12,662 SMART: Making DB2 (More) Autonomic 2002 VLDB 4.1905499e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
662 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00018478597
2,788 To Tune or not to Tune? A Lightweight Physical Design Alerter 2006 VLDB 8.121027e-05
1,007 A Framework for Automating Physical Database Design 1991 VLDB 0.00014683533
12,381 An XML Index Advisor for DB2 2008 SIGMOD 4.1905499e-05
1,018 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014626746
2,092 Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 2003 SIGMOD 9.5635999e-05
7,445 An Automated, Yet Interactive and Portable DB Designer 2010 SIGMOD 4.7235588e-05
5,824 StatAdvisor: Recommending Statistical Views 2009 VLDB 5.311975e-05
5,055 Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications 2009 VLDB 5.72317e-05
7,591 Automated design of multidimensional clustering tables for relational databases 2004 VLDB 4.6986414e-05