Global Reasoning over Database Structures for Text-to-SQL Parsing

08/29/2019
by   Ben Bogin, et al.
0

State-of-the-art semantic parsers rely on auto-regressive decoding, emitting one symbol at a time. When tested against complex databases that are unobserved at training time (zero-shot), the parser often struggles to select the correct set of database constants in the new database, due to the local nature of decoding. In this work, we propose a semantic parser that globally reasons about the structure of the output query to make a more contextually-informed selection of database constants. We use message-passing through a graph neural network to softly select a subset of database constants for the output query, conditioned on the question. Moreover, we train a model to rank queries based on the global alignment of database constants to question words. We apply our techniques to the current state-of-the-art model for Spider, a zero-shot semantic parsing dataset with complex databases, increasing accuracy from 39.4 to 47.4

READ FULL TEXT

page 1

page 2

page 3

page 4

research
09/16/2020

Grounded Adaptation for Zero-shot Executable Semantic Parsing

We propose Grounded Adaptation for Zero-shot Executable Semantic Parsing...
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
08/20/2018

Question Generation from SQL Queries Improves Neural Semantic Parsing

We study how to learn a semantic parser of state-of-the-art accuracy wit...
research
10/23/2020

SmBoP: Semi-autoregressive Bottom-up Semantic Parsing

The de-facto standard decoding method for semantic parsing in recent yea...
research
06/15/2023

Interleaving Pre-Trained Language Models and Large Language Models for Zero-Shot NL2SQL Generation

Zero-shot NL2SQL is crucial in achieving natural language to SQL that is...
research
10/13/2022

Searching for Better Database Queries in the Outputs of Semantic Parsers

The task of generating a database query from a question in natural langu...
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...

Please sign up or login with your details

Forgot password? Click here to reset