DBTagger: Multi-Task Learning for Keyword Mapping in NLIDBs Using Bi-Directional Recurrent Neural Networks

01/11/2021
by   Arif Usta, et al.
0

Translating Natural Language Queries (NLQs) to Structured Query Language (SQL) in interfaces deployed in relational databases is a challenging task, which has been widely studied in database community recently. Conventional rule based systems utilize series of solutions as a pipeline to deal with each step of this task, namely stop word filtering, tokenization, stemming/lemmatization, parsing, tagging, and translation. Recent works have mostly focused on the translation step overlooking the earlier steps by using ad-hoc solutions. In the pipeline, one of the most critical and challenging problems is keyword mapping; constructing a mapping between tokens in the query and relational database elements (tables, attributes, values, etc.). We define the keyword mapping problem as a sequence tagging problem, and propose a novel deep learning based supervised approach that utilizes POS tags of NLQs. Our proposed approach, called DBTagger (DataBase Tagger), is an end-to-end and schema independent solution, which makes it practical for various relational databases. We evaluate our approach on eight different datasets, and report new state-of-the-art accuracy results, 92.4% on the average. Our results also indicate that DBTagger is faster than its counterparts up to 10000 times and scalable for bigger databases.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
10/07/2022

xDBTagger: Explainable Natural Language Interface to Databases Using Keyword Mappings and Schema Graph

Translating natural language queries (NLQ) into structured query languag...
research
03/11/2022

Supporting Schema References in Keyword Queries over Relational Databases

Relational Keyword Search (R-KwS) systems enable naive/informal users to...
research
01/31/2019

Bridging the Semantic Gap with SQL Query Logs in Natural Language Interfaces to Databases

A critical challenge in constructing a natural language interface to dat...
research
10/02/2022

Towards a Complete Direct Mapping From Relational Databases To Property Graphs

It is increasingly common to find complex data represented through the g...
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/21/2019

A Comparative Survey of Recent Natural Language Interfaces for Databases

Over the last few years natural language interfaces (NLI) for databases ...
research
09/01/2021

Quantum-Inspired Keyword Search on Multi-Model Databases

With the rising applications implemented in different domains, it is ine...

Please sign up or login with your details

Forgot password? Click here to reset