Data mapper
AssigneeInternational Business Machines Corporation
InventorsAndrew J. Coleman, John A. Reeve
Life of this patent
Estimating the term…
Abstract
A method and system for mapping data elements between a source data structure and a target data structure. A source data element is mapped to a target data element by matching a source key and value pair to a target key and value pair. A parent source Soundex key for each parent element of the source data element is created. A parent target Soundex key for each parent element of a plurality of target data elements snatching the first Soundex key of the source data element is created. The parent source Soundex key for each parent element of the source data element is compared with each parent target Soundex key. The source data element is mapped to the target data element having the parent target Soundex key that matches the parent source Soundex key.
Claims20
A method for mapping data elements between a source data structure and a target data structure, said method comprising the steps of:
- mapping, by a processor of a computer system, a source data element to a target data element by matching a source key and value pair stored in a source data structure to a target key and value pair of a target data structure, wherein the source key and value pair is a pairing of a first Soundex key with a value equal to the source data element, wherein the target key and value pair is a pairing of a second Soundex key and the target data element, wherein the source key and value pair and the target key and value pair are encoded to allow for alternative spellings or misspellings of the data elements stored by the source and target data structures, and wherein said matching results in a plurality of target data elements, each target data element comprising Soundex keys matching a Soundex key of the source data element;
- creating, by the processor, a parent source Soundex key for each parent element of the source data element;
- creating, by the processor, a parent target Soundex key for each parent element of the plurality of target data elements matching the first Soundex key of the source data element;
- comparing, by the processor, the parent source Soundex key for each parent element of the source data element with each parent target Soundex key;
- and
- mapping, by the processor, the source data element to the target data element having the parent target Soundex key that matches the parent source Soundex key.
A computer system, comprising:
- a processor, a memory device coupled to the processor, and a computer readable storage device coupled to the processor, wherein the storage device contains program code executable by the processor via the memory device to implement a method for mapping data elements between a source data structure and a target data structure, said method comprising:
- mapping, by the processor, a source data element to a target data element by matching a source key and value pair stored in a source data structure to a target key and value pair of a target data structure, wherein the source key and value pair is a pairing of a first Soundex key with a value equal to the source data element, wherein the target key and value pair is a pairing of a second Soundex key and the target data element, wherein the source key and value pair and the target key and value pair are encoded to allow for alternative spellings or misspellings of the data elements stored by the source and target data structures, and wherein said matching results in a plurality of target data elements, each target data element comprising Soundex keys matching a Soundex key of the source data element;
- creating, by the processor, a parent source Soundex key for each parent element of the source data element:
- creating, by the processor, a parent target Soundex key for each parent element of the plurality of target data elements matching the first Soundex key of the source data element;
- comparing, by the processor, the parent source Soundex key for each parent element of the source data element with each parent target Soundex key;
- and
- mapping, by the processor, the source data element to the target data element having the parent target Soundex key that matches the parent source Soundex key.
A computer program product, comprising:
- one or more computer readable hardware storage devices having computer readable program code stored therein, said program code containing instructions executable by one or more processors to implement a method for mapping data elements between a source data structure and a target data structure, said method comprising:
- mapping, by the processor, a source data element to a target data element by matching a source key and value pair stored in a source data structure to a target key and value pair of a target data structure, wherein the source key and value pair is a pairing of a first Soundex key with a value equal to the source data element, wherein the target key and value pair is a pairing of a second Soundex key and the target data element, wherein the source key and value pair and the target key and value pair are encoded to allow for alternative spellings or misspellings of the data elements stored by the source and target data structures, and wherein said matching results in a plurality of target data elements, each target data element comprising Soundex keys matching a Soundex key of the source data element;
- creating, by the processor, a parent source Soundex key for each parent element of the source data element;
- creating, by the processor, a parent target Soundex key for each parent element of the plurality of target data elements matching the first Soundex key of the source data element;
- comparing, by the processor, the parent source Soundex key for each parent element of the source data element with each parent target Soundex key;
- and
- snapping, by the processor, the source data element to the target data element having the parent target Soundex key that matches the parent source Soundex key.
Dependencies are inferred from the claim text.