节点文献

RNSQL:融合逆规范化的Text2SQL生成

RNSQL: TEXT2SQL GENERATION BASED ON REVERSE NORMALIZATION

  • 推荐 CAJ下载
  • PDF下载
  • 不支持迅雷等下载工具,请取消加速工具后下载。

【作者】 帖军; 范子琪; 孙翀; 郑禄; 朱柏尔;

【Author】 Tie Jun;Fan Ziqi;Sun Chong;Zheng Lu;Zhu Boer;College of Computer Science, South-Central Minzu University;Hubei Provincial Engineering Research Centre for Agricultural Blockchain and Intelligent Management;Hubei Provincial Engineering Research Center for Intelligent Management of Manufacturing Enterprises;

【机构】 中南民族大学计算机科学学院; 农业区块链与智能管理湖北省工程研究中心; 湖北省制造企业智能管理工程技术研究中心;

【摘要】 Text2SQL是自然语言处理科研领域中的一项重要任务,在研究智能问答系统中发挥关键性的作用,其核心任务是将自然语言描述的问题自动转换为SQL查询语句。当前研究重点为提高SQL子句任务的匹配准确率,但忽略了SQL的句法生成的正确性,涉及多表连接的SQL生成仍存在大量错误。因此,提出一种基于神经网络的Text2SQL方法,该方法通过逆规范化技术,对数据库模式进行重构,关注SQL句法生成的正确性,称为逆规范化网络(Reverse Normalization SQL, RNSQL)。经理论分析和在公共数据集Spider上实验验证,RNSQL能有效提升Text2SQL任务的质量。

【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.

【基金】 国家民委中青年英才培养计划项目(MZR20007);湖北省科技重大专项(2020AEA011);武汉市科技计划应用基础前沿项目(2020020601012267);中南民族大学研究生创新基金项目(3212021yjshq003)
  • 【文献出处】 计算机应用与软件 ,Computer Applications and Software , 编辑部邮箱 ,2025年09期
  • 【分类号】TP311.13
  • 【下载频次】16
节点文献中: