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 条
  • [31] Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsing
    Bogin, Ben
    Gardner, Matt
    Berant, Jonathan
    57TH ANNUAL MEETING OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS (ACL 2019), 2019, : 4560 - 4565
  • [32] Leveraging Explicit Lexico-logical Alignments in Text-to-SQL Parsing
    Sun, Runxin
    He, Shizhu
    Zhu, Chong
    He, Yaohan
    Li, Jinlong
    Zhao, Jun
    Liu, Kang
    PROCEEDINGS OF THE 60TH ANNUAL MEETING OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS (ACL 2022): (SHORT PAPERS), VOL 2, 2022, : 283 - 289
  • [33] Importance of Synthesizing High-quality Data for Text-to-SQL Parsing
    Hu, Yiqun
    Zhao, Yiyun
    Jiang, Jiarong
    Lan, Wuwei
    Zhu, Henry
    Chauhan, Anuj
    Li, Alexander
    Pan, Lin
    Wang, Jun
    Hang, Chung-Wei
    Zhang, Sheng
    Guo, Jiang
    Dong, Marvin
    Lilien, Joe
    Ng, Patrick
    Wang, Zhiguo
    Castelli, Vittorio
    Xiang, Bing
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS, ACL 2023, 2023, : 1327 - 1343
  • [34] Improving Generalization in Language Model-Based Text-to-SQL Semantic Parsing: Two Simple Semantic Boundary-Based Techniques
    Rai, Daking
    Wang, Bailin
    Zhou, Yilun
    Yao, Ziyu
    61ST CONFERENCE OF THE THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS, ACL 2023, VOL 2, 2023, : 150 - 160
  • [35] Multi-hop Relational Graph Attention Network for Text-to-SQL Parsing
    Liu, Hu
    Shi, Yuliang
    Zhang, Jianlin
    Wang, Xinjun
    Li, Hui
    Kong, Fanyu
    2023 INTERNATIONAL JOINT CONFERENCE ON NEURAL NETWORKS, IJCNN, 2023,
  • [36] Zero-Shot Text-to-SQL Learning with Auxiliary Task
    Chang, Shuaichen
    Liu, Pengfei
    Tang, Yun
    Huang, Jing
    He, Xiaodong
    Zhou, Bowen
    THIRTY-FOURTH AAAI CONFERENCE ON ARTIFICIAL INTELLIGENCE, THE THIRTY-SECOND INNOVATIVE APPLICATIONS OF ARTIFICIAL INTELLIGENCE CONFERENCE AND THE TENTH AAAI SYMPOSIUM ON EDUCATIONAL ADVANCES IN ARTIFICIAL INTELLIGENCE, 2020, 34 : 7488 - 7495
  • [37] Data Augmentation with Hierarchical SQL-to-Question Generation for Cross-domain Text-to-SQL Parsing
    Wu, Kun
    Wang, Lijie
    Li, Zhenghua
    Zhang, Ao
    Xiao, Xinyan
    Wu, Hua
    Zhang, Min
    Wang, Haifeng
    2021 CONFERENCE ON EMPIRICAL METHODS IN NATURAL LANGUAGE PROCESSING (EMNLP 2021), 2021, : 8974 - 8983
  • [38] A Heterogeneous Graph to Abstract Syntax Tree Framework for Text-to-SQL
    Cao, Ruisheng
    Chen, Lu
    Li, Jieyu
    Zhang, Hanchong
    Xu, Hongshen
    Zhang, Wangyou
    Yu, Kai
    IEEE TRANSACTIONS ON PATTERN ANALYSIS AND MACHINE INTELLIGENCE, 2023, 45 (11) : 13796 - 13813
  • [39] ReFSQL: A Retrieval-Augmentation Framework for Text-to-SQL Generation
    Zhang, Kun
    Lin, Xiexiong
    Wang, Yuanzhuo
    Zhang, Xin
    Sun, Fei
    Cen, Jianhe
    Jiang, Xuhui
    Tan, Hexiang
    Shen, Huawei
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS - EMNLP 2023, 2023, : 664 - 673
  • [40] Bridging the gap between text-to-SQL research and real-world applications: A unified all-in-one framework for text-to-SQL
    Han, Mirae
    Park, Seongsik
    Kim, Harksoo
    Kim, Seulgi
    KNOWLEDGE-BASED SYSTEMS, 2024, 306