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 条
  • [21] Use of Visual Query System in teaching database query language SQL
    Chen, PK
    Sheen, CY
    Chen, GD
    ADVANCED RESEARCH IN COMPUTERS AND COMMUNICATIONS IN EDUCATION, VOL 1: NEW HUMAN ABILITIES FOR THE NETWORKED SOCIETY, 1999, 55 : 800 - 807
  • [22] Query processing in DOQL: A deductive database language for the ODMG model
    Sampaio, PRF
    Paton, NW
    DATA & KNOWLEDGE ENGINEERING, 2000, 35 (01) : 1 - 38
  • [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] QUERY-PROCESSING TECHNIQUES IN THE SUMMARY-TABLE-BY-EXAMPLE DATABASE QUERY LANGUAGE
    OZSOYOGLU, G
    MATOS, V
    OZSOYOGLU, ZM
    ACM TRANSACTIONS ON DATABASE SYSTEMS, 1989, 14 (04): : 526 - 573
  • [25] Processing of natural language queries to a relational database
    Samsonova, M.
    Pisarev, A.
    Blagov, M.
    BIOINFORMATICS, 2003, 19 : i241 - i249
  • [26] Natural Language Processing Using Database Context
    Mincheva, Zheni
    Vasilev, Nikola
    Antonov, Anatoliy
    Nikolov, Ventsislav
    INTELLIGENT COMPUTING, VOL 2, 2022, 507 : 747 - 759
  • [27] Database Tuning using Natural Language Processing
    Trummer, Immanuel
    SIGMOD RECORD, 2021, 50 (03) : 27 - 28
  • [28] QUERY SYSTEM WITH NATURAL LANGUAGE CAPABILITY.
    Ham, A.N.
    Jerrams-Smith, J.
    Jones, N.J.L.
    Lloyd, P.R.
    Scott, D.R.
    Annual Review - Philips Research Laboratories, 1986, : 49 - 55
  • [29] Design and implementation of spatiotemporal database query processing system
    Kim, DH
    Ryu, KH
    Park, CH
    JOURNAL OF SYSTEMS AND SOFTWARE, 2002, 60 (01) : 37 - 49
  • [30] DISTRIBUTED QUERY-PROCESSING IN A MULTIPLE DATABASE SYSTEM
    CHEN, ALP
    BRILL, D
    TEMPLETON, M
    YU, CT
    IEEE JOURNAL ON SELECTED AREAS IN COMMUNICATIONS, 1989, 7 (03) : 390 - 398