Overview

• Uses powerful Probabilistic Data Matching Algorithms

• User friendly and cost effective

• Standalone (does not require the use of another application such as SAS or MS Access);

• High performance

• Links records from separate data sources or identifies duplicate records within a single data source

• Link from 2,000 to 4 million records (other commercial software often has lower record limits)

• Allows the creation of a Unique Identification Number for Individuals or Businesses

Algorithms

• Probabilistic & Deterministic data matching algorithms;

• NYSIIS and SOUNDEX phonetic algorithms;

• Advanced String Comparator functions (ensures that special phonetic matches such as Joan/Jean or Marie/Mary etc are not matched);

• Automatic Nick Name Translation;

• User Definable Linkage Variables and Linkage Weights;

• Optionally use Diagnosis fields as linkage fields (cancer registries);

• Value Specific Linkage Weights - i.e. the family name 'Smith' receives a lower weight than 'Felligi';

Data Sources

• Import data from a wide range of formats; Text Files, DBASE, FoxPro, MS Excel and MS Access;

• Import multiple files

• Import data from SQL Server, Oracle and other enterprise databases*

• UNIX text file conversion*

• Export data to Access, Text File, Excel and DBASE formats

Analysis

• Clerical Review facility for reviewing potential matches

• Matched Pairs Analyzer for reviewing pairs of matched records

• Data Quality Analyzer for the identification and analysis of data quality problems prior to data matching.

Data Cleansing & Standardization

Clean and correct data quality issues including:

• Address Standardization (English and French)

• Advanced Data Filtering

• Alpha and Numeric Corrections (e.g. Convert 0’s and 1’s to O’s and I’s)

• Business Name Standardization (English & French)

• Case Conversion (Upper, Lower, Proper)

• City & State Standardization

• Conversion of Accented Characters (European languages)

• Custom Field Recoding

• Derivation of Sex from name field (30,000+ names in library)

• Email Address Correction

• Field Truncation

• Field Concatenation

• Geocoding

• NYSIIS & SOUNDEX functions

• Removal of Spaces and Unwanted punctuation

• Splitting of Full Name into subcomponents