DBScholar

Back to papers

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
he173bc80f227086f
Venue
SIGMOD
Year
2020
Pagerank
6.4965731e-05
Overall Rank
4,619 | 68.96%
DOI
10.1145/3318464.3389767

Incoming Non-self Citations Over Time

Authors

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 15 of 15 citing papers.

Rank Citing Paper Year Venue Pagerank
5,359 Why Not Yet: Fixing a Top-k Ranking that Is Not Fair to Individuals 2023 VLDB 6.1608586e-05
7,956 The Power of Constraints in Natural Language to SQL Translation 2025 VLDB 5.4172636e-05
8,279 NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews 2021 VLDB 5.3617864e-05
8,572 On The Reasonable Effectiveness of Relational Diagrams: Explaining Relational Query Patterns and the Pattern Expressiveness of Relational Languages 2024 SIGMOD 5.3112258e-05
8,981 Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries 2024 SIGMOD 5.2433963e-05
9,371 Exploring Exploratory Querying 2025 VLDB 5.1843659e-05
10,366 Database Research needs an Abstract Relational Query Language 2026 CIDR 4.9769913e-05
10,524 Towards Selecting Informative Alternative Relational Query Plans for Database Education 2026 SIGMOD 4.9769913e-05
10,622 A Principled Solution to the Disjunction Problem of Diagrammatic Query Representations 2026 SIGMOD 4.9769913e-05
10,853 I-Rex: An Interactive Debugger for SQL 2026 VLDB 4.9769913e-05
11,217 LICS: Towards Theory-Informed Effective Visual Abstraction of Property Graph Schemas 2025 SIGMOD 4.9769913e-05
11,250 QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach 2025 VLDB 4.9769913e-05
11,719 Theories and Principles Matter: Towards Visually Appealing and Effective Abstraction of Property Graph Queries 2023 SIGMOD 4.9769913e-05
11,787 A Tutorial on Visual Representations of Relational Queries 2023 VLDB 4.9769913e-05
13,641 PatternVis: A Tool for Relational Pattern Visualization 2025 SIGMOD -
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
273 Extensible Query Processing in Starburst 1989 SIGMOD 0.00022498382
319 Making Database Systems Usable 2007 SIGMOD 0.00021155013
1,164 A Case for A Collaborative Query Management System 2009 CIDR 0.0001174008
2,118 Generating Example Data for Dataflow Programs 2009 SIGMOD 9.0107134e-05
2,884 SQL QueRIE Recommendations 2010 VLDB 7.9073001e-05
4,328 Playful Query Specification with DataPlay 2012 VLDB 6.6582731e-05
6,390 DBMSs Should Talk Back Too 2009 CIDR 5.8011268e-05
6,983 DBease: Making Databases User-friendly and Easily Accessible 2011 CIDR 5.6261545e-05
8,346 Databases will Visualize Queries too 2011 VLDB 5.3488022e-05
Previous Page 1 / 1 Next

Semantically Similar Papers