Example-Driven User Intent Discovery: Empowering Users to Cross the SQL Barrier Through Query by Example

TL;DR

This paper introduces SQuID, a Query by Example system that significantly improves data exploration for users with varying expertise by reducing the need for technical skills compared to traditional SQL querying.

Contribution

The paper presents SQuID, a novel QBE system that outperforms SQL in user effectiveness and efficiency, especially for non-expert users, by simplifying data access and exploration.

Findings

Users are more effective with SQuID than SQL.

SQuID reduces barriers in understanding schema and formulating queries.

SQuID alleviates the need for technical expertise in data exploration.

Abstract

Traditional data systems require specialized technical skills where users need to understand the data organization and write precise queries to access data. Therefore, novice users who lack technical expertise face hurdles in perusing and analyzing data. Existing tools assist in formulating queries through keyword search, query recommendation, and query auto-completion, but still require some technical expertise. An alternative method for accessing data is Query by Example (QBE), where users express their data exploration intent simply by providing examples of their intended data. We study a state-of-the-art QBE system called SQuID, and contrast it with traditional SQL querying. Our comparative user studies demonstrate that users with varying expertise are significantly more effective and efficient with SQuID than SQL. We find that SQuID eliminates the barriers in studying the database schema, formalizing task semantics, and writing syntactically correct SQL queries, and thus, substantially alleviates the need for technical expertise in data exploration.