Skip to Main content Skip to Navigation
Reports

SQL Query Completion for Data Exploration

Marie Le Guilly 1 Jean-Marc Petit 1 Vasile-Marian Scuturici 1
1 BD - Base de Données
LIRIS - Laboratoire d'InfoRmatique en Image et Systèmes d'information
Abstract : Within the big data tsunami, relational databases and SQL are still there and remain mandatory in most of cases for accessing data. On the one hand, SQL is easy-to-use by non specialists and allows to identify pertinent initial data at the very beginning of the data exploration process. On the other hand, it is not always so easy to formulate SQL queries: nowadays, it is more and more frequent to have several databases available for one application domain, some of them with hundreds of tables and/or attributes. Identifying the pertinent conditions to select the desired data, or even identifying relevant attributes is far from trivial. To make it easier to write SQL queries, we propose the notion of SQL query completion: given a query, it suggests additional conditions to be added to its WHERE clause. This completion is semantic, as it relies on the data from the database, unlike current completion tools that are mostly syntactic. Since the process can be repeated over and over again – until the data analyst reaches her data of interest –, SQL query completion facilitates the exploration of databases. SQL query completion has been implemented in a SQL editor on top of a database management system. For the evaluation, two questions need to be studied: first, does the completion speed up the writing of SQL queries? Second , is the completion easily adopted by users? A thorough experiment has been conducted on a group of 70 computer science students divided in two groups (one with the completion and the other one without) to answer those questions. The results are positive and very promising.
Complete list of metadatas

Cited literature [24 references]  Display  Hide  Download

https://hal.archives-ouvertes.fr/hal-01703346
Contributor : Marie Le Guilly <>
Submitted on : Wednesday, February 7, 2018 - 5:36:06 PM
Last modification on : Wednesday, November 20, 2019 - 3:13:49 AM

Files

main2.pdf
Files produced by the author(s)

Identifiers

  • HAL Id : hal-01703346, version 1
  • ARXIV : 1802.02872

Citation

Marie Le Guilly, Jean-Marc Petit, Vasile-Marian Scuturici. SQL Query Completion for Data Exploration. [Research Report] INSA Lyon. 2018. ⟨hal-01703346⟩

Share

Metrics

Record views

210

Files downloads

480