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: 12842
Venue: VLDB
Year: 2022
Pagerank: 6.1466842e-05
Overall Rank: 5,792 | 59.75%
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,182	PARQO: Penalty-Aware Robust Plan Selection in Query Optimization	2024	VLDB	5.5385661e-05
9,697	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	5.2900821e-05
10,577	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	5.1725247e-05
10,813	Hint-QPT: Hints for Robust Query Performance Tuning	2025	VLDB	5.1725247e-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
854	Natural language to SQL: Where are we today?	2020	VLDB	0.00013640405
1,646	The Picasso Database Query Optimizer Visualizer	2010	VLDB	0.00010197566
6,412	What Makes a Good Physical Plan? — Experiencing Hardware-Conscious Query Optimization with Candomble	2016	SIGMOD	5.9492525e-05
6,413	QE3D: Interactive Visualization and Exploration of Complex, Distributed Query Plans	2015	SIGMOD	5.9492525e-05
9,014	Towards Enhancing Database Education: Natural Language Generation Meets Query Execution Plans	2021	SIGMOD	5.3961719e-05
11,351	LANTERN: Boredom-conscious Natural Language Description Generation of Query Execution Plans for Database Education	2022	SIGMOD	5.1725247e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
12,299	Visualizing the robustness of query execution	2009	CIDR	5.1725247e-05
11,351	LANTERN: Boredom-conscious Natural Language Description Generation of Query Execution Plans for Database Education	2022	SIGMOD	5.1725247e-05
6,978	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	5.7929067e-05
4,932	QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster	2020	SIGMOD	6.50349e-05
10,577	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	5.1725247e-05
9,697	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	5.2900821e-05
11,665	NEURON: Query Execution Plan Meets Natural Language Processing For Augmenting DB Education	2019	SIGMOD	5.1725247e-05
9,014	Towards Enhancing Database Education: Natural Language Generation Meets Query Execution Plans	2021	SIGMOD	5.3961719e-05
9,187	MOCHA: A Self-Extensible Database Middleware System for Distributed Data Sources	2000	SIGMOD	5.3714647e-05
13,905	MOCHA: A Database Middleware System Featuring Automatic Deployment of Application-Specific Functionality	2000	SIGMOD	-