计算机科学 ›› 2010, Vol. 37 ›› Issue (6): 200-205.

• 数据库与数据挖掘 • 上一篇    下一篇

基于Ontology的数据库自然语言查询接口的研究

李虎,田金文,王缓缓,石勇   

  1. (华中科技大学图像识别与人工智能研究所 武汉430074);(三峡大学经济与管理学院 宜昌443002);(武汉通信指挥学院 武汉430070)
  • 出版日期:2018-12-01 发布日期:2018-12-01

Ontology-based Natural Language Interface to Relational Databases

LI Hu,TIAN Jin-wen,WANG Huan-huan,SHI Yong   

  • Online:2018-12-01 Published:2018-12-01

摘要: 提出了一种基于Ontology的关系数据库自然语言查询接口的系统模型及设计框架。采用WordNet作为基本数据库并在WordNet之上定义领域词库,可以提高语法分析的识别率;同时利用Ontlogly知识表达能力存储关系数据库概念模型,并对概论模型的内容进行扩充;另外对Ontology和WordNet的同义词集进行关联,可以提高语义的识别率。用户的输入查询语句通过语法分析、语义分析生成中间表达式语言DRS,然后通过模板技术转换成SQL,通过DBMS执行SQL并返回结果。实验证明,这种方案不但实用可行,而且通过逐步完善Ontology知识库的定义,可以大大提高查询的命中率;另外通过WordNet和Ontology定义领域词库和领域知识,提高了系统的可移植性。最后,所提供的方法可以很容易地移植到其他领域。

关键词: 本体,数据库自然语言查询接口,篇章表述结构,数据库管理系统,SQL, OWL

Abstract: This paper proposed an approach to creating an ontology-based natural language interface to relational databases which allows end-users to access and query information in database with a natural language. In order to strengthen the reliability and the user-friendliness of the system, our approach integrates WordNet as the base lexicon and ontology as the knowledge base of the semantic interpreter. The user inputs will be first translated into a syntax tree by syntax analysis and parsing, then it will be translated into an intermediate expression language DRS by the ontology-based semantic interpreter. The SQL generator transfers DRS expressions into SQL sentences by a template technictue. The DBMS executes SQL sentences and returns the final result.This paper presented the framework based on ontology technictues to implement portable NLIDBs that makes it easier to migrate from one domain to another. The prototype system and our experiments show that our approach has generated good results with excellent performance on common queries.

Key words: Ontology, NLIDBs, DRS, DBMS, SQL, OWL

No related articles found!
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!