A review of NLIDB with deep learning: findings, challenges and open issues

Abbas, Shanza, Khan, Muhammad Umair, Lee, Scott Uk-Jin, Abbas, Asad and Bashir, Ali Kashif ORCID: https://orcid.org/0000-0001-7595-2522 (2022) A review of NLIDB with deep learning: findings, challenges and open issues. IEEE Access, 10. pp. 14927-14945. ISSN 2169-3536

Preview

Published Version Available under License Creative Commons Attribution. Download (2MB) | Preview

Abstract

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.