arrow
返回

XiYan-SQL: A Novel Multi-Generator Framework for Text-to-SQL

delete2026-01-26
delete0
PRE
AI
Y
Yifu Liu
Y
Yin Zhu
Y
Yingqi Gao
Z
Zhiling Luo
X
Xiaoxia Li
X
Xiaorong Shi
Y
Yuntao Hong
J
Jinyang Gao
Y
Yu Li
B
Bolin Ding
J
Jingren Zhou
DOI:10.1109/TKDE.2026.3657851delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
To leverage the advantages of LLM in addressing challenges in the Text-to-SQL task, we present XiYan-SQL, an innovative framework effectively generating and utilizing multiple SQL candidates. It consists of three components: 1) a Schema Filter module filtering and obtaining multiple relevant schemas; 2) a multi-generator ensemble approach generating multiple high-quality and diverse SQL queries; 3) a selection model with a candidate reorganization strategy implemented to obtain the optimal SQL query. Specifically, for the multi-generator ensemble, we employ a multi-task fine-tuning strategy to enhance the capabilities of SQL generation models for the intrinsic alignment between SQL and text, and construct multiple generation models with distinct generation styles by fine-tuning across different SQL formats. The experimental results and comprehensive analysis demonstrate the effectiveness and robustness of our framework. Overall, XiYan-SQL achieves a new SOTA performance of 75.63% on the notable BIRD benchmark, surpassing all previous methods. It also attains SOTA performance on the Spider test set with an accuracy of 89.65%.
Keyword:
Generation
Text-to-SQL
multiple model ensemble
LLM fine-tuning strategy

期刊

IEEE Transactions on Knowledge and Data Engineering 封面图
IEEE Transactions on Knowledge and Data Engineering
IF:
10.4
论文数:
6.9K
被引数:
3.2W

机构

A
Alibaba Cloud Computing Company Ltd.
学者数:
12
论文数: 2
被引数: 0
引用论文

引用论文

Lost in the Middle: How Language Models Use Long Contexts迷失在中间: 语言模型如何使用长上下文
err2024-02-23
err56
errOAAI
errLiu, Nelson F.; Lin, Kevin; Hewitt, John; Paranjape, Ashwin; Bevilacqua, Michele; Petroni, Fabio; Liang, Percy
err分享
err收藏
err分享
err收藏
CodeS: Towards Building Open-source Language Models for Text-to-SQLCodeS: 构建用于文本到SQL的开源语言模型
err2024-05-30
err0
errOAAI
errHaoyang Li; Jing Zhang; Hanbing Liu; Ju Fan; Xiaokang Zhang; Jun Zhu; Renjie Wei; Hongyan Pan; Cuiping Li; Hong Chen
err分享
err收藏
学者 查看更多内容