Improving Text-to-SQL Semantic Parsing with Fine-grained Query Understanding

09/28/2022
by   Jun Wang, et al.
24

Most recent research on Text-to-SQL semantic parsing relies on either parser itself or simple heuristic based approach to understand natural language query (NLQ). When synthesizing a SQL query, there is no explicit semantic information of NLQ available to the parser which leads to undesirable generalization performance. In addition, without lexical-level fine-grained query understanding, linking between query and database can only rely on fuzzy string match which leads to suboptimal performance in real applications. In view of this, in this paper we present a general-purpose, modular neural semantic parsing framework that is based on token-level fine-grained query understanding. Our framework consists of three modules: named entity recognizer (NER), neural entity linker (NEL) and neural semantic parser (NSP). By jointly modeling query and database, NER model analyzes user intents and identifies entities in the query. NEL model links typed entities to schema and cell values in database. Parser model leverages available semantic information and linking results and synthesizes tree-structured SQL queries based on dynamically generated grammar. Experiments on SQUALL, a newly released semantic parsing dataset, show that we can achieve 56.8 WikiTableQuestions (WTQ) test set, which outperforms the state-of-the-art model by 2.7

READ FULL TEXT

page 1

page 2

page 3

page 4

research
09/30/2020

A Tale of Two Linkings: Dynamically Gating between Schema Linking and Structural Linking for Text-to-SQL Parsing

In Text-to-SQL semantic parsing, selecting the correct entities (tables ...
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
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
02/18/2021

Semantic Parsing to Manipulate Relational Database For a Management System

Chatbots and AI assistants have claimed their importance in today life. ...
research
05/29/2018

You Say 'What', I Hear 'Where' and 'Why' --- (Mis-)Interpreting SQL to Derive Fine-Grained Provenance

SQL declaratively specifies what (not how) the desired output of a query...
research
09/12/2022

Optimising Fine-Grained Access Control Policy Enforcement for Database Queries. A Model-Driven Approach

Recently, we have proposed a model-driven approach for enforcing fine-gr...
research
04/12/2021

Learning to Synthesize Data for Semantic Parsing

Synthesizing data for semantic parsing has gained increasing attention r...

Please sign up or login with your details

Forgot password? Click here to reset