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.
Highlights
I N today’s digital world, most of the data in the world are stored in relational databases for critical applications
Natural Language Interface to Database (NLIDB) were built based on the handcrafted rules, grammar and integrated techniques and methods from NLP (Natural Language Processing) and data sciences, using machine learning merely as a supportive element
With the recent work that researchers had put in NLIDB with Deep learning, it became essential to cover the scope, ideas, and challenges related to technical aspects
Summary
SHANZA ABBAS1, MUHAMMAD UMAIR KHAN2, SCOTT UK-JIN LEE3, (Member, IEEE), ASAD ABBAS4 And ALI KASHIF BASHIR5,(Senior Member, IEEE).
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have