SADGA: Structure-Aware Dual Graph Aggregation Network for Text-to-SQL

NeurIPS 2021  ·  Ruichu Cai, Jinjie Yuan, Boyan Xu, Zhifeng Hao ·

The Text-to-SQL task, aiming to translate the natural language of the questions into SQL queries, has drawn much attention recently. One of the most challenging problems of Text-to-SQL is how to generalize the trained model to the unseen database schemas, also known as the cross-domain Text-to-SQL task. The key lies in the generalizability of (i) the encoding method to model the question and the database schema and (ii) the question-schema linking method to learn the mapping between words in the question and tables/columns in the database schema. Focusing on the above two key issues, we propose a Structure-Aware Dual Graph Aggregation Network (SADGA) for cross-domain Text-to-SQL. In SADGA, we adopt the graph structure to provide a unified encoding model for both the natural language question and database schema. Based on the proposed unified modeling, we further devise a structure-aware aggregation method to learn the mapping between the question-graph and schema-graph. The structure-aware aggregation method is featured with Global Graph Linking, Local Graph Linking, and Dual-Graph Aggregation Mechanism. We not only study the performance of our proposal empirically but also achieved 3rd place on the challenging Text-to-SQL benchmark Spider at the time of writing.

PDF Abstract NeurIPS 2021 PDF NeurIPS 2021 Abstract

Results from the Paper


Ranked #4 on Text-To-SQL on spider (Exact Match Accuracy (Test) metric)

     Get a GitHub badge
Task Dataset Model Metric Name Metric Value Global Rank Result Benchmark
Text-To-SQL spider SADGA + GAP Exact Match Accuracy (Dev) 73.1 # 6
Exact Match Accuracy (Test) 70.1 # 4
Semantic Parsing spider SADGA + GAP Accuracy 70.1 # 6

Methods


No methods listed for this paper. Add relevant methods here