ISQNL: Interpretable SQL Query Synthesizer from Natural Language Input

被引:0
|
作者
Phal, Shubham Milind [1 ]
Yatish, H. R. [1 ]
Hukkeri, Tanmay Sanjay [1 ]
Natarajan, Abhiram [1 ]
Gonchigar, Prathika [1 ]
Deepamala, N. [1 ]
机构
[1] RV Coll Engn, Comp Sci & Engn, Bangalore, Karnataka, India
关键词
SQL query; Natural Language query; Natural language processing; Tokenization parts of speech tagging; Wordnets; N Grams; Intent Recognition; Entity Recognition;
D O I
10.1145/3373477.3373478
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Databases serve as the forefront for most systems today. Structured query language (SQL) is used to access and manipulate the data stored in a relational database. However, most end users have limited knowledge of SQL and thus face difficulties in accessing such systems. In this paper we describe a novel system (ISQNL) to convert a query provided in Natural Language (English) to an SQL query. By applying several natural language processing techniques ISQNL achieves this conversion without the need for any elaborate schema specific training/modification during setup and is robust enough to handle dynamically changing database states or database schema. ISQNL has demonstrated remarkable accuracy in SQL query synthesis when tested on large sets of natural language input. This paper discusses the methodology and key challenges involved in building ISQNL.
引用
收藏
页数:6
相关论文
共 50 条
  • [1] Formation of SQL from Natural Language Query using NLP
    Uma, M.
    Sneha, V
    Sneha, G.
    Bhuvana, J.
    Bharathi, B.
    2019 SECOND INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE IN DATA SCIENCE (ICCIDS 2019), 2019,
  • [2] An Approach for Generating SQL Query Using Natural Language Processing
    More, Priyanka
    Kudale, Bharti
    Deshmukh, Pranali
    Biswas, Indira N.
    More, Neha J.
    Gomes, Francisco S.
    INTELLIGENT COMMUNICATION TECHNOLOGIES AND VIRTUAL MOBILE NETWORKS, ICICV 2019, 2020, 33 : 226 - 230
  • [3] Speech-to-SQL: toward speech-driven SQL query generation from natural language question
    Song, Yuanfeng
    Wong, Raymond Chi-Wing
    Zhao, Xuefang
    VLDB JOURNAL, 2024, 33 (04): : 1179 - 1201
  • [4] SQUARES : A SQL Synthesizer Using Query Reverse Engineering
    Orvalho, Pedro
    Terra-Neves, Miguel
    Ventura, Miguel
    Martins, Ruben
    Manquinho, Vasco
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2020, 13 (12): : 2853 - 2856
  • [5] Translating Controlled Natural Language Query into SQL Query using Pattern Matching Technique
    Kumar, Rajender
    Dua, Mohit
    2014 INTERNATIONAL CONFERENCE FOR CONVERGENCE OF TECHNOLOGY (I2CT), 2014,
  • [6] Natural Language Query to SQL conversion using Machine Learning Approach
    Arefin, Minhazul
    Hossen, Kazi Mojammel
    Uddin, Mohammed Nasir
    2021 3RD INTERNATIONAL CONFERENCE ON SUSTAINABLE TECHNOLOGIES FOR INDUSTRY 4.0 (STI), 2021,
  • [7] Natural Language Based SQL Query Verification Against Relational Schema
    Khan, Shoaib Saleem
    Saeed, Abid
    Majeed, Yasir
    Kamran, Muhammad
    INTELLIGENT TECHNOLOGIES AND APPLICATIONS, INTAP 2018, 2019, 932 : 391 - 400
  • [8] SPATIAL SQL - A QUERY AND PRESENTATION LANGUAGE
    EGENHOFER, MJ
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 1994, 6 (01) : 86 - 95
  • [9] Natural SQL: Making SQL Easier to Infer from Natural Language Specifications
    Gan, Yujian
    Chen, Xinyun
    Xie, Jinxia
    Purver, Matthew
    Woodward, John R.
    Drake, John
    Zhang, Qiaofu
    FINDINGS OF THE ASSOCIATION FOR COMPUTATIONAL LINGUISTICS, EMNLP 2021, 2021, : 2030 - 2042
  • [10] Enhancing Natural Language Query to SQL Query Generation Through Classification-Based Table Selection
    Chopra, Ankush
    Azam, Rauful
    ENGINEERING APPLICATIONS OF NEURAL NETWORKS, EANN 2024, 2024, 2141 : 152 - 165