SQLucid: Grounding Natural Language Database Queries with Interactive Explanations

Fuente: arXiv
Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Tian, Yuan, Kummerfeld, Jonathan K., Li, Toby Jia-Jun, Zhang, Tianyi
Format: Preprint
Veröffentlicht: 2024
Schlagworte:
Online-Zugang:
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
_version_ 1866929493936963584
author Tian, Yuan
Kummerfeld, Jonathan K.
Li, Toby Jia-Jun
Zhang, Tianyi
author_facet Tian, Yuan
Kummerfeld, Jonathan K.
Li, Toby Jia-Jun
Zhang, Tianyi
contents Though recent advances in machine learning have led to significant improvements in natural language interfaces for databases, the accuracy and reliability of these systems remain limited, especially in high-stakes domains. This paper introduces SQLucid, a novel user interface that bridges the gap between non-expert users and complex database querying processes. SQLucid addresses existing limitations by integrating visual correspondence, intermediate query results, and editable step-by-step SQL explanations in natural language to facilitate user understanding and engagement. This unique blend of features empowers users to understand and refine SQL queries easily and precisely. Two user studies and one quantitative experiment were conducted to validate SQLucid's effectiveness, showing significant improvement in task completion accuracy and user confidence compared to existing interfaces. Our code is available at https://github.com/magic-YuanTian/SQLucid.
format Preprint
id arxiv_https___arxiv_org_abs_2409_06178
institution arXiv
publishDate 2024
record_format arxiv
spellingShingle SQLucid: Grounding Natural Language Database Queries with Interactive Explanations
Tian, Yuan
Kummerfeld, Jonathan K.
Li, Toby Jia-Jun
Zhang, Tianyi
Human-Computer Interaction
Computation and Language
Though recent advances in machine learning have led to significant improvements in natural language interfaces for databases, the accuracy and reliability of these systems remain limited, especially in high-stakes domains. This paper introduces SQLucid, a novel user interface that bridges the gap between non-expert users and complex database querying processes. SQLucid addresses existing limitations by integrating visual correspondence, intermediate query results, and editable step-by-step SQL explanations in natural language to facilitate user understanding and engagement. This unique blend of features empowers users to understand and refine SQL queries easily and precisely. Two user studies and one quantitative experiment were conducted to validate SQLucid's effectiveness, showing significant improvement in task completion accuracy and user confidence compared to existing interfaces. Our code is available at https://github.com/magic-YuanTian/SQLucid.
title SQLucid: Grounding Natural Language Database Queries with Interactive Explanations
topic Human-Computer Interaction
Computation and Language
url https://arxiv.org/abs/2409.06178