Techniques for data integration

• US 9,619,538 B2
• Filed: 09/30/2013
• Issued: 04/11/2017
• Est. Priority Date: 03/15/2013
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Ryan, Thomas Kevin, Patel, Achal, Bansode, Neelesh, Kumar, Arvind, Louis, Anand
• Primary Examiner(s): Arjomandi, Noosha
• Application Number:
  US14/041,719
• Publication Number:
  US 20140280218A1
• Time in Patent Office: 1,289 Days
• Field of Search: 707748
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

Techniques for data integration are provided. Source attributes for source data are interactively mapped to target attributes for target data. Rules define how records from the source data are merged, selected, and for duplication detection. The mappings and rules are recorded as a profile for the source data and processed against the source data to transform the source attributes to the target attributes.

Claims

1. A method implemented and programmed within a non-transitory computer-readable storage medium and processed by a processor, the processor configured to execute the method, comprising:

identifying, by the processor, source data;

mapping, by the processor, source data attributes present in the source data to target data attributes in target data;

creating, by the processor, a profile for the source data that defines actions of the mapping, said profile comprising an executable script that transforms the source data attributes into the target data attributes;

processing, via the processor, the profile against the source and target data; and

evaluating, via the processor, selection rules when multiple records from the source data appear to be a single record, wherein evaluating further includes applying at least one of the selection rules based on a highest score for each of the multiple records.

2. The method of claim 1 further comprising, providing, via the processor, the method as an interactive user interface.

3. The method of claim 1 further comprising, reusing, via the processor, the profile when a new instance of the source data is processed.

4. The method of claim 1 further comprising, merging, via the processor, records in the source data into the target data.

5. A method implemented and programmed within a non-transitory computer-readable storage medium and processed by a processor, the processor configured to execute the method, comprising:

presenting, via the processor, source attributes for source data and target attributes defined in target data to a user;

recording, via the processor, mappings between the source data attributes and the target data attributes;

receiving, via the processor, rules for resolving conflicts when transforming the source data to the target data;

wherein receiving further includes applying at least one or the rules when multiple records from the source data appear as a single record based on a highest score for each of the multiple records;

housing, via the processor, the mappings and the rules with an identifier for the source data and another identifier for the target data as a profile for the transforming, said profile comprising an executable script that transforms the source data attributes into the target data attributes;

wherein receiving further includes providing predefined rules for merging, selection, and duplication based on a profile type associated with the profile; and

processing, via the processor, the profile against the source and target data.

6. The method of claim 5, wherein presenting further includes using a source schema for presenting the source attributes and target schema for presenting the target attributes.

7. The method of claim 5, wherein recording further includes tracking interface selections or associations made by the user between the source attributes and the target attributes as the mappings.

8. The method of claim 5, wherein receiving further includes permitting the user to custom define rules for merging, selection, and duplication of records associated with the source data.

9. The method of claim 5, wherein housing further includes augmenting the profile with metadata and control data associated with processing the profile.

10. The method of claim 5 further comprising, providing, via the processor, the method as a graphical user interface to the user.

11. A system, comprising:

a non-transitory computer-readable storage medium having instructions for a data mapper that execute on one or more processors of a network; and

the non transitory computer-readable storage media having instructions for a data integration interface manager that executes on the one or more processors of the network;

wherein the data mapper is configured to create a mapping between source attributes for source data and target attributes for target data by monitoring actions of a user accessing an interface presented by the data integration interface manager, and the data integration interface manager further configured to create and to record a profile for mappings that when processed transforms the source attributes to the target attributes, said profile comprising an executable script that transforms the source data attributes into the target data attributes, and wherein the data mapper is further configured to apply at least one or the conflict rule when multiple records from the source data appear as a single record based on a highest score for each of the multiple records; and

wherein the data integration interface manager is configured to associate merge rules, duplication rules, and selection rules for records when processing the profile.

12. The system of claim 11, wherein the data integration interface manager is configured to receive custom rules for some of the merge rules, some of the duplication rules, and/or for some of the selection rules.