RECPARSER: A Recursive Semantic Parsing Framework for Text-to-SQL Task

被引:0
|
作者
Zeng, Yu [1 ]
Gao, Yan [2 ]
Guo, Jiaqi [3 ]
Chen, Bei [2 ]
Liu, Qian [4 ]
Lou, Jian-Guang [2 ]
Teng, Fei [1 ]
Zhang, Dongmei [2 ]
机构
[1] Southwest Jiaotong Univ, Chengdu, Peoples R China
[2] Microsoft Res Asia, Beijing, Peoples R China
[3] Xi An Jiao Tong Univ, Xian, Peoples R China
[4] Beihang Univ, Beijing, Peoples R China
关键词
D O I
暂无
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
Neural semantic parsers usually fail to parse long and complicated utterances into nested SQL queries, due to the large search space. In this paper, we propose a novel recursive semantic parsing framework called RECPARSER to generate the nested SQL query layer-by-layer. It decomposes the complicated nested SQL query generation problem into several progressive non-nested SQL query generation problems. Furthermore, we propose a novel Question Decomposer module to explicitly encourage RECPARSER to focus on different components of an utterance when predicting SQL queries of different layers. Experiments on the Spider dataset show that our approach is more effective compared to the previous works at predicting the nested SQL queries. In addition, we achieve an overall accuracy that is comparable with state-of-the-art approaches.
引用
收藏
页码:3644 / 3650
页数:7
相关论文
共 50 条
  • [41] On the Vulnerabilities of Text-to-SQL Models
    Peng, Xutan
    Zhang, Yipeng
    Yang, Jingfeng
    Stevenson, Mark
    2023 IEEE 34TH INTERNATIONAL SYMPOSIUM ON SOFTWARE RELIABILITY ENGINEERING, ISSRE, 2023, : 1 - 12
  • [42] TSCL-SQL: Two-Stage Curriculum Learning Framework for Text-to-SQL
    尹枫
    程路易
    王秋月
    王志军
    杜明
    徐波
    Journal of Donghua University(English Edition), 2023, 40 (04) : 421 - 427
  • [43] Improving Text-to-SQL Evaluation Methodology
    Finegan-Dollak, Catherine
    Kummerfeld, Jonathan K.
    Zhang, Li
    Ramanathan, Karthik
    Sadasivam, Sesh
    Zhang, Rui
    Radev, Dragomir
    PROCEEDINGS OF THE 56TH ANNUAL MEETING OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS (ACL), VOL 1, 2018, : 351 - 360
  • [44] Exploring Schema Generalizability of Text-to-SQL
    Li, Jieyu
    Chen, Lu
    Cao, Ruisheng
    Zhu, Su
    Xu, Hongshen
    Chen, Zhi
    Zhang, Hanchong
    Yu, Kai
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS, ACL 2023, 2023, : 1344 - 1360
  • [45] Clause-Wise and Recursive Decoding for Complex and Cross-Domain Text-to-SQL Generation
    Lee, Dongjun
    2019 CONFERENCE ON EMPIRICAL METHODS IN NATURAL LANGUAGE PROCESSING AND THE 9TH INTERNATIONAL JOINT CONFERENCE ON NATURAL LANGUAGE PROCESSING (EMNLP-IJCNLP 2019): PROCEEDINGS OF THE CONFERENCE, 2019, : 6045 - 6051
  • [46] SQL-to-Schema Enhances Schema Linking in Text-to-SQL
    Yang, Sun
    Su, Qiong
    Li, Zhishuai
    Li, Ziyue
    Mao, Hangyu
    Liu, Chenxi
    Zhao, Rui
    DATABASE AND EXPERT SYSTEMS APPLICATIONS, PT I, DEXA 2024, 2024, 14910 : 139 - 145
  • [47] SyntaxSQLNet: Syntax Tree Networks for Complex and Cross-Domain Text-to-SQL Task
    Yu, Tao
    Yasunaga, Michihiro
    Yang, Kai
    Zhang, Rui
    Wang, Dongxu
    Li, Zifan
    Radev, Dragomir R.
    2018 CONFERENCE ON EMPIRICAL METHODS IN NATURAL LANGUAGE PROCESSING (EMNLP 2018), 2018, : 1653 - 1663
  • [48] Text-to-SQL: A methodical review of challenges and models
    Kanburoglu, Ali Bugra
    Tek, F. Boray
    TURKISH JOURNAL OF ELECTRICAL ENGINEERING AND COMPUTER SCIENCES, 2024, 32 (03) : 403 - 419
  • [49] DuoRAT: Towards Simpler Text-to-SQL Models
    Scholale, Torsten
    Li, Raymond
    Bandanau, Dzmitry
    de Vries, Harm
    Pal, Chris
    2021 CONFERENCE OF THE NORTH AMERICAN CHAPTER OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS: HUMAN LANGUAGE TECHNOLOGIES (NAACL-HLT 2021), 2021, : 1313 - 1321
  • [50] KaggleDBQA: Realistic Evaluation of Text-to-SQL Parsers
    Lee, Chia-Hsuan
    Polozov, Oleksandr
    Richardson, Matthew
    59TH ANNUAL MEETING OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS AND THE 11TH INTERNATIONAL JOINT CONFERENCE ON NATURAL LANGUAGE PROCESSING, VOL 1 (ACL-IJCNLP 2021), 2021, : 2261 - 2273