模糊查找与模糊分组在批量数据合并中的应用

在对数据处理和分析中,模糊查找能通过模糊匹配得到在一定相似程度上的匹配结果,在一些情况下更加符合人的思维习惯。讨论了SSIS的模糊查找与模糊分组概念及功能,并将其应用于批量数据合并过程中由于录入数据拼写错误、截断、缺少或插入的标记、空字段、意外的缩略语和其他不规则,造成实际数据＂不够准确＂或＂有问题＂数据的处理上,实现问题数据的有效分类及复原。

The Application of Fuzzy Search and Fuzzy Grouping in Batch Data Merging

In data processing and analysis, fuzzy search is able to get the matching results to a certain extent through fuzzy matching. In some cases it is more suitable for mental habits of human. This article has discussed the concept and function of SSIS＇s fuzzy search and fuzzy grouping, and what＇s more applied them to achieve the efficient classification and recovery of problem data. As for the details of those problem data above, it causes actual data ＂ inaccurate＂ or ＂ problematic＂ which as a result of data spelling mistakes, cutoff and absence or insert tags, empty fields, acronyms and other irregular things.