Transformer-Based Model for the Natural Language Textual Sequences to SQL-Queries Conversion

The concept of using natural language instead of SQL queries formed the basis of a new type of data processing called Natural Language Interface to Database (NLIDB). This paper considers a neural network (NN) approach for the NLIDB systems development. Its essence is the transformation of the input text sequence specified by the user in natural language into commands in SQL, which is inherent in text-to-SQL and sequence-to-sequence tasks. The Transformer model architecture of the NN was justified in the research. This architecture allows the NN to convert an input sequence (such as a natural language text query) into an output sequence (translated into SQL format text query). WikiSQL dataset was used for NN learning and testing. Numerous experiments were conducted in order to determine the optimal parameters of the NN model were conducted. Bilingual Evaluation Understanding (BLEU) metric was used as a metric for evaluating the quality of converting an input text sequence to SQL queries. The BLEU metric for the neural network model trained on the WikiSQL sample is 56%.

Authors

Institutions

Publication Details

Published
2024-10-16
DOI
https://doi.org/10.1109/csit65290.2024.10982609
Primary Topic
Topic Modeling
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Transformer-Based Model for the Natural Language Textual Sequences to SQL-Queries Conversion

Kateryna Yalova, Andrii Zhuravel
Topic Modeling
article

Transformer-Based Model for the Natural Language Textual Sequences to SQL-Queries Conversion

Kateryna Yalova, Andrii Zhuravel
article en

Abstract

The concept of using natural language instead of SQL queries formed the basis of a new type of data processing called Natural Language Interface to Database (NLIDB). This paper considers a neural network (NN) approach for the NLIDB systems development. Its essence is the transformation of the input text sequence specified by the user in natural language into commands in SQL, which is inherent in text-to-SQL and sequence-to-sequence tasks. The Transformer model architecture of the NN was justified in the research. This architecture allows the NN to convert an input sequence (such as a natural language text query) into an output sequence (translated into SQL format text query). WikiSQL dataset was used for NN learning and testing. Numerous experiments were conducted in order to determine the optimal parameters of the NN model were conducted. Bilingual Evaluation Understanding (BLEU) metric was used as a metric for evaluating the quality of converting an input text sequence to SQL queries. The BLEU metric for the neural network model trained on the WikiSQL sample is 56%.

University of Information Technology and Management in Rzeszow (PL), Dniprovsk State Technical University (UA)
Quality Education
Openalex Percentile: Top 73%
Topic Modeling
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.