IP Library › Granted Patent US 9,619,538
Granted Patent B2
US 9,619,538 · App. 14/041,719 · Granted Apr 11, 2017

Techniques for data integration

Inventors: Thomas Kevin Ryan (Valley Center, CA); Achal Patel (Vadodara, IN); Neelesh Bansode (Bangalore, IN); Arvind Kumar (Bangalore, IN); Anand Louis (Bangalore, IN)
Assignee: Teradata US, Inc.
G06F17/30569
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,619,538
App. No.
14/041,719
Granted
Apr 11, 2017
Kind
B2
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 (27)

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.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 3, 2013
From: RYAN, THOMAS KEVIN; PATEL, ACHAL; BANSODE, NEELESH; KUMAR, ARVIND; LOUIS, ANAND
To: TERADATA US, INC.
Reel/Frame 031339/0372 →
Continuity (2)
Provisional Application 61788712 · Mar 15, 2013
Related Publication 20140280218A1 · Sep 18, 2014