System, method and software for providing persistent entity identification and linking entity information in an integrated data repository

• US 8,671,115 B2
• Filed: 07/11/2011
• Issued: 03/11/2014
• Est. Priority Date: 05/29/2003
• Status: Active Grant

• Current Assignee: Experian Marketing Solutions, LLC (Experian plc)
• Original Assignee: Experian Marketing Solutions Incorporated (Experian plc)
• Inventors: Skurtovich, John L. Jr., Barrios, Pamela, Sumida, Timothy
• Primary Examiner(s): THAI, HANH B
• Application Number:
  US13/180,028
• Publication Number:
  US 20120078932A1
• Time in Patent Office: 974 Days
• Field of Search: 707790-802
• US Class Current: 707/791
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/24 Querying
• CPC Class Codes: G06F 16/24553 of query operations
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

The present invention provides a system, method and software for linking persistent and unique business identifiers, associated with business entities, for associating corresponding business records without a loss of historical records, regardless of subsequent changes, updates, and mergers. In the various embodiments, a first business record, of the plurality of business records, is associated with a first business identifier; and a second business record, which does not match the first record, is associated with a second business identifier. Subsequently, when the first business identifier and the second business identifier are determined to correspond to a singular business entity, the first business identifier and the second business identifier are linked, and respective associations of the first business record and the second business record with the linked first business identifier and second business identifier are maintained, with corresponding source references, and collectively utilized in subsequent search and match determinations.

Claims

1. A computer-implemented method of creating a data structure stored in one or more data storage devices, wherein the data structure provides information to link records that are related to a same entity of a plurality of entities, for database searching and record matching operations, the method comprising:

(a) associating a first record, of a plurality of records, with a first identifier of a plurality of identifiers that identifies at least one entity of the plurality of entities, wherein each identifier is unique and persistent for a predetermined period of time;

(b) associating a second record, of the plurality of records, with a second identifier that identifies at least one entity of the plurality of entities;

(c) determining that the first identifier and the second identifier correspond to a same entity by determining that a third record, of the plurality of records, matches with a first element of a first plurality of elements of the first record and further matches with a second element of a second plurality of elements of the second record;

(d) determining a plurality of potentially matching records, and from the plurality of potentially matching records, eliminating a potentially matching record which does not sufficiently match a selected or predetermined element of the first, second or third records within a selected or predetermined confidence level;

(e) linking the first identifier and the second identifier in a data structure that references the first and second records without merging the first and second records under either the first or second identifiers and without merging the first and second identifiers;

(f) separately maintaining in at least one database information in the first record associated with the first identifier and information in the second record associated with the second identifier for the predetermined period of time;

(g) using the link between the first and second identifiers in the data structure, grouping and providing retrieved information that is separately maintained in both the first and second records in response to a request for information about the same entity; and

(h) collectively utilizing records associated with the linked first identifier and second identifier in subsequent search and match determinations.

2. The computer-implemented method of claim 1, wherein step (c) further comprises:

determining that the first identifier and the second identifier correspond to the same entity by determining that a third record, of the plurality of records, is associated with both the first record and the second record.

3. The computer-implemented method of claim 1, wherein the first plurality of elements and the second plurality of elements each comprise at least two elements selected from the group consisting of:

a name element, an address element, a tax identification element, a telephone number element, a standard industry code element, and a client key element.

4. The computer-implemented method of claim 1, further comprising:

determining the plurality of potentially matching records from the plurality of records, and from the plurality of potentially matching records, eliminating a potentially matching record which does not match a name element or a tax identification element of the third record.

5. The computer-implemented method of claim 4, further comprising:

from the plurality of potentially matching records, eliminating a potentially matching record which does not match an address element of the third record.

6. The computer-implemented method of claim 4, further comprising:

from the plurality of potentially matching records, eliminating a potentially matching record which does not match a standard industry code element of the third record.

7. The computer-implemented method of claim 4, further comprising:

following elimination of one or more potentially matching records from the plurality of potentially matching records, affirmatively matching the third record to the first element of the first plurality of elements of the first record, the first record remaining within the plurality of potentially matching records, and affirmatively matching the third record to the second element of the second plurality of elements of the second record, the second record remaining within the plurality of potentially matching records.

8. The computer-implemented method of claim 7, wherein a degree of affirmative matching is variable and has a corresponding confidence level.

9. The computer-implemented method of claim 1, wherein the plurality of entities comprises a plurality of persons, or a plurality of organizations, or a plurality of persons and organizations.

10. The computer-implemented method of claim 1, wherein step (a) further comprises:

associating the first record with the first identifier by matching the first record to another record associated with the first identifier, of the plurality of records.

11. The computer-implemented method of claim 1, wherein step (a) further comprises:

associating the first record with the first identifier by not matching to any other record of the plurality of records and assigning the first identifier to the first record as representative of a previously unidentified entity of the plurality of entities.

12. The computer-implemented method of claim 1, further comprising:

associating a plurality of addresses with the first identifier, each address of the plurality of addresses having a unique site identifier of a plurality of site identifiers associated with the first identifier.

13. The computer-implemented method of claim 1, further comprising:

associating a site identifier with the first identifier, the site identifier corresponding to an address associated with the first identifier.

14. The computer-implemented method of claim 1, further comprising:

prior to step (a), searching a consumer database for a match of the first record and, when no match is determined, searching a business database for a match of the first record.

15. A system for creating a data structure to link records that are related to a same entity of a plurality of entities, for data repository searching and for record matching operations, the system comprising:

one or more data storage devices to store the data repository having a plurality of records and a plurality of identifiers that identifies the plurality of entities, wherein each identifier is unique and persistent for a predetermined period of time; and

one or more processors coupled to the one or more data storage devices, the one or more processors to associate a first record of the plurality of records with a first identifier that identifies at least one entity of the plurality of entities;

to associate a second record of the plurality of records with a second identifier that identifies at least one entity of the plurality of entities;

to determine that the first identifier and the second identifier correspond to the same entity by determining that a third record, of the plurality of records, matches with a first element of a first plurality of elements of the first record and further matches with a second element of a second plurality of elements of the second record;

to determine a plurality of potentially matching records, and from the plurality of potentially matching records, to eliminate a potentially matching record which does not sufficiently match a selected or predetermined element of the first, second or third records within a selected or predetermined confidence level;

to link in the data repository the first identifier and the second identifier in a data structure that references the first and second records without merging the first and second records under either the first or second identifiers and without merging the first and second identifiers;

to separately maintain in the data repository information in the first record associated with the first identifier and information in the second record associated with the second identifier for the predetermined period of time; and

using the link between the first and second identifiers in the data structure, to retrieve and group information that is separately maintained in both the first and second records in response to a request for information about the same entity.

16. The system of claim 15, wherein the one or more processors are to collectively utilize the records associated with the linked first identifier and second identifier in subsequent search and match determinations.

17. The system of claim 15, wherein the one or more processors are to determine that the first identifier and the second identifier correspond to the same entity by determining that a third record, of the first or second pluralities of records, is associated with both the first record and the second record.

18. The system of claim 15, wherein the first plurality of elements and the second plurality of elements each comprise at least two elements selected from the group consisting of:

a name element, an address element, a tax identification element, a telephone number element, a standard industry code element, and a client key element.

19. The system of claim 15, wherein the one or more processors are to determine a plurality of potentially matching records, and from the plurality of potentially matching records, to eliminate a potentially matching record which does not match a name element or a tax identification element of the third record.

20. The system of claim 19, wherein the one or more processors are to eliminate, from the plurality of potentially matching records, a potentially matching record which does not match an address element of the third record.

21. The system of claim 19, wherein the one or more processors are to eliminate, from the plurality of potentially matching records, a potentially matching record which does not match a standard industry code element of the third record.

22. The system of claim 19, wherein following elimination of one or more potentially matching records from the plurality of potentially matching records, the one or more processors are to affirmatively match the third record to the first element of the first plurality of elements of the first record, the first record remaining within the plurality of potentially matching records, and to affirmatively match the third record to the second element of the second plurality of elements of the second record, the second record remaining within the plurality of potentially matching records.

23. The system of claim 22, wherein a degree of affirmative matching is variable and has a corresponding confidence level.

24. The system of claim 15, wherein the plurality of entities comprises a plurality of persons, or a plurality of organizations, or a plurality of persons and organizations.

25. The system of claim 15, wherein the one or more processors are to associate the first record with the first identifier by matching the first record to another record associated with the first identifier, of the plurality of records.

26. The system of claim 15, the one or more processors are to associate the first record with the first identifier by not matching the first record to any other record of the first plurality of records and to assign the first identifier to the first record as representative of a previously unidentified entity of the plurality of entities.

27. The system of claim 15, wherein the one or more processors are to associate a plurality of addresses with the first identifier, each address of the plurality of addresses having a unique site identifier of a plurality of site identifiers associated with the first identifier, and to maintain in the data repository the association of the plurality of addresses and corresponding plurality of site identifiers with the first identifier.

28. The system of claim 15, wherein the one or more processors are to associate a site identifier with the first identifier, the site identifier corresponding to an address associated with the first identifier, and to maintain in the data repository the association of the addresses and corresponding site identifier with the first identifier.

29. The system of claim 15, wherein the one or more processors are to search a consumer database for a match of the first record and, when no match is determined, to search a business database for a match of the first record.

30. A computer-readable medium storing computer-readable software for creating a data structure in a database stored in one or more data storage devices, wherein the data structure provides information to link records that are related to a same entity of a plurality of entities, for database searching and record matching operations, the computer-readable medium storing computer-readable software comprising:

a first program construct for associating a first record, of a plurality of records stored in the one or more data storage devices having the database, with a first identifier of a plurality of identifiers that identifies at least one entity of the plurality of entities, wherein each identifier is unique and persistent for a predetermined period of time;

a second program construct for associating a second record, of the plurality of records, with a second identifier that identifies at least one entity of the plurality of entities;

a third program construct for determining that the first identifier and the second identifier correspond to the same entity by determining that a third record, of the plurality of records, matches with a first element of a first plurality of elements of the first record and further matches with a second element of a second plurality of elements of the second record;

a fourth program construct for determining a plurality of potentially matching records, and from the plurality of potentially matching records, eliminating a potentially matching record which does not sufficiently match a selected or predetermiend element of the first, second or third records within a selected or predetermined confidence level;

a fifth program construct for linking the first identifier and the second identifier in a data structure that references the first and second records without merging the first and second records under either the first or second identifiers and without merging the first and second identifiers;

a sixth program construct for separately maintaining in the database information in the first record associated with the first identifier and information in the second record associated with the second identifier for the predetermined period of time;

a seventh program construct for using the link between the first and second identifiers in the data structure and grouping and providing retrieved information that is separately maintained in both the first and second records in response to a request for information about the same entity;

an eighth program construct for collectively utilizing records associated with the linked first identifier and second identifier in subsequent search and match determinations.

31. The computer-readable medium storing computer-readable software of claim 30, wherein the plurality of entities comprises a plurality of persons, or a plurality of organizations, or a plurality of persons and organizations.

32. The computer-readable medium storing computer-readable software of claim 30, wherein the first plurality of elements and the second plurality of elements each comprise at least two elements selected from the group consisting of:

a name element, an address element, a tax identification element, a telephone number element, a standard industry code element, and a client key element.

33. The computer-readable medium storing computer-readable software of claim 30, wherein the fourth program construct further determines a match by:

determining a plurality of potentially matching records, and from the plurality of potentially matching records, eliminating a potentially matching record which does not sufficiently match a name element or a tax identification element of the third record;

from the plurality of potentially matching records, eliminating a potentially matching record which does not sufficiently match an address element of the third record;

from the plurality of potentially matching records, eliminating a potentially matching record which does not sufficiently match a standard industry code element of the third record; and

following elimination of one or more potentially matching records from the plurality of potentially matching records, affirmatively matching the third record to the first element of the first plurality of elements of the first record to a selected confidence level, the first record remaining within the plurality of potentially matching records, and affirmatively matching the third record to the second element of the second plurality of elements of the second record to the selected confidence level, the second record remaining within the plurality of potentially matching records.

34. The computer-readable medium storing computer-readable software of claim 30, wherein the first program construct associates the first record with the first identifier by matching the first record to another record associated with the first identifier, of the plurality of records.

35. The computer-readable medium storing computer-readable software of claim 30, further comprising:

a ninth program construct for associating a plurality of addresses with the first identifier, each address of the plurality of addresses having a unique site identifier of a plurality of site identifiers associated with the first identifier.

36. The computer-readable medium storing computer-readable software of claim 30, further comprising:

a tenth program construct for associating a site identifier with the first identifier, the site identifier corresponding to an address associated with the first identifier.

37. A computer-implemented method of creating a data structure stored in one or more data storage devices, wherein the data structure provides information to link records with an entity of a plurality of entities, for database searching and record matching operations, the method comprising:

associating a first record, of a plurality of records, with a first identifier of a plurality of identifiers that identifies at least one entity of the plurality of entities, wherein each identifier is unique and persistent for a predetermined period of time;

associating a second record, of the plurality of records, with a second identifier that identifies at least one entity of the plurality of business entities;

determining that the first identifier and the second identifier correspond to a same entity of the plurality of entities by determining that a third record, of the plurality of records, sufficiently matches with a first element of a first plurality of elements of the first record to a selected or predetermined confidence level and further sufficiently matches with a second element of a second plurality of elements of the second record to the selected or predetermined confidence level;

determining a plurality of potentially matching records, and from the plurality of potentially matching records, eliminating a potentially matching record which does not sufficiently match a name element and a tax identification element of the first, second or third records within the selected or predetermined confidence level;

linking the first identifier and the second identifier in a data structure that references the first and second records without merging the first and second records and without merging the first and second identifiers;

separately maintaining in a database information in the first record associated with the first identifier and information in the second record associated with the second identifier for the predetermined period of time; and

using the link between the first and second identifiers in the data structure, retrieving and grouping information that is separately maintained in both the first and second records in response to a request for information about the same entity.