sql中的模糊查询 [英] Fuzzy queries in sql

问题描述

嗨所有

i在sql中有一个模糊的问题

i使用商业智能的ssis

两个sql表作为源和目的地资源

目的地链接中有模糊查找和数据视图



现在

i想知道

如何在模糊查找转换中定义模糊规则

感谢您的回复



从中复制的其他信息评论如下

两张简单的桌子

表格1

 id，name，family 
 1，mo，vak 
 2，f，h 

表2

 id ，课程，分数
 1，phy，17 
 2，karol，20 

我想在模糊查找中定义样本规则

解决方案

模糊查找是一个很有趣的话题，有一整个数学领域，模糊逻辑，至少你需要了解一下： http://en.wikipedia.org/wiki/Fuzzy_logic [ ^ ]。



参见：http://en.wikipedia.org/wiki/Approximate_string_matching [ ^ ]。



有些值得深思：

http://www.lcc.uma.es/~ppgg/FSQL.html [ ^ ]，

http://msdn.microsoft.com/en-us/library/ms141764.aspx [ ^ ]，

< a href =http://technet.microsoft.com/en-us/library/ms3 45128％28v = sql.90％29.aspx> http://technet.microsoft.com/en-us/library/ms345128%28v=sql.90%29.aspx [ ^ ]，

http://decisivedata.net/blog/cleaning -messy-data-sql-part-1-fuzzy-matching-names [ ^ ]。

-SA

hi to all
i have a question a bout fuzzy in sql
i used a ssis with business intelligence
two sql tables as source and destination resource
with fuzzy lookup and data view in destination link

and now
i want to know
how to define fuzzy rules in fuzzy lookup transform
thanks for your replies

additional information copied from comment below
two simple tables
table 1

id , name , family 
1  ,  mo  ,  vak
2  ,  f   ,   h 

table 2

id , lesson , score
1  ,  phy   ,  17
2  , karol  ,  20

and i want to define sample rules in fuzzy lookup

解决方案

Fuzzy look-up is a big interesting topic, and there is a whole field of mathematics, fuzzy logic, you need to understand at least in general: http://en.wikipedia.org/wiki/Fuzzy_logic[^].

See also: http://en.wikipedia.org/wiki/Approximate_string_matching[^].

Some food for thought:
http://www.lcc.uma.es/~ppgg/FSQL.html[^],
http://msdn.microsoft.com/en-us/library/ms141764.aspx[^],
http://technet.microsoft.com/en-us/library/ms345128%28v=sql.90%29.aspx[^],
http://decisivedata.net/blog/cleaning-messy-data-sql-part-1-fuzzy-matching-names[^].

—SA

这篇关于sql中的模糊查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！