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 条
  • [21] UniSAr: a unified structure-aware autoregressive language model for text-to-SQL semantic parsing
    Longxu Dou
    Yan Gao
    Mingyang Pan
    Dingzirui Wang
    Wanxiang Che
    Jian-Guang Lou
    Dechen Zhan
    International Journal of Machine Learning and Cybernetics, 2023, 14 : 4361 - 4376
  • [22] Bridging the Generalization Gap in Text-to-SQL Parsing with Schema Expansion
    Zhao, Chen
    Su, Yu
    Pauls, Adam
    Platanios, Emmanouil Antonios
    PROCEEDINGS OF THE 60TH ANNUAL MEETING OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS (ACL 2022), VOL 1: (LONG PAPERS), 2022, : 5568 - 5578
  • [23] RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQL
    Li, Haoyang
    Zhang, Jing
    Li, Cuiping
    Chen, Hong
    THIRTY-SEVENTH AAAI CONFERENCE ON ARTIFICIAL INTELLIGENCE, VOL 37 NO 11, 2023, : 13067 - 13075
  • [24] MIGA: A Unified Multi-Task Generation Framework for Conversational Text-to-SQL
    Fu, Yingwen
    Ou, Wenjie
    Yu, Zhou
    Lin, Yue
    THIRTY-SEVENTH AAAI CONFERENCE ON ARTIFICIAL INTELLIGENCE, VOL 37 NO 11, 2023, : 12790 - 12798
  • [25] Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Task
    Yu, Tao
    Zhang, Rui
    Yang, Kai
    Yasunaga, Michihiro
    Wang, Dongxu
    Li, Zifan
    Ma, James
    Li, Irene
    Yao, Qingning
    Roman, Shanelle
    Zhang, Zilin
    Radev, Dragomir R.
    2018 CONFERENCE ON EMPIRICAL METHODS IN NATURAL LANGUAGE PROCESSING (EMNLP 2018), 2018, : 3911 - 3921
  • [26] Global Reasoning over Database Structures for Text-to-SQL Parsing
    Bogin, Ben
    Gardner, Matt
    Berant, Jonathan
    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, : 3659 - 3664
  • [27] Leveraging Large Language Model for Enhanced Text-to-SQL Parsing
    Zhan, Zecheng
    Haihong, E.
    Song, Meina
    IEEE ACCESS, 2025, 13 : 30497 - 30504
  • [28] Exploring the Compositional Generalization in Context Dependent Text-to-SQL Parsing
    Liu, Aiwei
    Liu, Wei
    Hu, Xuming
    Li, Shu'ang
    Ma, Fukun
    Yang, Yawen
    Wen, Lijie
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS, ACL 2023, 2023, : 688 - 700
  • [29] Hierarchical Schema Representation for Text-to-SQL Parsing With Decomposing Decoding
    Song, Meina
    Zhan, Zecheng
    E, Haihong
    IEEE ACCESS, 2019, 7 : 103706 - 103715
  • [30] Semantic Evaluation for Text-to-SQL with Distilled Test Suites
    Zhong, Ruiqi
    Yu, Tao
    Klein, Dan
    PROCEEDINGS OF THE 2020 CONFERENCE ON EMPIRICAL METHODS IN NATURAL LANGUAGE PROCESSING (EMNLP), 2020, : 396 - 411