Field-embedded database query system based on natural language processing

被引:0
|
作者
Long, Fei [1 ,2 ]
机构
[1] Harbin Univ Commerce, Foreign Language Sch, Harbin 150028, Heilongjiang, Peoples R China
[2] Beijing Foreign Studies Univ, Artificial Intelligence & Human Languages Lab, Beijing 10089, Peoples R China
关键词
field embedded database; query system; natural language processing; NLP; structured query language; SQL;
D O I
10.1504/IJES.2023.141925
中图分类号
TP3 [计算技术、计算机技术];
学科分类号
0812 ;
摘要
This research seeks to develop a paradigm that will improve user-database interaction. To convert the user's queries into structured query language (SQL), natural language processing (NLP) is needed, and then the SQL can be processed quickly by the query system in the embedded database. The primary goal of NLP is to facilitate human-computer interaction with little reliance on programming knowledge. To access the data efficiently, field embedded database query system (FEDQS) uses NLP to take in 2880 structured queries about train prices and seat availability from the train reservation database and turn them into a SQL query. Therefore, field embedded database query system (FEDQS) is suggested in this research to help the users access the data efficiently. The simulation findings show that the proposed method achieves a translation accuracy of 92%, precision of 91%, RMSE of 7%, and MAE of 9%.
引用
收藏
页码:331 / 342
页数:13
相关论文
共 50 条
  • [31] QUERY PROCESSING IN A RELATIONAL DATABASE MANAGEMENT SYSTEM.
    Youssefi, Karel
    Wong, Eugene
    Journal of the New England Water Pollution Control Association, 1979, : 409 - 417
  • [32] A collaborative query processing method for a database broadcasting system
    Kashita, M
    Terada, T
    Hara, T
    Tsukamoto, M
    Nishio, S
    PROCEEDINGS OF THE IASTED INTERNATIONAL CONFERENCE ON COMMUNICATIONS, INTERNET, AND INFORMATION TECHNOLOGY, 2002, : 60 - 66
  • [33] Explicit Knowledge Database Interface Model System Based on Natural Language Processing Techniques and Immersive Technologies
    Alfaro, Luis
    Rivera, Claudia
    Herrera, Jose
    Arroyo, Antonio
    Delgado, Lucy
    Castaneda, Elisa
    INTERNATIONAL JOURNAL OF ADVANCED COMPUTER SCIENCE AND APPLICATIONS, 2023, 14 (11) : 1261 - 1270
  • [34] Natural Language Database Interface for the Community Based Monitoring System
    Garcia, Krissanne Kaye
    Lumain, Ma Angelica
    Wong, Jose Antonio
    Yap, Jhovee Gerard
    Cheng, Charibeth
    PACLIC 22: PROCEEDINGS OF THE 22ND PACIFIC ASIA CONFERENCE ON LANGUAGE, INFORMATION AND COMPUTATION, 2008, : 384 - 390
  • [35] A HYPERTERM SYSTEM BASED ON NATURAL-LANGUAGE PROCESSING
    RUGE, G
    SCHWARZ, C
    THURMAIR, G
    INTERNATIONAL FORUM ON INFORMATION AND DOCUMENTATION, 1990, 15 (03): : 3 - 8
  • [36] A Natural Language Interface to a Database System
    Panja, Arup
    Reddy, Rami
    Reddy, Nandi
    Bandyopadhyay, Sivaji
    JOURNAL OF INTELLIGENT SYSTEMS, 2007, 16 (04) : 359 - 372
  • [37] Intelligent SPARQL Query Generation for Natural Language Processing Systems
    Chen, Yi-Hui
    Lu, Eric Jui-Lin
    Ou, Ting-An
    IEEE ACCESS, 2021, 9 : 158638 - 158650
  • [38] A Survey of Natural Language Processing Implementation for Data Query Systems
    Wong, Albert
    Joiner, Dakota
    Chiu, Chunyin
    Elsayed, Mohamed
    Pereira, Keegan
    Khmelevsky, Youry
    Mahony, Joe
    IEEE INTERNATIONAL CONFERENCE ON RECENT ADVANCES IN SYSTEMS SCIENCE AND ENGINEERING (IEEE RASSE 2021), 2021,
  • [39] 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
  • [40] Ontology based query processing in database management systems
    Ben Necib, C
    Freytag, JC
    ON THE MOVE TO MEANINGFUL INTERNET SYSTEMS 2003: COOPIS, DOA, AND ODBASE, 2003, 2888 : 839 - 857