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 9 of 9 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,200 | Locality-aware Partitioning in Parallel Database Systems | 2015 | SIGMOD | 7.642132e-05 |
| 6,907 | Statisticum: Data Statistics Management in SAP HANA | 2017 | VLDB | 5.7417459e-05 |
| 7,090 | Optimizing Queries over Partitioned Tables in MPP Systems | 2014 | SIGMOD | 5.706401e-05 |
| 8,042 | Grep: A Graph Learning Based Database Partitioning System | 2023 | SIGMOD | 5.5015896e-05 |
| 8,996 | High Performance Stream Query Processing With Correlation-Aware Partitioning | 2014 | VLDB | 5.3357805e-05 |
| 9,056 | DoppelGanger++: Towards Fast Dependency Graph Generation for Database Replay | 2024 | SIGMOD | 5.3251649e-05 |
| 9,159 | Hybrid Row-Column Partitioning in Teradata | 2016 | VLDB | 5.3114559e-05 |
| 9,258 | Data Stream Warehousing in Tidalrace | 2015 | CIDR | 5.29708e-05 |
| 11,926 | Joins over UNION ALL Queries in Teradata®: Demonstration of Optimized Execution | 2018 | SIGMOD | 5.093636e-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.0024089429 |
| 16 | MAGIC SETS AND OTHER STRANGE WAYS TO IMPLEMENT LOGIC PROGRAMS (Extended Abstract) | 1986 | PODS | 0.00060089598 |
| 120 | HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads | 2009 | VLDB | 0.00031680027 |
| 199 | Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design | 2004 | SIGMOD | 0.00025612088 |
| 246 | Automating Physical Database Design in a Parallel Database | 2002 | SIGMOD | 0.00023457421 |
| 1,124 | Query Optimization by Predicate Move-Around | 1994 | VLDB | 0.00012087356 |
| 1,264 | SQL/MapReduce: A practical approach to self-describing, polymorphic, and parallelizable user-defined functions | 2009 | VLDB | 0.00011416393 |
| 3,772 | Exploiting Advanced Database Optimization Features for Large-Scale SAP R/3 Installations | 2002 | VLDB | 7.1388374e-05 |
| 4,383 | Content-Based Routing: Different Plans for Different Data | 2005 | VLDB | 6.7329787e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,451 | Coloring Away Communication in Parallel Query Optimization | 1995 | VLDB |
| 2 | 3,200 | Locality-aware Partitioning in Parallel Database Systems | 2015 | SIGMOD |
| 3 | 9,446 | Parallelizing Query Optimization on Shared-Nothing Architectures | 2016 | VLDB |
| 4 | 5,399 | Efficient Massively Parallel Join Optimization for Large Queries* | 2022 | SIGMOD |
| 5 | 246 | Automating Physical Database Design in a Parallel Database | 2002 | SIGMOD |
| 6 | 1,852 | Automated Partitioning Design in Parallel Database Systems | 2011 | SIGMOD |
| 7 | 2,104 | Optimization of Multi-Way Join Queries for Parallel Execution | 1991 | VLDB |
| 8 | 3,726 | Parallelizing Query Optimization | 2008 | VLDB |
| 9 | 9,756 | Efficient Query Re-optimization with Judicious Subquery Selections | 2023 | SIGMOD |
| 10 | 7,090 | Optimizing Queries over Partitioned Tables in MPP Systems | 2014 | SIGMOD |