Improved NL2SQL based on Multi-layer Expert Network

06/30/2023
by   Chenduo Hao, et al.
0

The Natural Language to SQL (NL2SQL) technique is used to convert natural language queries into executable SQL statements. Typically, slot-filling is employed as a classification method for multi-task cases to achieve this goal. However, slot-filling can result in inaccurate SQL statement generation due to negative migration issues arising from different classification tasks. To overcome this limitation, this study introduces a new approach called Multi-Layer Expert Generate SQL (MLEG-SQL), which utilizes a dedicated multi-task hierarchical network. The lower layer of the network extracts semantic features of natural language statements, while the upper layer builds a specialized expert system for handling specific classification tasks. This hierarchical approach mitigates performance degradation resulting from different task conflicts. The proposed method was evaluated on the WiKSQL dataset and was found to be effective in generating accurate SQL statements.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
06/30/2023

Feature Representation Learning for NL2SQL Generation Based on Coupling and Decoupling

The NL2SQL task involves parsing natural language statements into SQL qu...
research
04/07/2020

RYANSQL: Recursively Applying Sketch-based Slot Fillings for Complex Text-to-SQL in Cross-Domain Databases

Text-to-SQL is the problem of converting a user question into an SQL que...
research
12/19/2022

MIGA: A Unified Multi-task Generation Framework for Conversational Text-to-SQL

Conversational text-to-SQL is designed to translate multi-turn natural l...
research
12/18/2020

Mention Extraction and Linking for SQL Query Generation

On the WikiSQL benchmark, state-of-the-art text-to-SQL systems typically...
research
04/25/2018

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

Interacting with relational databases through natural language helps use...
research
09/10/2018

Learning to Generate Structured Queries from Natural Language with Indirect Supervision

Generating structured query language (SQL) from natural language is an e...
research
04/26/2023

The Internal State of an LLM Knows When its Lying

While Large Language Models (LLMs) have shown exceptional performance in...

Please sign up or login with your details

Forgot password? Click here to reset