关系数据库上基于非数值属性关键词的模糊查询

关系数据库上的关键词查找技术使得用户像使用搜索引擎一样获取数据库中的相关数据.然而,这种技术只实现了精确查询,还不能很好地实现模糊查询.本文通过引进分类学习中的Rocchio算法并对其做小部分修改,用于数据库的关键词查询中,结合不同类型对象之间相异度和相关度的量化计算,每次返回的结果集按照相关度降序排列,实现精确到模糊的查询.如果用户不满意初始查询结果集,利用Rocchio算法经过几次交互,便可不断满足需求.对权值优化的Rocchio算法反馈过程进行了实验测试,结果证明是比较令用户满意的,而且返回的结果集中少量的不相关集合可以提高查询的性能.

Fuzzy Query Based on Non-numeric Attribute Keywords over Relational Databases

KSORD (keyword search over relational database) techniques allow users to obtain information from databases,which is just like using search engines. However,the advanced techniques only realize exact queries,but not for fuzzy queries. The Rocchio algorithm of learning classification is introduced which is made a little changed to achieve keyword search over relational databases. Connected with dissimilarity and correlation calculated,returned result sets are ranked in descendant order according to correlati...