An Approach for Generating SQL Query Using Natural Language Processing

被引:0
|
作者
More, Priyanka [1 ]
Kudale, Bharti [2 ]
Deshmukh, Pranali [1 ]
Biswas, Indira N. [1 ]
More, Neha J. [1 ]
Gomes, Francisco S. [1 ]
机构
[1] Genba Sopanrao Moze CoE, Informat Technol, Pune, Maharashtra, India
[2] Genba Sopanrao Moze CoE, Comp Engn, Pune, Maharashtra, India
关键词
Natural Language Processing; Tokenization; Tagging; Relational database; Semantic analysis; SQL query;
D O I
10.1007/978-3-030-28364-3_21
中图分类号
TP301 [理论、方法];
学科分类号
081202 ;
摘要
Today's databases of corporations are so huge, that they can only be approached by experienced programmers. Accessing data from a database usually needs notable skills such as knowledge of SQL; however, the most of us who interact with databases every day don't have that background. Hence it's an increase demand for non-technical user to be able to redeem data from databases without having to list SQL queries. And this problem is solved by using approach of Natural Language Processing. This research work presents an approach for querying system for natural language processing. Hence it will dramatically simplify the process of handling with large data and making data available for everyone.
引用
收藏
页码:226 / 230
页数:5
相关论文
共 50 条
  • [1] 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,
  • [2] 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,
  • [3] 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,
  • [4] ACL-SQL: Generating SQL Queries from Natural Language
    Kaoshik, Ronak
    Patil, Rohit
    Prakash, R.
    Agarawal, Shaurya
    Jain, Naman
    Singh, Mayank
    CODS-COMAD 2021: PROCEEDINGS OF THE 3RD ACM INDIA JOINT INTERNATIONAL CONFERENCE ON DATA SCIENCE & MANAGEMENT OF DATA (8TH ACM IKDD CODS & 26TH COMAD), 2021, : 423 - 423
  • [5] Enhancement of Natural Language to SQL Query Conversion using Machine Learning Techniques
    Prasad, Akshar
    Badhya, Sourabh S.
    Yashwanth, Y. S.
    Rohan, Shetty
    Shobha, G.
    Deepamala, N.
    INTERNATIONAL JOURNAL OF ADVANCED COMPUTER SCIENCE AND APPLICATIONS, 2020, 11 (12) : 494 - 503
  • [6] Using natural language processing in order to create SQL queries
    djahantighi, F. Siasar
    Norouzifard, M.
    Davarpanah, S. H.
    Shenassa, M. H.
    2008 INTERNATIONAL CONFERENCE ON COMPUTER AND COMMUNICATION ENGINEERING, VOLS 1-3, 2008, : 600 - +
  • [7] Astronomical Data Processing Using SciQL, an SQL Based Query Language for Array Data
    Zhang, Ying
    Scheers, Bart
    Kersten, Martin
    Ivanoya, Milena
    Nes, Niels
    ASTRONOMICAL DATA ANALYSIS SOFTWARE AND SYSTEMS XXI, 2012, 461 : 729 - 732
  • [8] Generating and Analyzing Chatbot Responses using Natural Language Processing
    Aleedy, Moneerh
    Shaiba, Hadil
    Bezbradica, Marija
    INTERNATIONAL JOURNAL OF ADVANCED COMPUTER SCIENCE AND APPLICATIONS, 2019, 10 (09) : 60 - 68
  • [9] An Approach for generating best possible questions from the given text using Natural Language Processing
    Vaidya, Kimaya
    Bhagwatkar, Neha
    Singh, Aditi
    Borikar, Sneha
    Padwad, Hirkani
    INTERNATIONAL JOURNAL OF NEXT-GENERATION COMPUTING, 2023, 14 (01): : 271 - 277
  • [10] Portraying the Water Crisis in Iranian Newspapers: An Approach Using Structure Query Language (SQL)
    Amiraslani, Farshad
    Dragovich, Deirdre
    WATER, 2021, 13 (06)