A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is
We present QueryViz, a novel visualization tool for SQL queries that reduces the time needed to read and understand existing queries. ... QueryViz uses as input only two strings: the database schema and the SQL query. ... We like to thank YongChul Kwon, Nodira Khoussainova, Magdalena Balazinska and Dan Suciu for helpful discussions at early stages of this project. ...doi:10.1145/1951365.1951440 dblp:conf/edbt/DanaparamitaG11 fatcat:tnize3roebeh5an4s2zdqhl7xa
In this paper, we address the challenge of compactly encoding large sequences of SQL queries for presentation to a human user. ... Our generalization of WL allows us to define a distance metric for SQL queries, which in turn permits automated clustering of queries. ... To further aid users in their understanding of query logs, we propose two techniques for summarizing and visualizing queries in a cluster: (1) a text explanation that overviews common features of queries ...arXiv:1608.01013v1 fatcat:pepyrmjspfghfdxas4eujfxoim
Writing complex queries in SQL is a challenge for users. ... We identify two impediments to this form of interactive trial-and-error query specification in SQL: (i) changing quantifiers often requires global syntactical query restructuring, and (ii) the absence ... QueryViz, translates SQL into an equivalent graphical language  to help users better understand a query, it does not enable direct query manipulation and it does not visually expose possible semantic ...doi:10.1145/2380116.2380144 dblp:conf/uist/AbouziedHS12 fatcat:vehrq7irvbhb7jfihazzpnuxxy
Understanding the meaning of existing SQL queries is critical for code maintenance and reuse. Yet SQL can be hard to read, even for expert users or the original creator of a query. ... We conjecture that it is possible to capture the logical intent of queries in automatically-generated visual diagrams that can help users understand the meaning of queries faster and more accurately than ... ACKNOWLEDGMENTS This work was supported in part by a Khoury seed grant program, the National Science Foundation (NSF) under award numbers CAREER IIS-1762268 and ACI-1640575, and by U.S. ...doi:10.1145/3318464.3389767 arXiv:2004.11375v1 fatcat:h5kyves6xjadtnql6qqyucfnka