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 条
  • [1] 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
  • [2] Flight Schedule Query System based on Natural Language Processing
    Mohamad-Hamza, MAB
    Ahmad, AM
    2002 STUDENT CONFERENCE ON RESEARCH AND DEVELOPMENT, PROCEEDINGS: GLOBALIZING RESEARCH AND DEVELOPMENT IN ELECTRICAL AND ELECTRONICS ENGINEERING, 2002, : 80 - 82
  • [3] RULE-BASED INFERENCE SYSTEM FOR NATURAL LANGUAGE DATABASE QUERY.
    Mark, William S.
    Research Publication - General Motors Research Laboratories, 1980, (GMR-3290):
  • [4] DESIGNING A PORTABLE NATURAL-LANGUAGE DATABASE QUERY SYSTEM
    KAPLAN, SJ
    ACM TRANSACTIONS ON DATABASE SYSTEMS, 1984, 9 (01): : 1 - 19
  • [5] INTERACTIVE DOCUMENT RETRIEVAL SYSTEM BASED-ON NATURAL LANGUAGE QUERY PROCESSING
    Dang Tuan Nguyen
    PROCEEDINGS OF 2009 INTERNATIONAL CONFERENCE ON MACHINE LEARNING AND CYBERNETICS, VOLS 1-6, 2009, : 2233 - 2237
  • [6] Automated Knowledge Provider System with Natural Language Query Processing
    Mukherjee, Prasenjit
    Chakraborty, Baisakhi
    IETE TECHNICAL REVIEW, 2016, 33 (05) : 525 - 538
  • [7] Edgebase: A Cooperative Query Answering Database System With A Natural Language Interface
    Sowah, Edmund
    Xu, Jianqiu
    2018 INTERNATIONAL CONFERENCE ON ALGORITHMS, COMPUTING AND ARTIFICIAL INTELLIGENCE (ACAI 2018), 2018,
  • [8] A method for processing the natural language query in ontology-based image retrieval system
    Hwang, Myunggwon
    Kong, Hyunjang
    Baek, Sunkyoung
    Kim, Pankoo
    ADAPTIVE MULTIMEDIA RETRIEVAL: USER, CONTEXT, AND FEEDBACK, 2007, 4398 : 1 - +
  • [9] Research on the Query Condition of Natural Language in Database
    Zheng Fengbin
    Zheng Shanshan
    Ge Qiang
    ICCSE 2008: PROCEEDINGS OF THE THIRD INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE & EDUCATION, 2008, : 389 - 393
  • [10] Extending Montague semantics for use in natural-language database-query processing
    Roy, M
    Frost, R
    ADVANCES IN ARTIFICIAL INTELLIGENCE, 2004, 3060 : 567 - 568