Optimization of Common Table Expressions in MPP Database Systems
Summary: CTEs in MPP DBs: representation, optimization, and execution framework in Orca, Pivotal's Big Data optimizer. Experimental validation on industry-standard decision-support benchmarks demonstrates scalable performance gains for complex analytical workloads. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,245 | Iterative Query Processing based on Unified Optimization Techniques | 2019 | SIGMOD | 5.1391202e-05 |
| 11,339 | Redundancy Elimination in Distributed Matrix Computation | 2022 | SIGMOD | 4.1945683e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 7 of 7 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 731 | Optimizing Queries Using Materialized Views: A Practical, Scalable Solution | 2001 | SIGMOD | 0.00017468889 |
| 1,476 | Efficient Exploitation of Similar Subexpressions for Query Processing | 2007 | SIGMOD | 0.00011779092 |
| 2,241 | Query Optimization in Microsoft SQL Server PDW | 2012 | SIGMOD | 9.2191212e-05 |
| 2,249 | Orca: A Modular Query Optimizer Architecture for Big Data | 2014 | SIGMOD | 9.2034693e-05 |
| 2,504 | Enhanced Subquery Optimizations in Oracle | 2009 | VLDB | 8.6351917e-05 |
| 3,066 | HAWQ: A Massively Parallel Processing SQL Engine in Hadoop | 2014 | SIGMOD | 7.6221974e-05 |
| 7,098 | Optimizing Queries over Partitioned Tables in MPP Systems | 2014 | SIGMOD | 4.833012e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,374 | Optimization of Conjunctive Predicates for Main Memory Column Stores | 2016 | VLDB | 5.0927058e-05 |
| 9,305 | Parallelizing Query Optimization on Shared-Nothing Architectures | 2016 | VLDB | 4.3577129e-05 |
| 829 | Simultaneous Optimization and Evaluation of Multiple Dimensional Queries | 1998 | SIGMOD | 0.0001618536 |
| 438 | Query Optimization for Parallel Execution | 1992 | SIGMOD | 0.00023199245 |
| 1,476 | Efficient Exploitation of Similar Subexpressions for Query Processing | 2007 | SIGMOD | 0.00011779092 |
| 2,249 | Orca: A Modular Query Optimizer Architecture for Big Data | 2014 | SIGMOD | 9.2034693e-05 |
| 2,241 | Query Optimization in Microsoft SQL Server PDW | 2012 | SIGMOD | 9.2191212e-05 |
| 1,939 | From Theory to Practice: Efficient Join Query Evaluation in a Parallel Database System | 2015 | SIGMOD | 0.00010025655 |
| 5,014 | Dynamically Optimizing Queries over Large Scale Data Platforms | 2014 | SIGMOD | 5.7586174e-05 |
| 7,098 | Optimizing Queries over Partitioned Tables in MPP Systems | 2014 | SIGMOD | 4.833012e-05 |