Apparatus, system, and method for map definition generation
First Claim
1. A method for generating a storable map definition for a client, the method comprising:
- accessing a source data structure and a destination data structure, wherein the source data structure comprises a plurality of source attributes and the destination data structure comprises a plurality of destination attributes;
using a map apparatus to automatically identify a match of an identified source attribute and an identified destination attribute, the map apparatus implemented on a processor and a memory, the match identified according to predefined tolerance parameters comprising affixes, case sensitivities, data types, and synonyms, and using the map apparatus to generate a storable map definition configured to map a source value for the identified source attribute to a destination value for the identified destination attribute;
delivering the storable map definition to a user, the storable map definition comprising the identified source attribute, the identified destination attribute, and a transformation action associated with each identified source attribute and identified destination attribute, the transformation action configured to transform data in the identified source attribute of the source data structure to data in the identified destination attribute of the destination data structure, the source data structure and the destination data structure residing on disparate data systems, wherein the transformation action specifies an action to convert at least one data value in the identified source attribute to one or more data values in data fields of the identified destination attribute;
using the map apparatus to generate a storable reverse map definition from a mapping defined in the storable map definition;
using the map apparatus to automatically generate a reverse transformation action for the storable reverse map definition, the reverse transformation action based on a transformation action included in the storable map definition, the reverse transformation action specifying an action to convert at least one data value in the identified destination attribute to one or more data values in data fields of the identified source attribute; and
delivering the storable reverse map definition to the user.
1 Assignment
0 Petitions
Accused Products
Abstract
A computer program product, apparatus, system, and method are disclosed for automatic generation of a map definition. The computer program product performs operations for such generation. These operations include identifying a source data structure and a source attribute associated with the source data structure and identifying a destination data structure and a destination attribute associated with the destination data structure. These operations also include automatically identifying a match of the source attribute and the destination attribute and generating a map definition inclusive of the match. The computer program product, apparatus, system, and method thereby reduce human intervention in the creation of a map definition.
-
Citations
30 Claims
-
1. A method for generating a storable map definition for a client, the method comprising:
-
accessing a source data structure and a destination data structure, wherein the source data structure comprises a plurality of source attributes and the destination data structure comprises a plurality of destination attributes; using a map apparatus to automatically identify a match of an identified source attribute and an identified destination attribute, the map apparatus implemented on a processor and a memory, the match identified according to predefined tolerance parameters comprising affixes, case sensitivities, data types, and synonyms, and using the map apparatus to generate a storable map definition configured to map a source value for the identified source attribute to a destination value for the identified destination attribute; delivering the storable map definition to a user, the storable map definition comprising the identified source attribute, the identified destination attribute, and a transformation action associated with each identified source attribute and identified destination attribute, the transformation action configured to transform data in the identified source attribute of the source data structure to data in the identified destination attribute of the destination data structure, the source data structure and the destination data structure residing on disparate data systems, wherein the transformation action specifies an action to convert at least one data value in the identified source attribute to one or more data values in data fields of the identified destination attribute; using the map apparatus to generate a storable reverse map definition from a mapping defined in the storable map definition; using the map apparatus to automatically generate a reverse transformation action for the storable reverse map definition, the reverse transformation action based on a transformation action included in the storable map definition, the reverse transformation action specifying an action to convert at least one data value in the identified destination attribute to one or more data values in data fields of the identified source attribute; and delivering the storable reverse map definition to the user. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A computer program product comprising a computer readable storage medium tangibly embodying a program of machine-readable instructions executable by a digital processing apparatus to perform operations to facilitate automatic generation of a storable map definition, the operations of the computer program product comprising:
-
accessing a source data structure and a destination data structure, wherein the source data structure comprises a plurality of source attributes and the destination data structure comprises a plurality of destination attributes; automatically identifying a match of an identified source attribute and an identified destination attribute using a map apparatus implemented on a processor and a memory, the match identified according to predefined tolerance parameters comprising affixes, case sensitivities, data types and synonyms; generating a storable map definition inclusive of the match and delivering the storable map definition to a user, the storable map definition comprising the identified source attribute, the identified destination attribute, and a transformation action associated with each identified source attribute and identified destination attribute, the transformation action configured to transform data in the identified source attribute of the source data structure to data in the identified destination attribute of the destination data structure, the source data structure and the destination data structure residing on disparate data systems, wherein the transformation action specifies an action to convert at least one data value in the identified source attribute to one or more data values in data fields of the identified destination attribute; editing the storable map definition to define a mapping between an additional source attribute and an additional destination attribute in response to the user augmenting the storable map definition, the additional source and destination attributes having a semantic relationship; generating a storable reverse map definition from a mapping defined in the storable map definition; automatically generating a reverse transformation action for the storable reverse map definition, the reverse transformation action based on a transformation action included in the storable map definition, the reverse transformation action specifying an action to convert at least one data value in the identified destination attribute to one or more data values in data fields of the identified source attribute; and delivering the storable reverse map definition to the user. - View Dependent Claims (8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24)
-
-
25. A method for automatically generating a storable map definition, the method comprising:
-
identifying a source data structure and a plurality of source attributes associated with the source data structure; identifying a destination data structure and a plurality of destination attributes associated with the destination data structure; automatically identifying a match of an identified source attribute and an identified destination attribute using a map apparatus implemented on a processor and a memory, the match identified according to predefined tolerance parameters comprising affixes, case sensitivities, data types and synonyms; generating a storable map definition inclusive of the match and delivering the storable map definition to the user, the storable map definition comprising the identified source attribute, the identified destination attribute, and a transformation action associated with each identified source attribute and identified destination attribute, the transformation action configured to transform data in the identified source data attribute of the source data structure to data in the identified destination data attribute of the destination data structure, the source data structure and the destination data structure residing on disparate data systems, wherein the transformation action specifies one of a move, join, split, submap, cross-reference, string manipulation, and data type conversion; editing the storable map definition to define a mapping between an additional source attribute and an additional destination attribute in response to the user augmenting the storable map definition, the additional source attribute and the additional destination attribute having a semantic relationship; generating a storable reverse map definition from a mapping defined in the storable map definition; automatically generating a reverse transformation action for the storable reverse map definition, the reverse transformation action based on a transformation action included in the storable map definition, the reverse transformation action specifying an action to convert at least one data value in the identified destination attribute to one or more data values in data fields of the identified source attribute; and delivering the storable reverse map definition to the user. - View Dependent Claims (26, 27, 28, 29, 30)
-
Specification