Query Optimization Techniques for Partitioned Tables
Summary: Proposes partition-aware optimization for multiway joins over partitioned tables, addressing gaps where traditional optimizers fail to exploit partitioning. Prototype in PostgreSQL shows low optimization overhead and orders-of-magnitude plan improvements over current optimizers. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Herodotos Herodotou (Duke University)
- 2. Nedyalko Borisov (Duke University)
- 3. Shivnath Babu (Duke University)
BibTeX Citation
@inproceedings{herodotou_sigmod11,
title = {{Query Optimization Techniques for Partitioned Tables}},
author = {Herodotou, Herodotos and Borisov, Nedyalko and Babu, Shivnath},
series = {{SIGMOD} '11},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/1989323.1989330},
url = {https://dl.acm.org/doi/10.1145/1989323.1989330},
year = {2011}
}Incoming Citations (Sorted by Pagerank)
Showing 10 of 10 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,239 | Locality-aware Partitioning in Parallel Database Systems | 2015 | SIGMOD | 7.5007569e-05 |
| 6,999 | Statisticum: Data Statistics Management in SAP HANA | 2017 | VLDB | 5.6252486e-05 |
| 7,200 | Optimizing Queries over Partitioned Tables in MPP Systems | 2014 | SIGMOD | 5.5872813e-05 |
| 8,202 | Grep: A Graph Learning Based Database Partitioning System | 2023 | SIGMOD | 5.378708e-05 |
| 9,154 | High Performance Stream Query Processing With Correlation-Aware Partitioning | 2014 | VLDB | 5.2176811e-05 |
| 9,236 | DoppelGanger++: Towards Fast Dependency Graph Generation for Database Replay | 2024 | SIGMOD | 5.2056825e-05 |
| 9,331 | Hybrid Row-Column Partitioning in Teradata | 2016 | VLDB | 5.1922811e-05 |
| 9,432 | Data Stream Warehousing in Tidalrace | 2015 | CIDR | 5.1782278e-05 |
| 10,768 | One Join Order Does Not Fit All: Reducing Intermediate Results with Per-Split Query Plans | 2026 | VLDB | 4.9793485e-05 |
| 12,225 | Joins over UNION ALL Queries in Teradata®: Demonstration of Optimized Execution | 2018 | SIGMOD | 4.9793485e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 9 of 9 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 |
| 18 | MAGIC SETS AND OTHER STRANGE WAYS TO IMPLEMENT LOGIC PROGRAMS (Extended Abstract) | 1986 | PODS | 0.00059023577 |
| 120 | HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads | 2009 | VLDB | 0.000311132 |
| 195 | Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design | 2004 | SIGMOD | 0.00025628849 |
| 243 | Automating Physical Database Design in a Parallel Database | 2002 | SIGMOD | 0.00023358891 |
| 1,119 | Query Optimization by Predicate Move-Around | 1994 | VLDB | 0.00011950395 |
| 1,285 | SQL/MapReduce: A practical approach to self-describing, polymorphic, and parallelizable user-defined functions | 2009 | VLDB | 0.00011201377 |
| 3,792 | Exploiting Advanced Database Optimization Features for Large-Scale SAP R/3 Installations | 2002 | VLDB | 7.0178771e-05 |
| 4,106 | Content-Based Routing: Different Plans for Different Data | 2005 | VLDB | 6.8032891e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,583 | Coloring Away Communication in Parallel Query Optimization | 1995 | VLDB |
| 2 | 3,239 | Locality-aware Partitioning in Parallel Database Systems | 2015 | SIGMOD |
| 3 | 9,621 | Parallelizing Query Optimization on Shared-Nothing Architectures | 2016 | VLDB |
| 4 | 5,425 | Efficient Massively Parallel Join Optimization for Large Queries* | 2022 | SIGMOD |
| 5 | 243 | Automating Physical Database Design in a Parallel Database | 2002 | SIGMOD |
| 6 | 1,883 | Automated Partitioning Design in Parallel Database Systems | 2011 | SIGMOD |
| 7 | 2,136 | Optimization of Multi-Way Join Queries for Parallel Execution | 1991 | VLDB |
| 8 | 3,775 | Parallelizing Query Optimization | 2008 | VLDB |
| 9 | 8,164 | Efficient Query Re-optimization with Judicious Subquery Selections | 2023 | SIGMOD |
| 10 | 7,200 | Optimizing Queries over Partitioned Tables in MPP Systems | 2014 | SIGMOD |