The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database
Summary: Presents MemSQL’s distribution-aware optimizer for sub-second, complex analytics on a scale-out engine. Jointly considers rewrites, join enumeration, and distributed costing, using rewrite-based bushy-join exploration to improve plans without sacrificing optimization speed. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Jack Chen (MemSQL)
- 2. Samir Jindel (MemSQL)
- 3. Robert Walzer (MemSQL)
- 4. Rajkumar Sen (MemSQL)
- 5. Nika Jimsheleishvilli (MemSQL)
- 6. Michael Andrews (MemSQL)
BibTeX Citation
@article{chen_vldb16,
title = {{The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database}},
author = {Chen, Jack and Jindel, Samir and Walzer, Robert and Sen, Rajkumar and Jimsheleishvilli, Nika and Andrews, Michael},
journal = {PVLDB},
series = {{VLDB} '16},
volume = {9},
number = {13},
pages = {1401--1412},
doi = {10.14778/3007263.3007272},
url = {https://doi.org/10.14778/3007263.3007272},
year = {2016}
}Incoming Citations (Sorted by Pagerank)
Showing 21 of 21 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 10 of 10 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 |
| 186 | The Vertica Analytic Database: C-Store 7 Years Later | 2012 | VLDB | 0.00026182534 |
| 316 | Measuring the Complexity of Join Enumeration in Query Optimization | 1990 | VLDB | 0.0002141607 |
| 476 | The Making of TPC-DS | 2006 | VLDB | 0.00017860667 |
| 698 | Optimization of Large Join Queries: Combining Heuristics and Combinatorial Techniques | 1989 | SIGMOD | 0.00014879675 |
| 1,621 | Orca: A Modular Query Optimizer Architecture for Big Data | 2014 | SIGMOD | 0.00010203114 |
| 2,078 | Query Optimization in Microsoft SQL Server PDW | 2012 | SIGMOD | 9.2078209e-05 |
| 3,726 | Parallelizing Query Optimization | 2008 | VLDB | 7.1697834e-05 |
| 4,091 | Of Snowstorms and Bushy Trees | 2014 | VLDB | 6.9090244e-05 |
| 6,026 | Parallelizing Extensible Query Optimizers | 2009 | SIGMOD | 6.0024042e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 3,726 | Parallelizing Query Optimization | 2008 | VLDB |
| 2 | 7,090 | Optimizing Queries over Partitioned Tables in MPP Systems | 2014 | SIGMOD |
| 3 | 10,296 | Succinct Structure Representations for Efficient Query Optimization | 2026 | SIGMOD |
| 4 | 6,026 | Parallelizing Extensible Query Optimizers | 2009 | SIGMOD |
| 5 | 7,585 | Query Centric Partitioning and Allocation for Partially Replicated Database Systems | 2017 | SIGMOD |
| 6 | 342 | R* Optimizer Validation and Performance Evaluation for Distributed Queries | 1986 | VLDB |
| 7 | 9,446 | Parallelizing Query Optimization on Shared-Nothing Architectures | 2016 | VLDB |
| 8 | 2,276 | Shared Workload Optimization | 2014 | VLDB |
| 9 | 4,639 | MQJoin: Efficient Shared Execution of Main-Memory Joins | 2016 | VLDB |
| 10 | 2,078 | Query Optimization in Microsoft SQL Server PDW | 2012 | SIGMOD |