MOCHA: A Tool for Visualizing Impact of Operator Choices in Query Execution Plans for Database Education

Summary: MOCHA visualizes how alternative physical operators affect a query execution plan. It takes an SQL query, generates alternative plans with learner-specified operator preferences, and explains choices by connecting to established literature. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 12841
Venue: VLDB
Year: 2022
Pagerank: 5.3298375e-05
Overall Rank: 5,780 | 59.80%
DOI: 10.14778/3554821.3554854

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,448	PARQO: Penalty-Aware Robust Plan Selection in Query Optimization	2024	VLDB	4.5100508e-05
9,710	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	4.299267e-05
10,568	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	4.1945683e-05
10,808	Hint-QPT: Hints for Robust Query Performance Tuning	2025	VLDB	4.1945683e-05

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
984	Natural language to SQL: Where are we today?	2020	VLDB	0.00014857465
1,300	The Picasso Database Query Optimizer Visualizer	2010	VLDB	0.00012733214
6,287	What Makes a Good Physical Plan? — Experiencing Hardware-Conscious Query Optimization with Candomble	2016	SIGMOD	5.127646e-05
6,288	QE3D: Interactive Visualization and Exploration of Complex, Distributed Query Plans	2015	SIGMOD	5.127646e-05
8,990	Towards Enhancing Database Education: Natural Language Generation Meets Query Execution Plans	2021	SIGMOD	4.413295e-05
11,349	LANTERN: Boredom-conscious Natural Language Description Generation of Query Execution Plans for Database Education	2022	SIGMOD	4.1945683e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
12,291	Visualizing the robustness of query execution	2009	CIDR	4.1945683e-05
11,349	LANTERN: Boredom-conscious Natural Language Description Generation of Query Execution Plans for Database Education	2022	SIGMOD	4.1945683e-05
7,010	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	4.8634875e-05
5,452	QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster	2020	SIGMOD	5.4999397e-05
9,710	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	4.299267e-05
10,568	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	4.1945683e-05
11,660	NEURON: Query Execution Plan Meets Natural Language Processing For Augmenting DB Education	2019	SIGMOD	4.1945683e-05
8,990	Towards Enhancing Database Education: Natural Language Generation Meets Query Execution Plans	2021	SIGMOD	4.413295e-05
9,180	MOCHA: A Self-Extensible Database Middleware System for Distributed Data Sources	2000	SIGMOD	4.3819656e-05
13,891	MOCHA: A Database Middleware System Featuring Automatic Deployment of Application-Specific Functionality	2000	SIGMOD	-