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 条
  • [41] Multi-hop Question Generation with Graph Convolutional Network
    Su, Dan
    Xu, Yan
    Dai, Wenliang
    Ji, Ziwei
    Yu, Tiezheng
    Fung, Pascale
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS, EMNLP 2020, 2020, : 4636 - 4647
  • [42] DepWiGNN: A Depth-wise Graph Neural Network for Multi-hop Spatial Reasoning in Text
    Li, Shuaiyi
    Deng, Yang
    Lam, Wai
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS - EMNLP 2023, 2023, : 6459 - 6471
  • [43] 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
  • [44] SQL generation method based on dependency relational graph attention network
    Shu Q.
    Liu X.
    Tan Z.
    Li X.
    Wan C.
    Liu D.
    Liao G.
    Zhejiang Daxue Xuebao (Gongxue Ban)/Journal of Zhejiang University (Engineering Science), 2024, 58 (05): : 908 - 917
  • [45] Brain Age Prediction Using Multi-Hop Graph Attention Combined with Convolutional Neural Network
    Lim, Heejoo
    Joo, Yoonji
    Ha, Eunji
    Song, Yumi
    Yoon, Sujung
    Shin, Taehoon
    BIOENGINEERING-BASEL, 2024, 11 (03):
  • [46] Edge-featured multi-hop attention graph neural network for intrusion detection system
    Deng, Ping
    Huang, Yong
    COMPUTERS & SECURITY, 2025, 148
  • [47] 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
  • [48] Exploring Dimensions of Generalizability and Few-shot Transfer for Text-to-SQL Semantic Parsing
    Patil, Rajaswa
    Patwardhan, Manasi
    Karande, Shirish
    Vig, Lovekesh
    Shroff, Gautam
    TRANSFER LEARNING FOR NATURAL LANGUAGE PROCESSING WORKSHOP, VOL 203, 2022, 203 : 103 - 114
  • [49] Bridging Textual and Tabular Data for Cross-Domain Text-to-SQL Semantic Parsing
    Lin, Xi Victoria
    Socher, Richard
    Xiong, Caiming
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS, EMNLP 2020, 2020, : 4870 - 4888
  • [50] Path-Enhanced Multi-hop Graph Attention Network for Aspect-based Sentiment Analysis
    Wang, Jiayi
    Yang, Lina
    Li, Xichun
    Meng, Zuqiang
    2021 INTERNATIONAL CONFERENCE ON COMPUTATIONAL SCIENCE AND COMPUTATIONAL INTELLIGENCE (CSCI 2021), 2021, : 92 - 97