让不懂SQL的人也能精准理解并修改数据库查询。
SQLucid: Grounding Natural Language Database Queries with Interactive Explanations
- 用自然语言分步解释每步SQL逻辑，可编辑修改。
- 结合可视化对应和中间结果，提升查询准确性。
- 适合非技术人员使用，提升信心与效率。
尽管机器学习在数据库自然语言接口方面取得了显著进展，但这些系统在高风险领域的准确性和可靠性仍有限。本文提出SQLucid，一种新型用户界面，弥合非专业用户与复杂数据库查询之间的鸿沟。该系统通过整合视觉对应关系、中间查询结果以及可编辑的自然语言步骤化SQL解释，促进用户理解与参与。两项用户研究和一项定量实验验证了其有效性，相比现有界面，显著提升了任务完成准确率和用户信心。代码已开源。
原文摘要 · Abstract (English)
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.
Thank you to arXiv for use of its open access interoperability. PaperDance 不是 arXiv 官方产品；中文卡片由大模型生成，请以原文为准。