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,821 | Declarative Management in Microsoft SQL Server | 2009 | VLDB | 4.9793485e-05 |
| 13,136 | SMART: Making DB2 (More) Autonomic | 2002 | VLDB | 4.9793485e-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.0023947656 |
| 88 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB | 0.00035351639 |
| 191 | Data Placement In Bubba | 1988 | SIGMOD | 0.00025700375 |
| 321 | Measuring the Complexity of Join Enumeration in Query Optimization | 1990 | VLDB | 0.00021088704 |
| 725 | Left-Deep Vs. Bushy Trees: An Analysis Of Strategy Spaces And Its Implications For Query Optimization | 1991 | SIGMOD | 0.00014465736 |
| 1,002 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB | 0.00012598875 |
| 1,273 | Database Partitioning in a Cluster of Processors | 1983 | VLDB | 0.00011247988 |
| 1,905 | Microsoft Index Tuning Wizard for SQL Server 7.0 | 1998 | SIGMOD | 9.3983929e-05 |
| 4,841 | Analysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems | 1993 | VLDB | 6.3854243e-05 |
| 5,094 | A Decomposition-Based Simulated Annealing Technique for Data Clustering | 1994 | PODS | 6.2775013e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 3,041 | Configuration-Parametric Query Optimization for Physical Design Tuning | 2008 | SIGMOD |
| 2 | 7,706 | Query Centric Partitioning and Allocation for Partially Replicated Database Systems | 2017 | SIGMOD |
| 3 | 3,143 | Query Optimization Techniques for Partitioned Tables | 2011 | SIGMOD |
| 4 | 7,967 | Resource Bricolage for Parallel Database Systems | 2015 | VLDB |
| 5 | 195 | Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design | 2004 | SIGMOD |
| 6 | 3,775 | Parallelizing Query Optimization | 2008 | VLDB |
| 7 | 472 | Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems | 2012 | SIGMOD |
| 8 | 9,621 | Parallelizing Query Optimization on Shared-Nothing Architectures | 2016 | VLDB |
| 9 | 3,239 | Locality-aware Partitioning in Parallel Database Systems | 2015 | SIGMOD |
| 10 | 1,883 | Automated Partitioning Design in Parallel Database Systems | 2011 | SIGMOD |