Filters








4 Hits in 2.4 sec

QueryViz

Jonathan Danaparamita, Wolfgang Gatterbauer
2011 Proceedings of the 14th International Conference on Extending Database Technology - EDBT/ICDT '11  
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

Summarizing Large Query Logs in Ettu [article]

Gokhan Kul, Duc Luong, Ting Xie, Patrick Coonan, Varun Chandola, Oliver Kennedy, Shambhu Upadhyaya
2016 arXiv   pre-print
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

DataPlay

Azza Abouzied, Joseph Hellerstein, Avi Silberschatz
2012 Proceedings of the 25th annual ACM symposium on User interface software and technology - UIST '12  
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 [5] 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

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

Aristotelis Leventidis, Jiahui Zhang, Cody Dunne, Wolfgang Gatterbauer, H.V. Jagadish, Mirek Riedewald
2020 pre-print
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