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 (CURRENTLY OFFLINE)

Feel free to play with Online QueryVis, our current online demo which allows you to quickly visualize your queries (see the SQL grammar that QueryVis currently supports). You can also try an example Usage Scenario: Given a natural language description of a query, choose its translation into SQL query among a set of similar queries either with or without having QueryVis as your friend.

People & Affiliations

(Former undergraduate student @ University of Washington)
(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

Publications

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 Amazon web services