A Review of NLIDB With Deep Learning: Findings, Challenges and Open Issues

Citations

WEB OF SCIENCE

16
Citations

SCOPUS

28

초록

Relational databases are storage for a massive amount of data. Knowledge of structured query language is a prior requirement to access that data. That is not possible for all non-technical personals, leading to the need for a system that translates text to SQL query itself rather than the user. Text to SQL task is also crucial because of its economic and industrial value. Natural Language Interface to Database (NLIDB) is the system that supports the text-to-SQL task. Developing the NLIDB system is a long-standing problem. Previously they were built based on domain-specific ontologies via pipelining methods. Recently a rising variety of Deep learning ideas and techniques brought this area to the attention again. Now end to end Deep learning models is being proposed for the task. Some publicly available datasets are being used for experimentation of the contributions, making the comparison process convenient. In this paper, we review the current work, summarize the research trends, and highlight challenging issues of NLIDB with Deep learning models. We discussed the importance of datasets, prediction model approaches and open challenges. In addition, methods and techniques are also summarized, along with their influence on the overall structure and performance of NLIDB systems. This paper can help future researchers start having prior knowledge of findings and challenges in NLIDB with Deep learning approaches.

키워드

Deep learning; Structured Query Language; Databases; Task analysis; Pipelines; Machine translation; Electronic mail; Text to SQL; natural language processing; NLIDB; database; natural language; deep learning; structured language; NATURAL-LANGUAGE; QUERIES
제목
A Review of NLIDB With Deep Learning: Findings, Challenges and Open Issues
저자
Abbas, Shanza; Khan, Muhammad Umair; Lee, Scott Uk-Jin; Abbas, Asad; Bashir, Ali Kashif
DOI
10.1109/ACCESS.2022.3147586
발행일
2022-01
유형
Review
저널명
IEEE Access
권
10
페이지
14927 ~ 14945