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
6044
Venue
SIGMOD
Year
2020
Pagerank
6.5444379e-05
Overall Rank
4,721 | 67.62%
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 14 of 14 citing papers.

Rank Citing Paper Year Venue Pagerank
5,278 Why Not Yet: Fixing a Top-k Ranking that Is Not Fair to Individuals 2023 VLDB 6.2856584e-05
8,407 On The Reasonable Effectiveness of Relational Diagrams: Explaining Relational Query Patterns and the Pattern Expressiveness of Relational Languages 2024 SIGMOD 5.4312823e-05
8,511 NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews 2021 VLDB 5.4119882e-05
8,834 Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries 2024 SIGMOD 5.3599176e-05
9,305 The Power of Constraints in Natural Language to SQL Translation 2025 VLDB 5.289545e-05
10,133 Database Research needs an Abstract Relational Query Language 2026 CIDR 5.093636e-05
10,301 Towards Selecting Informative Alternative Relational Query Plans for Database Education 2026 SIGMOD 5.093636e-05
10,422 A Principled Solution to the Disjunction Problem of Diagrammatic Query Representations 2026 SIGMOD 5.093636e-05
10,793 LICS: Towards Theory-Informed Effective Visual Abstraction of Property Graph Schemas 2025 SIGMOD 5.093636e-05
10,834 QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach 2025 VLDB 5.093636e-05
11,084 Exploring Exploratory Querying 2025 VLDB 5.093636e-05
11,398 Theories and Principles Matter: Towards Visually Appealing and Effective Abstraction of Property Graph Queries 2023 SIGMOD 5.093636e-05
11,470 A Tutorial on Visual Representations of Relational Queries 2023 VLDB 5.093636e-05
13,313 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
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