作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2009, Vol. 35 ›› Issue (9): 28-30. doi: 10.3969/j.issn.1000-3428.2009.09.010

• 软件技术与数据库 • 上一篇    下一篇

基于语言变量的关系数据库模糊查询

陈逸菲,叶小岭,张颖超   

  1. (南京信息工程大学信息与控制学院,南京 210044)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2009-05-05 发布日期:2009-05-05

Fuzzy Queries Based on Linguistic Variables in Relational Databases

CHEN Yi-fei, YE Xiao-ling, ZHANG Ying-chao   

  1. (College of Information and Control, Nanjing University of Information Sciences & Technology, Nanjing 210044)
  • Received:1900-01-01 Revised:1900-01-01 Online:2009-05-05 Published:2009-05-05

摘要: 在模糊理论的基础上,将权重概念引入关系数据库模糊查询中,以体现用户对查询中各个属性的相对重视程度。记录按匹配度的降序输出,方便用户选择。权重和匹配度都是语言变量,取值为语言值,更加贴近自然。采用模糊集合的alpha截集去模糊的思想,将带语言值权重的模糊查询条件转化为精确的SQL语句,利用RDBMS的机制进行记录的筛选,避免对整个数据库表的扫描,在一定程度上保证查询的效率。

关键词: 模糊查询, 语言变量, 权重

Abstract: The concept of weight is introduced in fuzzy queries based on theory of fuzzy set, which shows the relative importance that users pay to different attributes in query clauses. The records that satisfy queries are output according to the decrease of matching degrees, so users can select what they want more conveniently. Weights and matching degrees are linguistic variables, whose values are linguistic terms, and the queries become more flexible. The alpha-cut of fuzzy set is used to translate the linguistic fuzzy querying conditions into crisp SQL clauses. It is possible to make use of the mechanism of RDBMS to filter the records, which avoids scanning the whole table and assures the efficiency.

Key words: fuzzy queries, linguistic variables, weight

中图分类号: