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 条
  • [1] Semantic Decomposition of Question and SQL for Text-to-SQL Parsing
    Eyal, Ben
    Bachar, Amir
    Haroche, Ophir
    Mahabi, Moran
    Elhadad, Michael
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS (EMNLP 2023), 2023, : 13629 - 13645
  • [2] Error Detection for Text-to-SQL Semantic Parsing
    Chen, Shijie
    Chen, Ziru
    Sun, Huan
    Su, Yu
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS (EMNLP 2023), 2023, : 11730 - 11743
  • [3] A Pilot Study of Text-to-SQL Semantic Parsing for Vietnamese
    Anh Tuan Nguyen
    Mai Hoang Dao
    Dat Quoc Nguyen
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS, EMNLP 2020, 2020, : 4079 - 4085
  • [4] Parallel Corpus Curation for Filipino Text-to-SQL Semantic Parsing
    Borjal, Christalline Joie
    Visperas, Moses
    Adoptante, Aunhel John
    Abia, Ma. Teresita
    Catapang, Jasper Kyle
    Peramo, Elmer
    2023 INTERNATIONAL CONFERENCE ON ARTIFICIAL INTELLIGENCE IN INFORMATION AND COMMUNICATION, ICAIIC, 2023, : 163 - 169
  • [5] MultiSpider: Towards Benchmarking Multilingual Text-to-SQL Semantic Parsing
    Dou, Longxu
    Gao, Yan
    Pan, Mingyang
    Wang, Dingzirui
    Che, Wanxiang
    Zhan, Dechen
    Lou, Jian-Guang
    Proceedings of the 37th AAAI Conference on Artificial Intelligence, AAAI 2023, 2023, 37 : 12745 - 12753
  • [6] MultiSpider: Towards Benchmarking Multilingual Text-to-SQL Semantic Parsing
    Dou, Longxu
    Gao, Yan
    Pan, Mingyang
    Wang, Dingzirui
    Che, Wanxiang
    Zhan, Dechen
    Lou, Jian-Guang
    THIRTY-SEVENTH AAAI CONFERENCE ON ARTIFICIAL INTELLIGENCE, VOL 37 NO 11, 2023, : 12745 - 12753
  • [7] Model-based Interactive Semantic Parsing: A Unified Framework and A Text-to-SQL Case Study
    Yao, Ziyu
    Su, Yu
    Sun, Huan
    Yih, Wen-tau
    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, : 5447 - 5458
  • [8] Decoupling SQL query hardness parsing for text-to-SQL
    Yi, Jiawen
    Chen, Guo
    Zhou, Xiaojun
    Neurocomputing, 621
  • [9] Decoupling SQL query hardness parsing for text-to-SQL
    Yi, Jiawen
    Chen, Guo
    Zhou, Xiaojun
    NEUROCOMPUTING, 2025, 621
  • [10] Service-oriented Text-to-SQL Parsing
    Hu, Wangsu
    Tian, Jilei
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS, EMNLP 2020, 2020, : 2218 - 2222