ExplIQuE: Interactive Databases Exploration with SQL - Archive ouverte HAL
Communication Dans Un Congrès Année : 2019

ExplIQuE: Interactive Databases Exploration with SQL

Marie Le Guilly
  • Fonction : Auteur
  • PersonId : 1259643
Jean-Marc Petit
Vasile-Marian Scuturici

Résumé

To help databases users who have just started learning SQL or are not familiar with their database, we propose ExplIQuE, an exploration interface with query extensions. Its purpose is to assist users to smoothly dive into data exploration, and to be able to express imprecise questions over their data. Indeed, such situations are more and more current with the increasing desire for users to get value out of their data. In this configuration, in addition to classic SQL querying possibilities, ExplIQuE offers the possibility to extend a given SQL query, by suggesting a set of possible selection predicates to add to the query, that aim at dividing the initial answer set to identify interesting exploration zones. In addition, ExplIQuE proposes some indicators to help the user in choosing its desire extension and in understanding her data, as well as interactive visualizations of the result set, in two dimensions revealed by PCA techniques. In this demonstration, we offer the audience the possibility to try the various functionalities of ExplIQuE by trying to express an imprecise question over a scientific database on bacterial colonies, through an iterative process. A video of the proposed demonstration is available at https://youtu.be/oK8xWGCWj_A.
Fichier principal
Vignette du fichier
CIKM.pdf (555.1 Ko) Télécharger le fichier
Origine Fichiers produits par l'(les) auteur(s)
Licence
Domaine public

Dates et versions

hal-04118337 , version 1 (06-06-2023)

Licence

Domaine public

Identifiants

Citer

Marie Le Guilly, Jean-Marc Petit, Vasile-Marian Scuturici, Ihab F Ilyas. ExplIQuE: Interactive Databases Exploration with SQL. CIKM '19: The 28th ACM International Conference on Information and Knowledge Management, Nov 2019, Beijing, France. pp.2877-2880, ⟨10.1145/3357384.3357847⟩. ⟨hal-04118337⟩
18 Consultations
71 Téléchargements

Altmetric

Partager

More