计算机应用

• 数据库与知识工程(Database and knowledge • 上一篇    下一篇

关系数据库中分组查询的模糊扩展及去模糊机制

陈逸菲 张颖超 叶小岭   

  1. 南京信息工程大学信息与控制学院 南京信息工程大学信息与控制学院 南京信息工程大学信息与控制学院
  • 收稿日期:2007-11-17 修回日期:1900-01-01 发布日期:2008-05-01 出版日期:2008-05-01
  • 通讯作者: 陈逸菲

Extended fuzzy grouping queries in relational databases and derivation rules

Chen Yi-Fei Ying-Chao ZHANG Xiao-Ling YE   

  • Received:2007-11-17 Revised:1900-01-01 Online:2008-05-01 Published:2008-05-01
  • Contact: Chen Yi-Fei

摘要: 当前关系数据库模糊查询的研究中,涉及到分组查询having子句中的模糊条件或相对语言量词的较少。在模糊理论的基础上对having子句进行了模糊扩展,并利用模糊集合隶属函数的α截集将模糊的having子句转化为标准的SQL语句,因此可以利用RDBMS对记录进行筛选,保证了查询的效率。利用模糊集合基数的非模糊表示法来计算带量词的having语句,计算简单,结果简洁。

关键词: 模糊查询, 模糊集合, 基数, 分组查询

Abstract: There are few researches on fuzzy queries of relational databases involving the fuzzy conditions or relative linguistic quantifiers in "having" clause. Methods based on fuzzy set theory to these queries were presented here. The fuzzy conditions in "having" clause were translated to general SQL queries on the basis of-cut of membership function. Therefore, the tuples can be filtered by the RDBMS, which improves the efficiency of fuzzy queries. Nonfuzzy cardinality of fuzzy set was used to evaluate the quantified "having" clause, so the computation and the result became simple.

Key words: fuzzy queries, fuzzy set, cardinality, grouping queries