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 条
  • [41] Research on the Retrieval of Ecological Environment Monitoring Database Based on Natural Language Processing
    Lang, Yongming
    Zhao, Weidong
    BASIC & CLINICAL PHARMACOLOGY & TOXICOLOGY, 2020, 127 : 175 - 175
  • [42] RULE-BASED OPTIMIZATION AND QUERY-PROCESSING IN AN EXTENSIBLE GEOMETRIC DATABASE SYSTEM
    BECKER, L
    GUTING, RH
    ACM TRANSACTIONS ON DATABASE SYSTEMS, 1992, 17 (02): : 247 - 303
  • [43] An Overview of the Deco System: Data Model and Query Language; Query Processing and Optimization
    Park, Hyunjung
    Pang, Richard
    Parameswaran, Aditya
    Garcia-Molina, Hector
    Polyzotis, Neoklis
    Widom, Jennifer
    SIGMOD RECORD, 2012, 41 (04) : 22 - 27
  • [44] Intelligent Database Flexible Querying System by Approximate Query Processing
    Tlili, Oussama
    Sassi Hidri, Minyar
    Ounelli, Habib
    DBKDA 2011: THE THIRD INTERNATIONAL CONFERENCE ON ADVANCES IN DATABASES, KNOWLEDGE, AND DATA APPLICATIONS, 2011, : 128 - 135
  • [45] A DATABASE-DOMAIN HIERARCHY-BASED TECHNIQUE FOR HANDLING UNKNOWN TERMS IN NATURAL-LANGUAGE DATABASE QUERY INTERFACES
    TRABELSI, Z
    KOTANI, Y
    TAKIGUCHI, N
    NISIMURA, H
    IEICE TRANSACTIONS ON INFORMATION AND SYSTEMS, 1993, E76D (06) : 668 - 679
  • [46] Natural Language Generation System for Knowledge Acquisition Based on Patent Database
    Rene, Antonio Oliveira Nzinga
    Okuhara, Koji
    Matsui, Takeshi
    JOURNAL OF ADVANCED COMPUTATIONAL INTELLIGENCE AND INTELLIGENT INFORMATICS, 2022, 26 (02) : 160 - 168
  • [47] Developing a portable natural language processing based phenotyping system
    Himanshu Sharma
    Chengsheng Mao
    Yizhen Zhang
    Haleh Vatani
    Liang Yao
    Yizhen Zhong
    Luke Rasmussen
    Guoqian Jiang
    Jyotishman Pathak
    Yuan Luo
    BMC Medical Informatics and Decision Making, 19
  • [48] Research on web monitoring system based on natural language processing
    Liu, L
    Fan, XZ
    Zhao, XP
    2003 INTERNATIONAL CONFERENCE ON NATURAL LANGUAGE PROCESSING AND KNOWLEDGE ENGINEERING, PROCEEDINGS, 2003, : 746 - 751
  • [49] Developing a portable natural language processing based phenotyping system
    Sharma, Himanshu
    Mao, Chengsheng
    Zhang, Yizhen
    Vatani, Haleh
    Yao, Liang
    Zhong, Yizhen
    Rasmussen, Luke
    Jiang, Guoqian
    Pathak, Jyotishman
    Luo, Yuan
    BMC MEDICAL INFORMATICS AND DECISION MAKING, 2019, 19 (Suppl 3)
  • [50] Design of English translation system based on natural language processing
    Chen, Shunjiang
    BASIC & CLINICAL PHARMACOLOGY & TOXICOLOGY, 2019, 125 : 208 - 209