Method and system for linking and delinking data records

• US 9,015,171 B2
• Filed: 12/14/2009
• Issued: 04/21/2015
• Est. Priority Date: 02/04/2003
• Status: Active Grant

• Current Assignee: LexisNexis Risk Data Management, Inc. (RELX PLC)
• Original Assignee: Lexisnexis Risk Management Inc. (RELX PLC)
• Inventors: Bayliss, David
• Primary Examiner(s): Mofiz, Apu
• Assistant Examiner(s): DAYE, CHELCIE L
• Application Number:
  US12/637,286
• Publication Number:
  US 20100094910A1
• Time in Patent Office: 1,954 Days
• Field of Search: 707/737, 707/749, 707/803
• US Class Current: 707/749
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

Exemplary systems and methods for linking entity references to entities and identifying associations between entities are presented. In particular, a method for delinking one or more entity references linked to a same entity is provided, where the one or more entity references have at least one common data field. The method comprises the steps of evaluating at least one actual measurement of the entity based at least in part on one or more field values of the one or more entity references, determining a difference between the at least one actual measurement and at least one predefined measurement associated with the entity and delinking the one or more entity references based at least in part on a comparison of the difference and a defined threshold.

Claims

1. A computer implemented method for breaking links between a plurality of entity references, each respective entity reference from the plurality of entity references comprising at least one data field in common with all other entity references from the plurality of entity references and being associated with a same Definitive Identifier (DID) as all other entity references from the plurality of entity references, the method comprising:

determining, by a processor, for each respective data field from the at least one data field in common between the entity references from the plurality of entity references, a variance of field values among entity references from the plurality of entity references; and

responsive to determining, for a first data field from the at least one data field in common, that the respective variance of field values exceeds a predetermined threshold associated with the first data field, disassociating the DID in common from each entity reference from the plurality of entity references.

2. The method of claim 1, further comprising, responsive to the determining that the respective variance of field values exceeds the predetermined threshold, associating a first indicator with each entity reference from the plurality of entity references, the first indicator indicating the associated entity reference has been disassociated from a DID in common with other entity references.

3. The method of claim 2, further comprising, responsive to determining that a first entity reference from the plurality of entity references is already associated with the first indicator, associating a second indicator with the first entity reference, the second indicator indicating that the first entity reference is prone to being incorrectly associated.

4. The method of claim 1, wherein the at least one common data field includes one or more of:

a first name field;

a last name field;

a date-of-birth field;

an address field; and

a social security number field.

5. The method of claim 1, wherein the plurality of entity references are at least part of one or more databases.

6. The method of claim 5, wherein the one or more databases includes one of a group consisting of:

a medical records database;

a criminal records database;

a motor vehicles registration database;

a voters registration database;

a Uniform Commercial Code flings database;

a corporations filing database;

a Federal Aviations Administration database;

a credit report database;

an immigrations database;

a bankruptcy filings database;

a property deeds database; and

a directory assistance database.

7. The method of claim 1, wherein the determining the variance of field values is based on application of a distribution curve.

8. The method of claim 1, wherein the predetermined threshold associated with the first data field is based on an entity type of at least one of the entity references from the plurality of entity references.

9. The method of claim 1, wherein the determining the variance is based on an entity type of at least one of the entity references from the plurality of entity references.

10. The method as in claim 3, further comprising, responsive to associating the second indicator with the first entity reference, adjusting a weighting used in determining a match between the first entity reference and a second entity reference.

11. The method of claim 1, wherein each respective entity reference from the plurality of entity references is associated with a unique Reference Identifier (RID), and disassociating the DID in common from each respective entity reference from the plurality of entity references comprises associating the respective entity reference with the respective associated RID.

12. The method of claim 1, wherein disassociating the DID in common from each respective entity reference from the plurality of entity references comprises associating a first entity reference with a first DID, and a second entity reference from the plurality of entity references with a second DID, wherein entity references associated with the first DID are prevented from linking to entity references associated with the second DID.

13. A computer implemented method for breaking links between a plurality of entity references, each respective entity reference from the plurality of entity references comprising a data field in common with all other entity references from the plurality of entity references and being associated with a same Definitive Identifier (DID) as all other entity references from the plurality of entity references, the method comprising:

determining, by a processor, for the data field in common, a variance of field values among entity references from the plurality of entity references; and

responsive to determining that the variance of field values exceeds a predetermined threshold associated with the data field in common;

disassociating the DID in common from each entity reference from the plurality of entity references;

for a first subset of entity references from the plurality of entity references not already associated with a first indicator, associating each of the first subset of entity references with the first indicator, wherein the first indicator indicates that an associated entity reference has been dissociated from a DID in common with other entity references; and

for a second subset of entity references already associated with the first indicator, associating each of the second subset of entity references with the second indicator, wherein the second indicator indicates than an associated entity reference is prone to being incorrectly associated.

14. The method of claim 13, each reference from the second subset of entity references from the plurality of entity references being associated with the common DID based on a first application of a matching algorithm applied with a first weighting, the method further comprising, adjusting the matching algorithm to use a second stricter weighting on a subsequent application of the matching algorithm to an entity reference from the second subset of entity references based on the entity reference from the second subset being associated with the second indicator.

15. The method of claim 13, wherein each respective entity reference from the plurality of entity references is associated with a unique Reference Identifier (RID), and disassociating the DID in common from each respective entity reference from the plurality of entity references comprises associating the respective entity reference with the respective associated RID.