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)
Incoming Non-self Citations Over Time
Authors
- 1. Daniel C. Zilio (IBM)
- 2. Jun Rao (IBM)
- 3. Sam Lightstone (IBM)
- 4. Guy Lohman (IBM)
- 5. Adam Storm (IBM)
- 6. Christian Garcia-Arellano (IBM)
- 7. Scott Fadden (IBM)
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.
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.
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 |