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.1341887e-05 |
| 11,341 | Redundancy Elimination in Distributed Matrix Computation | 2022 | SIGMOD | 4.1905499e-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 |
|---|---|---|---|---|
| 728 | Optimizing Queries Using Materialized Views: A Practical, Scalable Solution | 2001 | SIGMOD | 0.00017459654 |
| 1,475 | Efficient Exploitation of Similar Subexpressions for Query Processing | 2007 | SIGMOD | 0.00011765071 |
| 2,244 | Query Optimization in Microsoft SQL Server PDW | 2012 | SIGMOD | 9.2095696e-05 |
| 2,247 | Orca: A Modular Query Optimizer Architecture for Big Data | 2014 | SIGMOD | 9.201975e-05 |
| 2,503 | Enhanced Subquery Optimizations in Oracle | 2009 | VLDB | 8.6306662e-05 |
| 3,070 | HAWQ: A Massively Parallel Processing SQL Engine in Hadoop | 2014 | SIGMOD | 7.6157391e-05 |
| 7,096 | Optimizing Queries over Partitioned Tables in MPP Systems | 2014 | SIGMOD | 4.8283743e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 9,312 | Parallelizing Query Optimization on Shared-Nothing Architectures | 2016 | VLDB | 4.353536e-05 |
| 6,372 | Optimization of Conjunctive Predicates for Main Memory Column Stores | 2016 | VLDB | 5.0878306e-05 |
| 825 | Simultaneous Optimization and Evaluation of Multiple Dimensional Queries | 1998 | SIGMOD | 0.00016171735 |
| 439 | Query Optimization for Parallel Execution | 1992 | SIGMOD | 0.00023183237 |
| 1,475 | Efficient Exploitation of Similar Subexpressions for Query Processing | 2007 | SIGMOD | 0.00011765071 |
| 2,247 | Orca: A Modular Query Optimizer Architecture for Big Data | 2014 | SIGMOD | 9.201975e-05 |
| 2,244 | Query Optimization in Microsoft SQL Server PDW | 2012 | SIGMOD | 9.2095696e-05 |
| 1,938 | From Theory to Practice: Efficient Join Query Evaluation in a Parallel Database System | 2015 | SIGMOD | 0.00010025547 |
| 5,012 | Dynamically Optimizing Queries over Large Scale Data Platforms | 2014 | SIGMOD | 5.7543101e-05 |
| 7,096 | Optimizing Queries over Partitioned Tables in MPP Systems | 2014 | SIGMOD | 4.8283743e-05 |