QueryViz: helping users understand SQL queries and their patterns
QueryViz: helping users understand SQL queries and their patterns
复制标题
QueryViz：帮助用户理解 SQL 查询及其模式
DOI：
10.1145/1951365.1951440
复制
发表时间：
2011
期刊：
影响因子：
--
通讯作者：
Wolfgang Gatterbauer
中科院分区：
文献类型：
--
作者：
Jonathan Danaparamita;Wolfgang Gatterbauer
我们提出了QueryViz，一种新颖的可视化工具SQL查询，减少了阅读和理解现有查询所需的时间。它针对两个主要受众：（i）经常发出相同或类似查询的用户，以及需要快速浏览现有查询存储库的用户;（ii）试图熟悉SQL查询替代模式背后的逻辑的新手。QueryViz只使用两个字符串作为输入：数据库模式和SQL查询。因此，它可以作为现有数据库系统的轻量级附加组件，也可以通过http://queryviz.com的在线界面获得。
在这个演示中，我们解释了我们的视觉字母表，浏览了可视化算法，并让用户在浏览著名的教科书SQL查询存储库时，体验从文本或图形表示理解SQL查询的差异。
We present QueryViz, a novel visualization tool for SQL queries that reduces the time needed to read and understand existing queries. It targets two principal audiences: (i) users who often issue the same or similar queries and who need to quickly browse through a repository of existing queries; and (ii) novices that try to familiarize themselves with the logic behind alternative patterns of SQL queries. QueryViz uses as input only two strings: the database schema and the SQL query. It can thus serve as light-weight add-on to existing database systems and is also available via an online interface at http://queryviz.com.
In this demonstration, we explain our visual alphabet, walk through the visualization algorithm, and let users experience the difference in understanding SQL queries from text or our graphical representation while browsing through repositories of well-known textbook SQL queries.