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.49965e-05
Overall Rank
4,617 | 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,353 Why Not Yet: Fixing a Top-k Ranking that Is Not Fair to Individuals 2023 VLDB 6.1637765e-05
7,952 The Power of Constraints in Natural Language to SQL Translation 2025 VLDB 5.4198293e-05
8,272 NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews 2021 VLDB 5.3643259e-05
8,565 On The Reasonable Effectiveness of Relational Diagrams: Explaining Relational Query Patterns and the Pattern Expressiveness of Relational Languages 2024 SIGMOD 5.3137413e-05
8,972 Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries 2024 SIGMOD 5.2458797e-05
9,362 Exploring Exploratory Querying 2025 VLDB 5.1868213e-05
10,354 Database Research needs an Abstract Relational Query Language 2026 CIDR 4.9793485e-05
10,513 Towards Selecting Informative Alternative Relational Query Plans for Database Education 2026 SIGMOD 4.9793485e-05
10,611 A Principled Solution to the Disjunction Problem of Diagrammatic Query Representations 2026 SIGMOD 4.9793485e-05
10,843 I-Rex: An Interactive Debugger for SQL 2026 VLDB 4.9793485e-05
11,208 LICS: Towards Theory-Informed Effective Visual Abstraction of Property Graph Schemas 2025 SIGMOD 4.9793485e-05
11,242 QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach 2025 VLDB 4.9793485e-05
11,713 Theories and Principles Matter: Towards Visually Appealing and Effective Abstraction of Property Graph Queries 2023 SIGMOD 4.9793485e-05
11,781 A Tutorial on Visual Representations of Relational Queries 2023 VLDB 4.9793485e-05
13,635 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.00022504729
319 Making Database Systems Usable 2007 SIGMOD 0.00021164857
1,164 A Case for A Collaborative Query Management System 2009 CIDR 0.00011745383
2,116 Generating Example Data for Dataflow Programs 2009 SIGMOD 9.0149557e-05
2,883 SQL QueRIE Recommendations 2010 VLDB 7.9108916e-05
4,328 Playful Query Specification with DataPlay 2012 VLDB 6.6614241e-05
6,387 DBMSs Should Talk Back Too 2009 CIDR 5.8038743e-05
6,980 DBease: Making Databases User-friendly and Easily Accessible 2011 CIDR 5.6288191e-05
8,343 Databases will Visualize Queries too 2011 VLDB 5.3513352e-05
Previous Page 1 / 1 Next

Semantically Similar Papers