基于SQL Server 2000的通用模糊查询工具设计  

The Desfgn of A Fuzzy Querying Tool Based on SQL Server 2000

作　　者：陈逸菲[1] 张颖超[1] 叶小岭[1] CHEN Yi-fei,ZHANG Ying-chao,YE Xiao-ling （Department of Information and Communication, Nanjing University of Information Sciences ＆ Technology, Najing 210044,China）

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

出　　处：《电脑知识与技术》2007年第5期611-613,共3页Computer Knowledge and Technology

基　　金：南京信息工程大学校科研基金（y644）

摘　　要：本文设计并实现了一个基于SQL Server 2000的通用模糊查询工具,该工具可以把带权重的模糊查询转换为标准的SQL语句。用户可以对SQL Server中建立的任何数据库表进行模糊查询。系统提供了以下功能：定义模糊谓词及其隶属函数;定义模糊算子;构造带权重的模糊的、精确的或混合的查询语句,权重和阈值可以由用户给出。满足查询条件的记录将根据匹配度的降序输出。本系统的设计方法也可以推广到其他的数据库系统,如Oracle,Access等。A general fuzzy querying system is designed and realized in this paper, which acts as an additional interface on the top of Microsoft SQL Server 2000. Weighted fuzzy queries can be transformed into regular SQL queries in this system. Users may run fuzzy queries on any table built in SQL Server. This system provides functions as follows： fuzzy predicates, membership functions for numerical fields and the linguistic hedges can be defined by users; fuzzy queries, crisp queries or mixed queries can be built; the related weights and threshold can be assigned by users. The records satisfying the queries are output on the descending orders of matching degrees. The design of this system is also suit for other DBMS, such as Oracle, Access, etc.

关 键 词：模糊查询 权重 匹配度 

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