SAS Quality Knowledge Base for Contact Information 27
E-mail (with Combinations) | |||
---|---|---|---|
Description |
The E-mail (with Combinations) match definition generates match codes which can be used to cluster records containing e-mail addresses. This definition generates one or more match codes for each input string with a score for each match code. Mailboxes are matched aggressively at certain weights and sensitivities noted in the examples. The types of matches produced by this definition include, but are not limited to, those shown below. Delimiter characters are hyphen, underscore, and period. The delimiters do not need to match as long as the rest of the conditions are satisfied. |
||
Max Length of Match Code | 54 characters | ||
Example 1 | Input | Cluster ID | Conditions |
info@dataflux.com | 0 |
Sensitivities Weight 100 |
|
info1@dataflux.com | 0 | ||
info2@dataflux.com | 0 | ||
Remarks | Single trailing digits in the mailbox do not affect the match. | ||
Example 2 | Input | Cluster ID | Conditions |
dave.wagner@acme.com | 1 |
Sensitivities Weight 100 |
|
wagner.dave@acme.com | 1 | ||
DaveWagner@acme.com | 1 | ||
WagnerDave@acme.com | 1 | ||
Remarks | As long as given and family names are delimited, they can occur in either order in the mailbox and still match. Casing can be used as a method of delimiting the names. | ||
Example 3 | Input | Cluster ID | Conditions |
john.doe@mailbox.com | 2 |
Sensitivities Weight 100 |
|
john.doe+spam_tracker@mailbox.com | 2 | ||
john.doe+spam_tracker_2@mailbox.com | 2 | ||
Remarks | An address tag (a sub-part of the mailbox delimited by the plus sign) does not affect the match. | ||
Example 4 | Input | Cluster ID | Conditions |
bepstein@acme.com | 3 |
Sensitivities Weight 25 |
|
epstein@acme.com | 3 | ||
Remarks | A letter preceding a family name in the mailbox does not affect the match. | ||
Example 5 | Input | Cluster ID | Conditions |
davidw@acme.com | 4 |
Sensitivities Weight 50 |
|
david@acme.com | 4 | ||
Remarks | A letter following a given name in the mailbox does not affect the match. | ||
Example 6 | Input | Cluster ID | Conditions |
br-epstein@acme.com | 5 |
Sensitivities Weight 75 |
|
brian.epstein@acme.com | 5 | ||
Remarks | Two letters will match a full given name starting with those two letters as long as they are delimited from the family name. | ||
Example 7 | Input | Cluster ID | Conditions |
b-epstein@acme.com | 6 |
Sensitivities Weight 50 |
|
brian.epstein@acme.com | 6 | ||
Remarks | One letter will match a full given name starting with that letter as long as they are delimited from the family name. | ||
Example 8 | Input | Cluster ID | Conditions |
dave-william.wagner@acme.com | 7 |
Sensitivities Weight 50 |
|
dave.c.wagner@acme.com | 7 | ||
dave_wagner@acme.com | 7 | ||
Remarks | Any delimited words between a given name and family name do not affect the match. | ||
Example 9 | Input | Cluster ID | Conditions |
dave-william.wagner@acme.com | 8 |
Sensitivities Weight 25 |
|
dave@acme.com | 8 | ||
Remarks | Any delimited words following a given name do not affect the match. | ||
Example 10 | Input | Cluster ID | Conditions |
andersen@acme.com | 9 |
Sensitivities Weight 25 |
|
n_rask_andersen@acme.com | 9 | ||
Remarks | Any delimited words preceding a family name do not affect the match. | ||
Example 11 | Input | Cluster ID | Conditions |
soon1923@lgphilips-lcd.com | 10 |
Sensitivities Weight 50 |
|
soon1g23@lgphilips-lcd.com | 10 | ||
Remarks | In otherwise identical mailboxes, the lowercase "G" matches the digit 9. | ||
Example 12 | Input | Cluster ID | Conditions |
soonl923@lgphilips-lcd.com | 11 |
Sensitivities Weight 50 |
|
soon1923@lgphilips-lcd.com | 11 | ||
Remarks | In otherwise identical mailboxes, the lowercase "L" matches the digit 1. | ||
Example 13 | Input | Cluster ID | Conditions |
abc1O23@lgphilips-lcd.com | 12 |
Sensitivities Weight 50 |
|
abc1o23@lgphilips-lcd.com | 12 | ||
abc1023@lgphilips-lcd.com | 12 | ||
Remarks | In otherwise identical mailboxes, the letter "O" matches the digit 0. | ||
Remarks |
The number of match codes generated for an input string depends on the content of the string. Each match code represents a combination of different parts of the input string; this enables two strings to be matched even when some parts of one or both of the strings differ. See the examples above for an illustration of clusters that may be produced using match codes generated by this definition. Note that a consequence of the generation of multiple match codes is that a record might be placed in more than one cluster by a subsequent clustering operation. Therefore, special attention should be given to the entity resolution process when using this definition. Generation of multiple match codes is achieved through the use of token-combination rules in the Match definition. Each match code generated by the definition is associated with one token-combination rule. There is a weight assigned to each rule; each rule's weight is used to calculate a score that is assigned to the match code that is generated by that rule. The score for a match code is equal to the weight of the rule used to generate the match code times the sensitivity that is selected when the definition is executed. When a record is clustered, the score for the record’s match code represents the confidence with which we can assert that the record belongs in the cluster. Note that when different rules lead to identical clustering results, the scores of the match codes generated by the different rules may be aggregated using the Cluster Aggregation node in a Data Job. The Cluster Aggregation node allows several different methods for aggregating match code scores, such as minimum, maximum, or mean across instances of a record, or minimum, maximum, or mean across all records in a cluster. For information on the Cluster Aggregation node, please refer to your DataFlux Data Management Studio documentation. |
Documentation Feedback: yourturn@sas.com |
Doc ID: QKBCI_GB_Match_E-mail-withCombinations.html |