Qualification of match results
AssigneeSap SE
InventorsMark Spiess, Jeffrey Woody, Ronald Dupey
Life of this patent
Estimating the term…
Abstract
Qualification of data matches can be improved relative to existing approaches by use of first, second, and third similarity criteria, which can be used to identify a set of near match record pairs, identify a set of actual match record pairs and to flag as near matches those record pairs of the set of near matches that were identified as actual matches, and to identify and flag one or more suspect matches.
Claims20
A computer program product comprising a non-transitory machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
- applying first similarity criteria to a set of record pairs to identify a set of near match record pairs, the applying comprising:
- identifying a pair of records in the set of record pairs as a near match record pair when:
- a similarity between the pair of records exceeds a minimum similarity threshold and when the pair of records is a name,
- the pair of records contains an email address comprising a domain name that is the same in the pair of records,
- the only difference between the pair of records is a numeric component,
- the pair of records match when the pair of records is translated to a same script, and
- adding, the near match record pair to the set of near match record pairs;
- applying, after identifying the set of near match record pairs, second similarity criteria to the set of near match record pairs to identify a set of actual match record pairs, the second similarity criteria being more strict than the first similarity criteria;
- flagging, as near matches, those record pairs of the set of near matches that were not identified as actual matches;
- applying, after identifying the set of actual match record pairs, third similarity criteria to the set of actual match record pairs to identify and flag one or more suspect matches, the third similarity criteria being more strict than the second similarity criteria;
- flagging, as a suspect match group, the set of actual match record pairs that contain the one or more suspect matches;
- and
- providing at least one of the flagged near matches, the flagged suspect matches, and the flagged suspect match group for further analysis.
A system comprising:
- computer hardware configured to provide operations comprising:
- applying first similarity criteria to a set of record pairs to identify a set of near match record pairs, the applying comprising:
- identifying a pair of records in the set of record pairs as a near match record pair when:
- a similarity between the pair of records exceeds a minimum similarity threshold and when the pair of records is a name,
- the pair of records contains an email address comprising a domain name that is the same in the pair of records,
- the only difference between the pair of records is a numeric component,
- the pair of records match when the pair of records is translated to a same script, and
- adding, the near match record pair to the set of near match record pairs;
- applying, after identifying the set of near match record pairs, second similarity criteria to the set of near match record pairs to identify a set of actual match record pairs, the second similarity criteria being more strict than the first similarity criteria;
- flagging, as near matches, those record pairs of the set of near matches that were not identified as actual matches;
- applying, after identifying the set of actual match record pairs, third similarity criteria to the set of actual match record pairs to identify and flag one or more suspect matches, the third similarity criteria being more strict than the second similarity criteria;
- flagging, as a suspect match group, the set of actual match record pairs that contain the one or more suspect matches;
- and
- providing at least one of the flagged near matches, the flagged suspect matches, and the flagged suspect match group for further analysis.
A computer-implemented method comprising:
- applying first similarity criteria to a set of record pairs to identify a set of near match record pairs, the applying comprising:
- identifying a pair of records in the set of record pairs as a near match record pair when:
- a similarity between the pair of records exceeds a minimum similarity threshold and when the pair of records is a name,
- the pair of records contains an email address comprising a domain name that is the same in the pair of records,
- the only difference between the pair of records is a numeric component,
- the pair of records match when the pair of records is translated to a same script, and
- adding, the near match record pair to the set of near match record pairs;
- applying, after identifying the set of near match record pairs, second similarity criteria to the set of near match record pairs to identify a set of actual match record pairs, the second similarity criteria being more strict than the first similarity criteria;
- flagging, as near matches, those record pairs of the set of near matches that were not identified as actual matches;
- applying, after identifying the set of actual match record pairs, third similarity criteria to the set of actual match record pairs to identify and flag one or more suspect matches, the third similarity criteria being more strict than the second similarity criteria;
- flagging, as a suspect match group, the set of actual match record pairs that contain the one or more suspect matches;
- and
- providing at least one of the flagged near matches, the flagged suspect matches, and the flagged suspect match group for further analysis.
Dependencies are inferred from the claim text.