paper-with-me

Papers

RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers

2019-11-10 · ACL 2020 6 · Bailin Wang, Richard Shin, Xiaodong Liu, Oleksandr Polozov, Matthew Richardson

When translating natural language questions into SQL queries to answer questions from a database, contemporary semantic parsing models struggle to generalize to unseen database schemas. The generalization challenge lies in (a) encoding the database relations in an accessible way for the semantic parser, and (b) modeling alignment between database columns and their mentions in a given query. We present a unified framework, based on the relation-aware self-attention mechanism, to address schema encoding, schema linking, and feature representation within a text-to-SQL encoder. On the challenging Spider dataset this framework boosts the exact match accuracy to 57.2%, surpassing its best counterparts by 8.7% absolute improvement. Further augmented with BERT, it achieves the new state-of-the-art performance of 65.6% on the Spider leaderboard. In addition, we observe qualitative improvements in the model's understanding of schema linking and alignment. Our implementation will be open-sourced at https://github.com/Microsoft/rat-sql.

📄 PDF Abstract BibTeX arXiv:1911.04942

Code (4)

Microsoft/rat-sql 공식 구현 pytorch
PaddlePaddle/PaddleNLP/tree/develop/examples/text_to_sql/RAT-SQL paddle
dmirlab-group/sadga pytorch
yandex-research/sparqling-queries pytorch

Tasks

RelationSemantic ParsingText to SQLText-To-SQL

Methods 이 논문이 사용한 방법론

Linear Layer A Linear Layer is a projection $\mathbf{XW + b}$.
Weight Decay 설명 없음
Residual Connection 설명 없음
Adam 설명 없음
Layer Normalization Unlike batch normalization, Layer Normalization directly estimates the normalization statistics from the summed inputs…
Softmax The Softmax output function transforms a previous layer's output into a vector of probabilities. It is commonly used for multiclass classification. Given an input vector $x$…
Attention 설명 없음
Dropout Dropout is a regularization technique for neural networks that drops a unit (along with connections) at training time with a specified probability $p$ (a common value is…

Similar Papers 제목 키워드 기반

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

2021-11-01 · NeurIPS 2021 12 · 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 mo…

Semantic ParsingText to SQLText-To-SQL

Schema-Aware Multi-Task Learning for Complex Text-to-SQL

2024-03-09 · Yangjun Wu, Han Wang

Conventional text-to-SQL parsers are not good at synthesizing complex SQL queries that involve multiple tables or columns, due to the challenges inherent in identifying the correct schema items and performing accurate al…

DecoderMulti-Task LearningText to SQLText-To-SQL+1

RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQL

2023-02-12 · Haoyang Li, Jing Zhang, Cuiping Li, Hong Chen

One of the recent best attempts at Text-to-SQL is the pre-trained language model. Due to the structural property of the SQL queries, the seq2seq model takes the responsibility of parsing both the schema items (i.e., tabl…

DecoderLanguage ModelingLanguage ModellingSemantic Parsing+3

Neural Approaches for Natural Language Interfaces to Databases: A Survey

2020-12-01 · COLING 2020 8 · Radu Cristian Alexandru Iacob, Florin Brad, Elena-Simona Apostol, Ciprian-Octavian Truic{\u{a}} 외

A natural language interface to databases (NLIDB) enables users without technical expertise to easily access information from relational databases. Interest in NLIDBs has resurged in the past years due to the availabilit…

DecoderSurvey

RASAT: Integrating Relational Structures into Pretrained Seq2Seq Model for Text-to-SQL

2022-05-14 · Jiexing Qi, Jingyao Tang, Ziwei He, Xiangpeng Wan 외

Relational structures such as schema linking and schema encoding have been validated as a key component to qualitatively translating natural language into SQL queries. However, introducing these structural relations come…

Dialogue State TrackingSemantic ParsingText to SQLText-To-SQL