arXivDaily arXiv每日学术速递 周一至周五更新
arXiv周末暂无论文更新,休息一下吧,周末愉快~~
arXiv 2409.15985cs.AI
收藏

DataGpt-SQL-7B:一个用于Text-to-SQL的开源语言模型

DataGpt-SQL-7B: An Open-Source Language Model for Text-to-SQL

Cainiao Network(菜鸟网络)

Lixia Wu, Peng Li, Junhong Lou, Lei Fu

AI总结:

本文提出开源模型DataGpt-SQL-7B,通过构建超2万样本数据集、集成代码校正器与自我修正机制,在spider-dev上达到87.2%准确率,有效解决了Text-to-SQL转换问题。

摘要:

为解决将自然语言查询转换为SQL命令的关键问题,我们提出了一系列紧凑的微调模型和自我修正机制,以普及非专家用户的数据访问与分析,降低闭源大型语言模型的风险。具体而言,我们构建了包含超过2万个样本的Text-to-SQL数据集及偏好数据集,以提高SQL生成领域的效率。为进一步确保代码有效性,模型集成了代码校正器。我们的系统DataGpt-sql在spider-dev上分别达到了87.2%的准确率,展示了该方案在Text-to-SQL转换任务中的有效性。代码、数据和模型可在\url{https://github.com/CainiaoTechAi/datagpt-sql-7b}获取。

英文摘要:

In addressing the pivotal role of translating natural language queries into SQL commands, we propose a suite of compact, fine-tuned models and self-refine mechanisms to democratize data access and analysis for non-expert users, mitigating risks associated with closed-source Large Language Models. Specifically, we constructed a dataset of over 20K sample for Text-to-SQL as well as the preference dateset, to improve the efficiency in the domain of SQL generation. To further ensure code validity, a code corrector was integrated into the model. Our system, DataGpt-sql, achieved 87.2\% accuracy on the spider-dev, respectively, showcasing the effectiveness of our solution in text-to-SQL conversion tasks. Our code, data, and models are available at \url{https://github.com/CainiaoTechAi/datagpt-sql-7b}

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑