Natural Language to SQL Queries: A Review

Muhammad Shahzaib Baig; Azhar Imran; Aman Ullah Yasin; Abdul Haleem Butt; Muhammad Imran Khan

doi:10.33411/IJIST/2022040111

Author(s)

Muhammad Shahzaib Baig Department of Creative Technologies, Faculty of Computing & AI, Air University, Islamabad, Pakistan

Azhar Imran Department of Creative Technologies, Faculty of Computing & AI, Air University, Islamabad, Pakistan

Aman Ullah Yasin Department of Creative Technologies, Faculty of Computing & AI, Air University, Islamabad, Pakistan

Abdul Haleem Butt Department of Creative Technologies, Faculty of Computing & AI, Air University, Islamabad, Pakistan

Muhammad Imran Khan Department of Creative Technologies, Faculty of Computing & AI, Air University, Islamabad, Pakistan

Abstract

The relational database is the way of maintaining, storing, and accessing structured data but in order to access the data in that database the queries need to be translated in the format of SQL queries. Using natural language rather than SQL has introduced the advancement of a new kind of handling strategy called Natural Language Interface to Database frameworks (NLIDB). NLIDB is a stage towards the turn of events of clever data set frameworks (IDBS) to upgrade the clients in performing adaptable questioning in data sets. A model that can deduce relational database queries from natural language. Advanced neural algorithms synthesize the end-to-end SQL to text relation which results in the accuracy of 80% on the publicly available datasets. In this paper, we reviewed the existing framework and compared them based on the aggregation classifier, select column pointer, and the clause pointer. Furthermore, we discussed the role of semantic parsing and neural algorithm’s contribution in predicting the aggregation, column pointer, and clause pointer. In particular, people with limited background knowledge are unable to access databases with ease. Using natural language interfaces for relational databases is the solution to make natural language to SQL queries. This paper presents a review of the existing framework to process natural language to SQL queries and we will also cover some of the speech to SQL model in discussion section, in order to understand their framework and to highlight the limitations in the existing models.

Publication Details

Page(s) 147-162

DOI 10.33411/IJIST/2022040111

Published Journal: International Journal of Innovations in Science & Technology, Volume: 4, Issue: 1, Year: 2022

Request the full text from PASTIC

Keywords

natural language processing, Database Management System (DBMS)., Intelligent Database System (IDBS), Flexible Querying, Structured Query Language (SQL), Text to Relational database, Natural Language Interface for Databases (NLIDB)