Query Interpretation is the problem of reading and understanding existing SQL queries. It is often as hard as Query Composition, i.e. creating a new query. Hence today, data analysts who iteratively analyze and explore large data sets with SQL do not build upon previously issued queries; they rather build their queries from scratch. We envision a new and more effective user-query interaction which is facilitated by new tools that help users quickly understand the intent of existing SQL queries. Users can thus browse through sets of past queries, understand their patterns, and leverage those query templates to compose new ones.

QueryVis

QueryVis (formerly called QueryViz)

QueryVis is such a novel visualization tool that reduces the time needed to read and understand existing SQL queries. It thus enables effective query-reuse, a principal component in the vision of a Collaborative Query Management System (CQMS). Our visual formalism provides a minimal, yet expressive visual vocabulary that intuitively encode the "meaning" of a SQL query. It is inspired by the First-Order logic representation of SQL and combines succinctness features of both tuple and domain relational calculus.

QueryVis

We target 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. QueryVis 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.

Online Demonstration

Please see an illustrative example for the idea of SQL patterns, and feel free to play with Online QueryVis, an online demo from EDBT 2011 which allows you to quickly visualize your queries (see the SQL grammar that QueryVis currently supports).

People & Affiliations

(Former undergraduate student @ University of Washington)
(Graduate student @ Northeastern University)
(Assistant Professor @ Northeastern University)
(Associate Professor @ Northeastern University)
(Graduate student @ Northeastern University)
(Professor @ University of Michigan at Ann Arbor)
(Associate Professor @ Northeastern University)
(Graduate student @ Northeastern University)
Northeastern University, Khoury College of Computer Sciences University of Michigan, Computer Science and Engineering Northeastern Datalab Data visualization @ Khoury

Publications

Talk at SIGMOD 2020

Talk at VLDB 2011

Funding

This project is motivated by the Collaborative Query Management (CQMS) project and has been supported in part by NSF grant IIS-0915054 (the BeliefDB project), NSF grant CAREER IIS-1762268, the Khoury seed grant program, and an Amazon AWS Education grant award. Any opinions, findings, and conclusions or recommendations expressed in this project are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.

National Science Foundation Northeastern University, Khoury College of Computer Science Amazon web services