Research on Chinese Natural Language Query Interface to Database Based on Syntax and Semantic

Abstract

The query of database must rely on professional query language, which is difficult to grasp for ordinary users. Natural language query interface (NLQI) can be applied to solve this problem with better human-computer interaction and intelligence. However, current natural language understanding technology is not mature. Though the query sentences’ structure is fixed, it is also difficult to accurately convert query sentences into understandable database query language for computer. Therefore a method of designing NLQI based on syntax and semantic analysis is proposed in this paper. First of all, Maximum forward and maximum reverse matching algorithms are used to analyse sentence by part of speech (POS) template, which is able to demonstrate the syntax relationship among the words. After syntax analysis, query conditions and targets are identified. Then, single conditions and targets are analyzed to relative standard forms by the relationship among entity, property, connect verb and unit. At last, these standard forms are transformed to SQL sentence. Regarding printing ERP system as experimental subject, experiment is done in this paper. The result shows that the method proposed in this paper can meet the needs of natural language query, and has a good transform effect for combination, omitting and other complex sentences.

ONLI: An ontology-based system for querying DBpedia using natural language paradigm

“…This advantage is supported by the integration of more NLP techniques that allow obtaining more semantic information from the question. Some approaches (Franconi et al, 2014;Li, Li, & Ning, 2015;Shah et al, 2013) parse the question in order to find direct relations among original words contained in the user's question and the vocabulary or elements of the data source. When a question's word is not matched, they point out which word is not recognized and ask the user for information.…”

Method and Apparatus for Querying Relational and XML Database Using French Language

“…For this, the majority of existing ILNBDs respond to requests written in English. However, other ILNBDs are proposed to access the information stored in a database via the formulation of requests in other languages, such as Spanish [9] Urdu [10], Chinese [11,12] and Hindi [13,14] languages.…”