English (United Kingdom)

https://curated-unify.zendy.io/wp-json/zendy-region/v1/featured_content/oa?rat=en

https://curated-unify.zendy.io/wp-json/zendy-region/v1/highlighted_journal/

Global: Zendy Plus annual

Presents the access of premium content as premium feature

Premium Content

Presents the keyphrase highlighting as premium feature

Keyphrase Highlighting

Presents the summarisation as premium feature

Summarisation

Insights

Presents the pdf analysis as premium feature

PDF Analysis

Presents the zaia usage as premium feature

ZAIA

Global: Zendy Tools annual

Global: Zendy Free Plan

Global: Zendy Tools monthly

Global: Zendy Plus monthly

Understanding the meaning of existing SQL queries is critical for codemaintenance and reuse. Yet SQL can be hard to read, even for expert users orthe original creator of a query. We conjecture that it is possible to capturethe logical intent of queries in \emph{automatically-generated visual diagrams}that can help users understand the meaning of queries faster and moreaccurately than SQL text alone. We present initial steps in that direction withvisual diagrams that are based on the first-order logic foundation of SQL andcan capture the meaning of deeply nested queries. Our diagrams build upon arich history of diagrammatic reasoning systems in logic and were designed usinga large body of human-computer interaction best practices: they are\emph{minimal} in that no visual element is superfluous; they are\emph{unambiguous} in that no two queries with different semantics map to thesame visualization; and they \emph{extend} previously existing visualrepresentations of relational schemata and conjunctive queries in a naturalway. An experimental evaluation involving 42 users on Amazon Mechanical Turkshows that with only a 2--3 minute static tutorial, participants couldinterpret queries meaningfully faster with our diagrams than when reading SQLalone. Moreover, we have evidence that our visual diagrams result inparticipants making fewer errors than with SQL. We believe that more regularexposure to diagrammatic representations of SQL can give rise to a\emph{pattern-based} and thus more intuitive use and re-use of SQL. All detailson the experimental study, the evaluation stimuli, raw data, and analyses, andsource code are available at https://osf.io/mycr2

QueryVis: Logic-based diagrams help users understand complicated SQL queries faster