Back to results
US 2014/0280274 A1Published application
Probabilistic record linking
AssigneeTeradata US, Inc.
InventorsAnand Louis, Shashank Saket
Life of this patent
Estimating the term…
Abstract
Probabilistic record linking methods and a system are provided. Selections are acquired; the selections identify the two data sources, column identifiers from each of the two data sources, pairs of column identifiers from each of the two data sources, a confidence values for matching each record associated with each pair. The selections are used to compare data housed in the two data sources. Based on the comparison, matched records and non matched records are identified from the two data sources.
Claims20
A method, comprising:
- mapping, by a processor, master column identifiers to target column identifiers, each mapping identifying a unique pair for a particular master column identifier to a particular target column identifier;
- acquiring, by the processor, a match confidence value and a no-match confidence value for each mapping pair;
- comparing, by the processor, each mapping pair with its corresponding master data in a master data source to target data in a target data source using each mapping pair's match confidence value and non-match confidence value;
- and
- generating, by the processor, matched records in a matched pool, non-matched records from the master data source in a non-matched pool, and potential matched records a potential matched pool based on the comparison.
2 more elements
A method, comprising:
- receiving, by a processor, selections from an interface, the selections for:
- two data sources, column identifiers, pairs of column identifiers, and confidence values for matching each record associated with the pairs;
- comparing, by the processor, records from the two data sources based on the selections;
- and
- providing, by the processor, to the interface a matched list of matched records and a non-matched list of non-matched records based on the comparison.
2 more elements
A system, comprising:
- a processor having a record linking module;
- and
- the record linking module, the record linking module operable to (i) execute on the processor;
- (ii) receive selections that identify:
- two databases, column identifiers from each of the two databases, pairs of column identifiers for each of the two databases, and confidence values for matching each pair;
- and (iii) compare the two databases based on the selections;
- and (iv) generate matching records and non matching records based on the comparison.
4 more elements
Dependencies are inferred from the claim text.