MOCHA: A Tool for Visualizing Impact of Operator Choices in Query Execution Plans for Database Education
Summary: MOCHA helps database learners explore how physical-operator preferences alter SQL query execution plans. It compares and visualizes alternative QEPs while explaining key operator choices through connections to established database literature. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Jess Tan (Nanyang Technological University)
- 2. Desmond Yeo (Nanyang Technological University)
- 3. Rachael Neoh (Nanyang Technological University)
- 4. Huey-Eng Chua (Nanyang Technological University)
- 5. Sourav S Bhowmick (Nanyang Technological University)
BibTeX Citation
@article{tan_vldb22,
title = {{MOCHA: A Tool for Visualizing Impact of Operator Choices in Query Execution Plans for Database Education}},
author = {Tan, Jess and Yeo, Desmond and Neoh, Rachael and Chua, Huey-Eng and Bhowmick, Sourav S},
journal = {PVLDB},
series = {{VLDB} '22},
volume = {15},
number = {12},
pages = {3602--3605},
doi = {10.14778/3554821.3554854},
url = {https://doi.org/10.14778/3554821.3554854},
year = {2022}
}Incoming Citations (Sorted by Pagerank)
Showing 5 of 5 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 8,305 | PARQO: Penalty-Aware Robust Plan Selection in Query Optimization | 2024 | VLDB | 5.4568571e-05 |
| 9,846 | QO-Insight: Inspecting Steered Query Optimizers | 2023 | VLDB | 5.2094004e-05 |
| 10,301 | Towards Selecting Informative Alternative Relational Query Plans for Database Education | 2026 | SIGMOD | 5.093636e-05 |
| 10,834 | QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach | 2025 | VLDB | 5.093636e-05 |
| 11,035 | Hint-QPT: Hints for Robust Query Performance Tuning | 2025 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 6 of 6 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 865 | Natural language to SQL: Where are we today? | 2020 | VLDB | 0.00013521464 |
| 1,604 | The Picasso Database Query Optimizer Visualizer | 2010 | VLDB | 0.00010230973 |
| 6,056 | QE3D: Interactive Visualization and Exploration of Complex, Distributed Query Plans | 2015 | SIGMOD | 5.9925637e-05 |
| 6,504 | What Makes a Good Physical Plan? — Experiencing Hardware-Conscious Query Optimization with Candomble | 2016 | SIGMOD | 5.8585206e-05 |
| 9,112 | Towards Enhancing Database Education: Natural Language Generation Meets Query Execution Plans | 2021 | SIGMOD | 5.3218986e-05 |
| 11,547 | LANTERN: Boredom-conscious Natural Language Description Generation of Query Execution Plans for Database Education | 2022 | SIGMOD | 5.093636e-05 |
Previous
Page 1 / 1
Next