Data enrichment using business compendium

• US 9,582,555 B2
• Filed: 09/06/2012
• Issued: 02/28/2017
• Est. Priority Date: 09/06/2012
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Kapadia, Vishal, Jensen, John, McBride, Geralyn
• Primary Examiner(s): Coby, Frantz
• Application Number:
  US13/605,523
• Publication Number:
  US 20140067803A1
• Time in Patent Office: 1,636 Days
• Field of Search: 707/600, 707/602, 707/706, 707/692, 707/610, 707/754, 707/769
• US Class Current: 1/1
• CPC Class Codes: G06F 16/113 Details of archiving lifecycle management in storage systems G06F3/0649; backup systems G06F11/1446
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/24556 Aggregation; Duplicate elimination
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/30 of unstructured textual data document management systems G06F16/93
• CPC Class Codes: G06F 16/90344 by using string matching techniques
• CPC Class Codes: G06F 16/93 Document management systems

Abstract

Embodiments relate to enrichment of a data warehouse utilizing a business compendium. Embodiments may employ a process comprising data standardization and cleansing, de-duplication of entries, and matching and enrichment, followed by manual review of an enriched record by a user. During standardization, data may be transformed into consistent content, placing correct data elements into appropriate fields, removing invalid characters, and/or standardizing names and addresses. Duplicate records are then detected and marked. During matching and enrichment, the existence of an entity (such as a supplier), may be verified by progressive matching against the business compendium. Enrichment may provide additional information regarding the entity (e.g. related to risk, diversity, and bankruptcy). The enriched record is available for manual review, allowing the user to change duplicates, matches, and parent/child linkages. Feedback from the user review may enhance accuracy of subsequent enrichment by self-learning aspects, reducing over time a need for manual review.

Claims

1. A computer system comprising:

one or more processors;

a software program, executable on said computer system, the software program configured to;

cause an enrichment engine to receive an input data set comprising a first supplier and a second supplier;

cause the enrichment engine to perform standardization and cleansing of the input data set, the standardization comprising validating supplier addresses to a locality/city level;

cause the enrichment engine to identify duplicate entries in the input data set;

cause a matching component of the enrichment engine to perform matching of non-duplicate entries of the input data set to a business compendium having data compiled from a third party source, wherein the matching is performed according to criteria comprising,

a first priority comprising name or address having a score greater than a minimum and changed manually in the past,

a second priority comprising name or address having the score greater than the minimum and generated by a matching engine,

a third priority comprising the third party source as a preferred data provider, and

a fourth priority comprising a most recent updating;

cause the enrichment engine to create an enriched data set including additional information based upon the matching, wherein the additional information comprises common corporate ownership and a unique supplier location indicating the first supplier as a subsidiary of the second supplier; and

providing the enriched data set to a user for manual review.

2. A computer system as in claim 1 wherein the computer program is further configured to provide feedback to the matching component based upon the manual review.

3. A computer system as in claim 1 wherein the additional information further comprises diversity information, government sanction information, bankruptcy information, or risk information.

4. A computer system as in claim 1 further comprising logging the enriched data set with a rejection of a match during the manual review.

5. A computer system as in claim 4 wherein the logging precludes including the additional information in the enriched data set in the future.

6. A computer system as in claim 1 wherein the additional information includes a duplicate data record identifier.

7. A computer system as in claim 1 wherein the additional information includes a parent identifier of a hierarchy.

8. A computer system as in claim 7 wherein the parent identifier comprises a compendium identifier in the business compendium.