Techniques for data integration
AssigneeTeradata US, Inc.
InventorsThomas Kevin Ryan, Achal Patel, Neelesh Bansode, Arvind Kumar, Anand Louis
Life of this patent
Estimating the term…
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.
Claims20
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;
- and
- creating, by the processor, a profile for the source data that defines actions of the mapping.
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 attributes and the target attributes;
- receiving, via the processor, rules for resolving conflicts when transforming the source data to the target data;
- and
- 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.
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.
Dependencies are inferred from the claim text.