是否可以在没有 SSIS 的情况下执行 T-SQL 模糊查找? [英] Is it possible to perform T-SQL fuzzy lookup without SSIS?

问题描述

SSIS 2005/2008 进行模糊查找和分组.T-SQL 中是否有相同的功能?

SSIS 2005/2008 does fuzzy lookups and groupings. Is there a feature that does the same in T-SQL?

推荐答案

模糊查找使用 q-gram 方法，通过将字符串分解为微小的子字符串并对其进行索引.然后，您可以通过将其分解为相同大小的字符串来搜索输入.您可以检查其索引的格式并编写一个 CLR 函数以使用相同样式的索引，但您可能会讨论大量工作.

Fuzzy lookup uses a q-gram approach, by breaking strings up into tiny sub-strings and indexing them. You can then then search input by breaking it up into equally sized strings. You can inspect the format of their index and write a CLR function to use the same style of index but you might be talking about a fair chunk of work.

他们是如何做到的，这实际上非常有趣，非常简单，但提供了非常强大的匹配并且非常可配置.

It is actually quite interesting how they did it, very simple yet provides very robust matching and is very configurable.

我记得上次查看索引时，每个 q-gram 或子字符串都存储在表中的一行中(索引).该行包含一个 nvarchar 列(以及其他值)，用作二进制数据并包含对匹配行的引用.

From that I recall of the index when I last looked at it, each q-gram or substring is stored in a row in an table (the index). That row contains an nvarchar column (among other values) that is used as binary data and contains references to the rows that match.

还有关于 Microsoft Connect 的公开反馈建议对于此功能.

There is also an open feedback suggestion on Microsoft Connect for this feature.

这篇关于是否可以在没有 SSIS 的情况下执行 T-SQL 模糊查找?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！