Automating Physical Database Design in a Parallel Database
Summary: Automates partitioning of data in a shared-nothing parallel DB using workload-driven optimization. Integrates with the optimizer to propose and evaluate partition candidates; rank-based search outperforms random in a commercial shared-nothing system. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Jun Rao (IBM)
- 2. Chun Zhang (University of Wisconsin)
- 3. Guy Lohman (IBM)
- 4. Nimrod Megiddo (IBM)
BibTeX Citation
@inproceedings{rao_sigmod02,
title = {{Automating Physical Database Design in a Parallel Database}},
author = {Rao, Jun and Zhang, Chun and Lohman, Guy and Megiddo, Nimrod},
series = {{SIGMOD} '02},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/564691.564757},
url = {https://dl.acm.org/doi/10.1145/564691.564757},
year = {2002}
}Incoming Citations (Sorted by Pagerank)
Showing 2 of 52 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 12,870 | Declarative Management in Microsoft SQL Server | 2009 | VLDB | 4.9605343e-05 |
| 13,183 | SMART: Making DB2 (More) Autonomic | 2002 | VLDB | 4.9605343e-05 |
Outgoing Citations (Sorted by Pagerank)
Showing 10 of 10 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1 | Access Path Selection in a Relational Database Management System | 1979 | SIGMOD | 0.0023948467 |
| 89 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB | 0.00035265687 |
| 194 | Data Placement In Bubba | 1988 | SIGMOD | 0.00025627096 |
| 322 | Measuring the Complexity of Join Enumeration in Query Optimization | 1990 | VLDB | 0.00021032289 |
| 728 | Left-Deep Vs. Bushy Trees: An Analysis Of Strategy Spaces And Its Implications For Query Optimization | 1991 | SIGMOD | 0.0001441771 |
| 1,003 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB | 0.00012558273 |
| 1,277 | Database Partitioning in a Cluster of Processors | 1983 | VLDB | 0.00011210172 |
| 1,916 | Microsoft Index Tuning Wizard for SQL Server 7.0 | 1998 | SIGMOD | 9.3655818e-05 |
| 4,864 | Analysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems | 1993 | VLDB | 6.3625965e-05 |
| 5,118 | A Decomposition-Based Simulated Annealing Technique for Data Clustering | 1994 | PODS | 6.2548449e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 3,050 | Configuration-Parametric Query Optimization for Physical Design Tuning | 2008 | SIGMOD |
| 2 | 3,156 | Query Optimization Techniques for Partitioned Tables | 2011 | SIGMOD |
| 3 | 7,725 | Query Centric Partitioning and Allocation for Partially Replicated Database Systems | 2017 | SIGMOD |
| 4 | 7,987 | Resource Bricolage for Parallel Database Systems | 2015 | VLDB |
| 5 | 196 | Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design | 2004 | SIGMOD |
| 6 | 3,785 | Parallelizing Query Optimization | 2008 | VLDB |
| 7 | 474 | Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems | 2012 | SIGMOD |
| 8 | 9,656 | Parallelizing Query Optimization on Shared-Nothing Architectures | 2016 | VLDB |
| 9 | 3,258 | Locality-aware Partitioning in Parallel Database Systems | 2015 | SIGMOD |
| 10 | 1,892 | Automated Partitioning Design in Parallel Database Systems | 2011 | SIGMOD |