Processing of natural language queries to a relational database

被引:8
|
作者
Samsonova, M. [1 ]
Pisarev, A. [1 ]
Blagov, M. [1 ]
机构
[1] St Petersburg State Polytech Univ, St Petersburg 194064, Russia
关键词
natural language processing; relational databases; conceptual scheme; segmentation genes; D; melanogaster; query optimization;
D O I
10.1093/bioinformatics/btg1033
中图分类号
Q5 [生物化学];
学科分类号
071010 ; 081704 ;
摘要
Motivation: A new method is developed to query a relational database in natural language (NL). Results: The method, based on a semantic approach, interprets grammatical and lexical units of a natural language into concepts of subject domain, which are given in a conceptual scheme. The conceptual scheme is mapped formally onto the logical scheme. We applied the method to query the FlyEx database in natural language. FlyEx contains information on the expression of segmentation genes in Drosophila melanogaster. The method allows formulation of queries in various natural languages simultaneously, and is adaptive to changes in the knowledge domain and user's views. It provides optimal transformation of queries from natural language to SQL, as well as visualization of information as a hyperscheme. The method does not require specification of all possible language constructions as well as a standard grammar accuracy in formulation of NL queries.
引用
收藏
页码:i241 / i249
页数:9
相关论文
共 50 条
  • [1] A New Data Structure for Processing Natural Language Database Queries
    Frost, Richard A.
    Peelar, Shane
    [J]. WEBIST: PROCEEDINGS OF THE 15TH INTERNATIONAL CONFERENCE ON WEB INFORMATION SYSTEMS AND TECHNOLOGIES, 2019, : 80 - 87
  • [2] Natural Language Interface for Relational Database
    More, Priyanka
    Kudale, Bharti
    Deshmukh, Pranali
    [J]. PROCEEDING OF THE INTERNATIONAL CONFERENCE ON COMPUTER NETWORKS, BIG DATA AND IOT (ICCBI-2018), 2020, 31 : 499 - 505
  • [3] Natural Language for Database Queries: A Laboratory Study
    Vassiliou, Yannis
    Jarke, Matthias
    Stohr, Edward A.
    Turner, Jon A.
    White, Norman H.
    [J]. MIS QUARTERLY, 1983, 7 (04) : 47 - 61
  • [4] Understanding Natural Language Queries over Relational Databases
    Li, Fei
    Jagadish, H. V.
    [J]. SIGMOD RECORD, 2016, 45 (01) : 6 - 13
  • [5] Searching a Video Database using Natural Language Queries
    Shubha, M.
    Kapoor, Kritika
    Shrutiya, M.
    Mamatha, H. R.
    [J]. 2021 INTERNATIONAL CONFERENCE ON EMERGING SMART COMPUTING AND INFORMATICS (ESCI), 2021, : 190 - 196
  • [6] An efficient denotational semantics for natural language database queries
    Frost, Richard A.
    Fortier, Randy J.
    [J]. NATURAL LANGUAGE PROCESSING AND INFORMATION SYSTEMS, PROCEEDINGS, 2007, 4592 : 12 - +
  • [7] FINDING HEURISTICS FOR PROCESSING SELECTION QUERIES IN RELATIONAL DATABASE-SYSTEMS
    OZSU, MT
    MEECHAN, DJ
    [J]. INFORMATION SYSTEMS, 1990, 15 (03) : 359 - 373
  • [8] Grey Relational Analysis and Natural Language Processing to: Grey Language Processing
    Khuman, Arjab Singh
    Yang, Yingjie
    Liu, Sifeng
    [J]. JOURNAL OF GREY SYSTEM, 2016, 28 (01): : 88 - 97
  • [9] Grey Relational Analysis and Natural Language Processing
    Khuman, Arjab Singh
    Yang, Yingjie
    Liu, Sifeng
    [J]. PROCEEDINGS OF 2015 IEEE INTERNATIONAL CONFERENCE ON GREY SYSTEMS AND INTELLIGENT SERVICES (GSIS), 2015, : 107 - 112
  • [10] Natural Language Processing in Translation of Relational Languages
    Dudas, Adam
    Skrinarova, Jarmila
    [J]. IPSI BGD TRANSACTIONS ON INTERNET RESEARCH, 2023, 19 (01): : 17 - 23