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)
Incoming Non-self Citations Over Time
Authors
- 1. Aristotelis Leventidis (Northeastern University)
- 2. Jiahui Zhang (Northeastern University)
- 3. Cody Dunne (Northeastern University)
- 4. Wolfgang Gatterbauer (Northeastern University)
- 5. H.V. Jagadish (University of Michigan)
- 6. Mirek Riedewald (Northeastern University)
BibTeX Citation
@inproceedings{leventidis_sigmod20,
title = {{QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster}},
author = {Leventidis, Aristotelis and Zhang, Jiahui and Dunne, Cody and Gatterbauer, Wolfgang and Jagadish, H.V. and Riedewald, Mirek},
series = {{SIGMOD} '20},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3318464.3389767},
url = {https://dl.acm.org/doi/10.1145/3318464.3389767},
year = {2020}
}
Incoming Citations (Sorted by Pagerank)
Showing 14 of 14 citing papers.
Previous
Page 1 / 1
Next
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 |
|---|---|---|---|---|
| 268 | Extensible Query Processing in Starburst | 1989 | SIGMOD | 0.00022788687 |
| 314 | Making Database Systems Usable | 2007 | SIGMOD | 0.00021574636 |
| 1,149 | A Case for A Collaborative Query Management System | 2009 | CIDR | 0.0001194728 |
| 2,077 | Generating Example Data for Dataflow Programs | 2009 | SIGMOD | 9.2085989e-05 |
| 2,905 | SQL QueRIE Recommendations | 2010 | VLDB | 7.9756156e-05 |
| 4,246 | Playful Query Specification with DataPlay | 2012 | VLDB | 6.8057675e-05 |
| 6,274 | DBMSs Should Talk Back Too | 2009 | CIDR | 5.9305465e-05 |
| 6,862 | DBease: Making Databases User-friendly and Easily Accessible | 2011 | CIDR | 5.7514733e-05 |
| 8,174 | Databases will Visualize Queries too | 2011 | VLDB | 5.4738201e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,132 | Facilitating SQL Query Composition and Analysis | 2020 | SIGMOD |
| 2 | 5,329 | SeeDB: Visualizing Database Queries Efficiently | 2014 | VLDB |
| 3 | 6,239 | Towards a Unified Visual Database Access | 1993 | SIGMOD |
| 4 | 10,834 | QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach | 2025 | VLDB |
| 5 | 4,046 | Expressive Query Construction through Direct Manipulation of Nested Relational Results | 2016 | SIGMOD |
| 6 | 8,407 | On The Reasonable Effectiveness of Relational Diagrams: Explaining Relational Query Patterns and the Pattern Expressiveness of Relational Languages | 2024 | SIGMOD |
| 7 | 11,470 | A Tutorial on Visual Representations of Relational Queries | 2023 | VLDB |
| 8 | 7,098 | QueryScope: Visualizing Queries for Repeatable Database Tuning | 2008 | VLDB |
| 9 | 13,313 | PatternVis: A Tool for Relational Pattern Visualization | 2025 | SIGMOD |
| 10 | 8,174 | Databases will Visualize Queries too | 2011 | VLDB |