计算机应用与软件2025，Vol.42Issue(9)：31-37,86,8.DOI:10.3969/j.issn.1000-386x.2025.09.005
RNSQL:融合逆规范化的Text2SQL生成
RNSQL:TEXT2SQL GENERATION BASED ON REVERSE NORMALIZATION
摘要
Abstract
Text2SQL is an essential task in natural language processing scientific research.It plays a crucial role in studying intelligent question and answer systems,where the core task is to automatically convert questions described in natural language into SQL query statements.Current research focuses on improving the matching accuracy of SQL clause tasks.However,it ignores the correctness of syntactic generation of SQL,and the production of SQL involving multiple tables joining still suffers from a large number of errors.As a result,a neural network-based Text2SQL approach is proposed,which refactors the database schema to focus on the correctness of SQL syntax generation through an inverse normalization technique called RNSQL(Reverse Normalization SQL).Validated by theoretical analysis and experiments on the public dataset Spider,RNSQL can effectively improve the quality of Text2SQL tasks.关键词
逆规范化/语义解析/Text2SQL/槽填充Key words
Reverse normalization/Semantic parsing/Text2SQL/Slot filling分类
信息技术与安全科学引用本文复制引用
帖军,范子琪,孙翀,郑禄,朱柏尔..RNSQL:融合逆规范化的Text2SQL生成[J].计算机应用与软件,2025,42(9):31-37,86,8.基金项目
国家民委中青年英才培养计划项目(MZR20007) （MZR20007）
湖北省科技重大专项(2020AEA011) （2020AEA011）
武汉市科技计划应用基础前沿项目(2020020601012267) （2020020601012267）
中南民族大学研究生创新基金项目(3212021yjshq003). （3212021yjshq003）
