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

Fuzzy Queries Based on Linguistic Variables in Relational Databases

作　　者：陈逸菲[1] 叶小岭[1] 张颖超[1] 

机构地区：[1]南京信息工程大学信息与控制学院,南京210044

出　　处：《计算机工程》2009年第9期28-30,共3页Computer Engineering

基　　金：江苏省"六大人才高峰"基金资助项目(06-A-07);南京信息工程大学科研基金资助项目(y644)

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

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

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]