Methods, Systems, and Computer Program Products for Generating Data Quality Indicators for Relationships in a Database

• US 20130325880A1
• Filed: 07/29/2013
• Published: 12/05/2013
• Est. Priority Date: 10/04/2007
• Status: Active Grant

• Current Assignee: Liberty Peak Ventures, LLC (Dominion Harbor Enterprises, LLC)
• Original Assignee: American Express Travel Related Services Company, Inc. (American Express Company)
• Inventors: Churi, Prashant Sharad, Creamer, German Gonzalo, Tresch, Sara, Weissman, Mary
• Granted Patent: US 9,075,848 B2
• Time in Patent Office: Days
• US Class Current: 707/749
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/24578 using ranking
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes

Abstract

The disclosed methods, systems, and computer-program products allow a business to generate data quality indicators for relationships in a database. In an embodiment, one or more relationships linked to a customer are retrieved from a database to form a set of relationships. A match confidence code is generated for each relationship based on a score generated by the comparison of customer data associated with the respective relationship and corresponding customer data obtained from an external industry database. A link confidence code is subsequently determined for the customer based on a score generated by the scores used to define the match confidence code for each relationship in the set of relationships and on internal data associated with each relationship in the set of relationships.

Claims

1. A method comprising:

determining, by a computer based system for generating data quality indicators, a link confidence code for a customer, wherein the link confidence code comprises an indication of a quality of a linking between the customer and a set of relationships; and

providing, by the computer based system, at least one of the link confidence code for the customer and the match confidence code.

2. The method of claim 1, wherein the quality of the linking is based on a match confidence code.

3. The method of claim 1, wherein the quality of the linking is based on a match confidence code associated with at least a portion of the set of relationships.

4. The method of claim 1, wherein the quality of the linking is based on internal information associated with at least a portion of the set of relationships.

5. The method of claim 1, wherein the quality of the linking is based on at least one of a match confidence code for each relationship in the set of relationships and internal information associated with at least a portion of the set of relationships.

6. The method of claim 1, wherein the match confidence code is for at least a portion of the set of relationships linked to the customer.

7. The method of claim 1, further comprising verifying, by the computer based system, a quality of relationships in a database using at least one of the link confidence code for the customer and the match confidence code for each relationship.

8. The method of claim 1, further comprising generating, by the computer based system, the match confidence code for a relationship in the set of relationships based on data associated with the respective relationship and corresponding data obtained from an industry database.

9. The method of claim 1, further comprising:

matching, by the computer based system, each of a plurality of data elements associated with the respective relationship to corresponding data elements obtained from an industry database to generate an elemental match score for each of the plurality of data elements;

assembling, by the computer based system, the elemental match scores for the respective relationship into a set of match scores for the respective relationship;

appending, by the computer based system, an authentication code obtained from the industry database to the set of match scores for the respective relationship; and

applying a rule, by the computer based system, to generate the match confidence code for the respective relationship based on the set of match scores for the respective relationship and the authentication code.

10. The method of claim 9, wherein the matching comprises matching, by the computer based system, at least one of a name, an address, a social security number, and a date of birth associated with the respective relationship to corresponding data elements obtained from the industry database.

11. The method of claim 9, wherein the applying comprises selecting, by the computer based system, the match confidence code for the respective relationship from a plurality of confidence levels based on the match pattern and the authentication code of the respective relationship.

12. The method of claim 1, wherein the determining comprises:

appending, by the computer based system, internal data associated with each relationship in the set of relationships to the respective match confidence code for each relationship in the set of relationships; and

applying a rule, by the computer based system, to the internal data and match confidence code associated with each relationship in the set of relationships to generate the link confidence code for the customer.

13. The method of claim 12, wherein the applying comprises selecting, by the computer based system, the link confidence code for the customer from a plurality of confidence levels based on the internal data and match confidence code associated with each relationship in the set of relationships.

14. The method of claim 12, wherein the appending comprises adding, by the computer based system, an age of the data associated with the relationship to the match confidence code for each relationship in the set of relationships.

15. The method of claim 1, wherein the set of relationships includes multiple relationships obtained from a database.

16. The method of claim 1, wherein relationships are established between the customer and a business, in a database.

17. The method of claim 1, wherein the link confidence code is distinct from the match confidence code.

18. A system comprising:

a processor configured for generating data quality indicators,

a tangible, non-transitory memory configured to communicate with the processor,

the tangible, non-transitory memory having instructions stored thereon that, in response to execution by the processor, cause the processor to perform operations comprising;

determining, by the processor, a link confidence code for a customer, wherein the link confidence code comprises an indication of a quality of a linking between the customer and a set of relationships; and

providing, by the processor, at least one of the link confidence code for the customer and the match confidence code.

19. The system of claim 18, further comprising:

matching, by the processor, each of a plurality of data elements associated with the respective relationship to corresponding data elements obtained from an industry database to generate an elemental match score for each of the plurality of data elements;

assembling, by the processor, the elemental match scores for the respective relationship into a set of match scores for the respective relationship;

appending, by the processor, an authentication code obtained from the industry database to the set of match scores for the respective relationship; and

applying a rule, by the processor, to generate the match confidence code for the respective relationship based on the set of match scores for the respective relationship and the authentication code.

20. An article of manufacture including a non-transitory, tangible computer readable medium having instructions stored thereon that, in response to execution by a computer-based system for generating data quality indicators, cause the computer-based system to perform operations comprising:

determining, by the computer based system, a link confidence code for a customer, wherein the link confidence code comprises an indication of a quality of a linking between the customer and a set of relationships; and

providing, by the computer based system, at least one of the link confidence code for the customer and the match confidence code.