QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster

Summary: QueryVis encodes SQL semantics in logic-based diagrams for nested queries, yielding minimal, unambiguous visuals. A 42-participant MTurk study shows faster interpretation and fewer errors with diagrams than with SQL after a brief tutorial. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 5982
Venue: SIGMOD
Year: 2020
Pagerank: 5.4999397e-05
Overall Rank: 5,452 | 62.08%
DOI: 10.1145/3318464.3389767

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
5,826	Why Not Yet: Fixing a Top-k Ranking that Is Not Fair to Individuals	2023	VLDB	5.3124507e-05
8,174	NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews	2021	VLDB	4.568186e-05
8,404	On The Reasonable Effectiveness of Relational Diagrams: Explaining Relational Query Patterns and the Pattern Expressiveness of Relational Languages	2024	SIGMOD	4.5224126e-05
9,151	The Power of Constraints in Natural Language to SQL Translation	2025	VLDB	4.3849295e-05
9,623	Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries	2024	SIGMOD	4.3161663e-05
9,986	Database Research needs an Abstract Relational Query Language	2026	CIDR	4.1945683e-05
10,133	A Principled Solution to the Disjunction Problem of Diagrammatic Query Representations	2026	SIGMOD	4.1945683e-05
10,520	LICS: Towards Theory-Informed Effective Visual Abstraction of Property Graph Schemas	2025	SIGMOD	4.1945683e-05
10,568	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	4.1945683e-05
10,860	Exploring Exploratory Querying	2025	VLDB	4.1945683e-05
11,196	Theories and Principles Matter: Towards Visually Appealing and Effective Abstraction of Property Graph Queries	2023	SIGMOD	4.1945683e-05
11,271	A Tutorial on Visual Representations of Relational Queries	2023	VLDB	4.1945683e-05
13,108	PatternVis: A Tool for Relational Pattern Visualization	2025	SIGMOD	-

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
257	Making Database Systems Usable	2007	SIGMOD	0.00030223397
307	Extensible Query Processing in Starburst	1989	SIGMOD	0.00028211308
711	A Case for A Collaborative Query Management System	2009	CIDR	0.00017751589
2,035	Generating Example Data for Dataflow Programs	2009	SIGMOD	9.7149269e-05
3,093	SQL QueRIE Recommendations	2010	VLDB	7.5782293e-05
4,599	Playful Query Specification with DataPlay	2012	VLDB	6.0583418e-05
6,371	DBMSs Should Talk Back Too	2009	CIDR	5.0930594e-05
6,855	DBease: Making Databases User-friendly and Easily Accessible	2011	CIDR	4.9062505e-05
8,111	Databases will Visualize Queries too*	2011	VLDB	4.5842786e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
5,473	Facilitating SQL Query Composition and Analysis	2020	SIGMOD	5.4885366e-05
5,264	SeeDB: Visualizing Database Queries Efficiently	2014	VLDB	5.597302e-05
4,315	Towards a Unified Visual Database Access	1993	SIGMOD	6.2885419e-05
10,568	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	4.1945683e-05
4,365	Expressive Query Construction through Direct Manipulation of Nested Relational Results	2016	SIGMOD	6.2542811e-05
8,404	On The Reasonable Effectiveness of Relational Diagrams: Explaining Relational Query Patterns and the Pattern Expressiveness of Relational Languages	2024	SIGMOD	4.5224126e-05
11,271	A Tutorial on Visual Representations of Relational Queries	2023	VLDB	4.1945683e-05
7,010	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	4.8634875e-05
13,108	PatternVis: A Tool for Relational Pattern Visualization	2025	SIGMOD	-
8,111	Databases will Visualize Queries too*	2011	VLDB	4.5842786e-05