TypeSQL: Knowledge-based Type-Aware Neural Text-to-SQL Generation

04/25/2018
by   Tao Yu, et al.
0

Interacting with relational databases through natural language helps users of any background easily query and analyze a vast amount of data. This requires a system that understands users' questions and converts them to SQL queries automatically. In this paper we present a novel approach, TypeSQL, which views this problem as a slot filling task. Additionally, TypeSQL utilizes type information to better understand rare entities and numbers in natural language questions. We test this idea on the WikiSQL dataset and outperform the prior state-of-the-art by 5.5 content of databases can significantly improve the performance when users' queries are not well-formed. TypeSQL gets 82.6 improvement compared to the previous content-sensitive model.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
10/19/2020

ColloQL: Robust Cross-Domain Text-to-SQL Over Search Queries

Translating natural language utterances to executable queries is a helpf...
research
11/09/2020

"What Do You Mean by That?" A Parser-Independent Interactive Approach for Enhancing Text-to-SQL

In Natural Language Interfaces to Databases systems, the text-to-SQL tec...
research
10/11/2020

Data Agnostic RoBERTa-based Natural Language to SQL Query Generation

Relational databases are among the most widely used architectures to sto...
research
01/24/2019

FANDA: A Novel Approach to Perform Follow-up Query Analysis

Recent work on Natural Language Interfaces to Databases (NLIDB) has attr...
research
10/16/2022

AskYourDB: An end-to-end system for querying and visualizing relational databases using natural language

Querying databases for the right information is a time consuming and err...
research
06/30/2023

Improved NL2SQL based on Multi-layer Expert Network

The Natural Language to SQL (NL2SQL) technique is used to convert natura...
research
02/04/2020

Using Positional Sequence Patterns to Estimate the Selectivity of SQL LIKE Queries

With the dramatic increase in the amount of the text-based data which co...

Please sign up or login with your details

Forgot password? Click here to reset