Multi-hop Relational Graph Attention Network for Text-to-SQL Parsing

被引:0
|
作者
Liu, Hu [1 ]
Shi, Yuliang [1 ,2 ]
Zhang, Jianlin [1 ]
Wang, Xinjun [1 ,2 ]
Li, Hui [1 ]
Kong, Fanyu [1 ]
机构
[1] Shandong Univ, Sch Software, Jinan, Peoples R China
[2] Dareway Software Co Ltd, Jinan, Peoples R China
关键词
Natural language processing; Text-to-SQL; Semantic parsing; SQL; Graph neural network;
D O I
10.1109/IJCNN54540.2023.10191914
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
Text-to-SQL aims to parse natural language problems into SQL queries, which can provide a simple interface to access large databases enabling SQL novices a quicker entry into databases. As the Text-to-SQL field is intensively studied, more and more models use GNNs to encode heterogeneous graph information in this task, and how to better obtain path information between nodes in database schema heterogeneous graphs and question-database schema heterogeneous graphs will greatly affect the effectiveness of the model parsing. Our work intends to explore the problem of solving the encoding of heterogeneous graph meta-paths in the Text-to-SQL task. Previous approaches usually use multi-layer GNNs to aggregate topological structure information between nodes. However, they ignored the structural information embedded at the edges and also failed to obtain nodes that are not directly connected but can provide contextual information through meta-paths. To solve the above problem, we propose Multi-Hop Relational Graph Attention Network based Text-to-SQL Parsing Model (MHRGATSQL) for learning topological information between nodes while obtaining semantic information embedded in the edge topology. We use multi-hop attention to modify the relational graph attention network to diffuse the attention scores throughout the network, thus increasing the "receptive field" of each layer of RGAT. Experimental results on the large-scale cross-domain Text-to-SQL dataset Spider show that our model obtains an absolute improvement of 1.7% compared to the baseline and alleviates the over-smoothing problem in the deep network model.
引用
收藏
页数:8
相关论文
共 50 条
  • [1] 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
  • [2] Decoupling SQL query hardness parsing for text-to-SQL
    Yi, Jiawen
    Chen, Guo
    Zhou, Xiaojun
    Neurocomputing, 621
  • [3] Decoupling SQL query hardness parsing for text-to-SQL
    Yi, Jiawen
    Chen, Guo
    Zhou, Xiaojun
    NEUROCOMPUTING, 2025, 621
  • [4] 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
  • [5] Service-oriented Text-to-SQL Parsing
    Hu, Wangsu
    Tian, Jilei
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS, EMNLP 2020, 2020, : 2218 - 2222
  • [6] RGISQL: Integrating Refined Grammatical Information into Relational Graph Neural Network for Text-to-SQL Task
    Li, Shuiyan
    He, Yaozhen
    Ao, Longhao
    Qi, Rongzhi
    APPLIED SCIENCES-BASEL, 2024, 14 (22):
  • [7] 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
  • [8] ShadowGNN Graph Projection Neural Network for Text-to-SQL Parser
    Chen, Zhi
    Chen, Lu
    Zhao, Yanbin
    Cao, Ruisheng
    Xu, Zihan
    Zhu, Su
    Yu, Kai
    2021 CONFERENCE OF THE NORTH AMERICAN CHAPTER OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS: HUMAN LANGUAGE TECHNOLOGIES (NAACL-HLT 2021), 2021, : 5567 - 5577
  • [9] 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
  • [10] Semantic Enhanced Text-to-SQL Parsing via Iteratively Learning Schema Linking Graph
    Liu, Aiwei
    Hu, Xuming
    Lin, Li
    Wen, Lijie
    PROCEEDINGS OF THE 28TH ACM SIGKDD CONFERENCE ON KNOWLEDGE DISCOVERY AND DATA MINING, KDD 2022, 2022, : 1021 - 1030