e-space
Manchester Metropolitan University's Research Repository

    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 logoORCID: 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

    [img]
    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.

    Impact and Reach

    Statistics

    Activity Overview
    6 month trend
    278Downloads
    6 month trend
    111Hits

    Additional statistics for this dataset are available via IRStats2.

    Altmetric

    Repository staff only

    Edit record Edit record