东北大学学报（自然科学版）

东北大学学报(自然科学版) ›› 2009, Vol. 30 ›› Issue (3): 349-353.DOI: -

• 论著 • 上一篇    下一篇

一种基于知识的关系数据库模糊查询方法

孟祥福;马宗民;严丽;张霄雁;   

  1. 东北大学信息科学与工程学院;
  • 收稿日期:2013-06-22 修回日期:2013-06-22 出版日期:2009-03-15 发布日期:2013-06-22
  • 通讯作者: Meng, X.-F.
  • 作者简介:-
  • 基金资助:
    教育部新世纪优秀人才支持计划项目(NCET-05-0288)

Knowledge-based approach to fuzzy querying over relational database

Meng, Xiang-Fu (1); Ma, Zong-Min (1); Yan, Li (1); Zhang, Xiao-Yan (1)   

  1. (1) School of Information Science and Engineering, Northeastern University, Shenyang 110004, China
  • Received:2013-06-22 Revised:2013-06-22 Online:2009-03-15 Published:2013-06-22
  • Contact: Meng, X.-F.
  • About author:-
  • Supported by:
    -

RichHTML

0

PDF (PC)

646

摘要： 在数据库查询中,针对传统DBMS不支持模糊查询的弱点,提出了基于知识的数据库模糊查询转换方法.以模糊集理论为基础,介绍了数据库模糊查询条件的构成形式,并提出利用隶属函数、领域知识和模糊集的α-截集运算相结合的方法实现模糊查询转换,模糊查询条件的转换和扩展考虑了查询条件的重要程度和用户偏好.该方法无需改变传统SQL语言或数据库引擎就能够实现模糊查询,提高了用户与系统之间的交互能力.

关键词: 关系数据库, 模糊查询, 模糊集, 领域知识, 排序

Abstract: A new knowledge-based approach to fuzzy query translation for a database is proposed to overcome the shortcoming of conventional DBMS (database management system) that does not support the fuzzy queries over any of databases. Based on the theory of fuzzy sets, the formation conditions for fuzzy queries over database are described. Then an approach is presented to leverage the membership functions, domain knowledge and α-cut operation of fuzzy numbers for fuzzy query translation. The importance of query criteria and users' preferences are taken into consideration when a fuzzy query is expanded and translated. Neither SQL language nor the database engine requires modification to implement fuzzy queries by the approach proposed, thus enabling users to improve their interaction with the system.

中图分类号: