Optimizing Queries over Partitioned Tables in MPP Systems
Summary: Unified representation for partitioned tables in MPP systems, enabling runtime deferred partition access decisions. Query plan optimization prunes irrelevant partitions on the fly, yielding substantial performance gains over conventional plans in Greenplum. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Lyublena Antova
- 2. Zhongxian Gu
- 3. Amr El-Helw
- 4. Michalis Petropoulos
- 5. Florian Waas
- 6. Mohamed A. Soliman
Incoming Citations (Sorted by Pagerank)
Showing 5 of 5 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 2,249 | Orca: A Modular Query Optimizer Architecture for Big Data | 2014 | SIGMOD | 9.2034693e-05 |
| 5,194 | Bitvector-aware Query Optimization for Decision Support Queries | 2020 | SIGMOD | 5.6368209e-05 |
| 5,876 | Membrane - Safe and Performant Data Access Controls in Apache Spark in the Presence of Imperative Code | 2024 | VLDB | 5.2922419e-05 |
| 8,483 | Optimization of Common Table Expressions in MPP Database Systems | 2015 | VLDB | 4.5008949e-05 |
| 9,008 | Hybrid Row-Column Partitioning in Teradata | 2016 | VLDB | 4.4100992e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 4 of 4 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 285 | Automating Physical Database Design in a Parallel Database | 2002 | SIGMOD | 0.0002899128 |
| 286 | Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design | 2004 | SIGMOD | 0.00028990057 |
| 2,249 | Orca: A Modular Query Optimizer Architecture for Big Data | 2014 | SIGMOD | 9.2034693e-05 |
| 3,214 | Query Optimization Techniques for Partitioned Tables | 2011 | SIGMOD | 7.3661891e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,154 | The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database | 2016 | VLDB | 7.4686089e-05 |
| 3,821 | Locality-aware Partitioning in Parallel Database Systems | 2015 | SIGMOD | 6.7281515e-05 |
| 4,261 | Parallelizing Query Optimization | 2008 | VLDB | 6.31244e-05 |
| 7,715 | Query Centric Partitioning and Allocation for Partially Replicated Database Systems | 2017 | SIGMOD | 4.6699261e-05 |
| 285 | Automating Physical Database Design in a Parallel Database | 2002 | SIGMOD | 0.0002899128 |
| 2,241 | Query Optimization in Microsoft SQL Server PDW | 2012 | SIGMOD | 9.2191212e-05 |
| 6,056 | Efficient Massively Parallel Join Optimization for Large Queries* | 2022 | SIGMOD | 5.2321475e-05 |
| 9,305 | Parallelizing Query Optimization on Shared-Nothing Architectures | 2016 | VLDB | 4.3577129e-05 |
| 2,413 | Automated Partitioning Design in Parallel Database Systems | 2011 | SIGMOD | 8.8672223e-05 |
| 3,214 | Query Optimization Techniques for Partitioned Tables | 2011 | SIGMOD | 7.3661891e-05 |