Encoding Database Schemas with Relation-Aware Self-Attention for Text-to-SQL Parsers

06/27/2019
by   Richard Shin, et al.
0

When translating natural language questions into SQL queries to answer questions from a database, we would like our methods to generalize to domains and database schemas outside of the training set. To handle complex questions and database schemas with a neural encoder-decoder paradigm, it is critical to properly encode the schema as part of the input with the question. In this paper, we use relation-aware self-attention within the encoder so that it can reason about how the tables and columns in the provided schema relate to each other and use this information in interpreting the question. We achieve significant gains on the recently-released Spider dataset with 42.94 match accuracy, compared to the 18.96

READ FULL TEXT

page 1

page 2

page 3

page 4

research
11/10/2019

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

When translating natural language questions into SQL queries to answer q...
research
06/25/2023

A Multilingual Translator to SQL with Database Schema Pruning to Improve Self-Attention

Long sequences of text are challenging in the context of transformers, d...
research
11/01/2021

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

The Text-to-SQL task, aiming to translate the natural language of the qu...
research
08/02/2021

Relation Aware Semi-autoregressive Semantic Parsing for NL2SQL

Natural language to SQL (NL2SQL) aims to parse a natural language with a...
research
05/15/2019

Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsing

Research on parsing language to SQL has largely ignored the structure of...
research
04/18/2019

Recursive and Clause-Wise Decoding for Complex and Cross-Domain Text-to-SQL Generation

Most deep learning approaches for text-to-SQL generation are limited to ...
research
05/14/2022

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

Relational structures such as schema linking and schema encoding have be...

Please sign up or login with your details

Forgot password? Click here to reset