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 条
  • [21] Converting Complex Natural Language Query to SQL Based on Tree Representation Model
    Zhao M.
    Chen K.
    Shou L.-D.
    Wu S.
    Chen G.
    Ruan Jian Xue Bao/Journal of Software, 2022, 33 (12): : 4727 - 4745
  • [22] Data Agnostic RoBERTa-based Natural Language to SQL Query Generation
    Pal, Debaditya
    Sharma, Harsh
    Chaudhuri, Kaustubh
    2021 6TH INTERNATIONAL CONFERENCE FOR CONVERGENCE IN TECHNOLOGY (I2CT), 2021,
  • [23] Natural Language Query Processing Framework for Biomedical Literature
    De Maio, Carmen
    Fenza, Giuseppe
    Loia, Vincenzo
    Parente, Mimmo
    PROCEEDINGS OF THE 2015 CONFERENCE OF THE INTERNATIONAL FUZZY SYSTEMS ASSOCIATION AND THE EUROPEAN SOCIETY FOR FUZZY LOGIC AND TECHNOLOGY, 2015, 89 : 1628 - 1635
  • [24] NATURAL LANGUAGE QUERY PROCESSING IN A TEMPORAL DATABASE.
    De, Suranjan
    Pan, Shuh-Shen
    Whinston, Andrew B.
    Data and Knowledge Engineering, 1985, 1 (01): : 3 - 15
  • [25] Query Processing: Beyond SQL and Relations
    Novikov, Boris
    ADVANCES IN DATABASES AND INFORMATION SYSTEMS, ADBIS 2015, 2015, 9282
  • [26] Natural Language Processing Technique for Generation of SQL Queries Dynamically
    Sanyal, Hrithik
    Shukla, Sagar
    Agrawal, Rajneesh
    2021 6TH INTERNATIONAL CONFERENCE FOR CONVERGENCE IN TECHNOLOGY (I2CT), 2021,
  • [27] A Naive approach: Translation of Natural Language to Structured Query Language
    Rautaray, Jyotirmayee
    Mishra, Pranati
    EAI ENDORSED TRANSACTIONS ON SCALABLE INFORMATION SYSTEMS, 2024, 11 (01)
  • [28] 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
  • [29] Indonesian Text Translator into Database Structured Query Language with Multi Parameters using Natural Language Processing
    Hermawan, G.
    Faturohman, I
    Isharmawan, N.
    2ND INTERNATIONAL CONFERENCE ON INFORMATICS, ENGINEERING, SCIENCE, AND TECHNOLOGY (INCITEST 2019), 2019, 662
  • [30] Generating textual emergency plans for unconventional emergencies-A natural language processing approach
    Ni, Weijian
    Shen, Quanle
    Liu, Tong
    Zeng, Qingtian
    Xu, Lingzhe
    SAFETY SCIENCE, 2023, 160