Data Transformation System, Graphical Mapping Tool And Method For Creating A Schema Map

• US 20160321307A1
• Filed: 07/07/2016
• Published: 11/03/2016
• Est. Priority Date: 11/03/2011
• Status: Active Grant

• Current Assignee: Actian Corporation
• Original Assignee: Pervasive Software Incorporated (Actian Corporation)
• Inventors: Dingman, Paul C., Bunton, William G., Van Dyken, Kathryn E., Yogman, Laurence T., Zhang, Yimin
• Granted Patent: US 10,127,250 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 15/16 Combinations of two or more digital computers each having at least an arithmetic unit, a program unit and a register, e.g. for a simultaneous processing of several programs coordinating program control therefor G06F9/52; in regulating and control system G05B
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 2203/04803 Split screen, i.e. subdividing the display area or the window area into separate subareas
• CPC Class Codes: G06F 3/048 Interaction techniques based on graphical user interfaces [GUI]

Abstract

Embodiments of a graphical mapping interface and method are provided herein for creating and displaying a schema map, which may be used by a data transformation system to perform a data transformation between at least one source schema and at least one target schema. According to one embodiment, the graphical mapping interface may generally comprise a main map window and a mini-map window. The main map window comprises a source schema region, which is adapted for displaying a graphical representation of a primary source schema defining a structure of a primary data source. The mini-map window is adapted for creating a mapping between one or more nodes of the primary source schema and one or more nodes of an intermediate target schema, and displaying a graphical representation of the mapping within the mini-map window. Upon closing the mini-map window, a graphical representation of the intermediate target schema is displayed in the source schema region of the main map window and accessible for mapping within the main map window.

Claims

1. A graphical mapping interface for creating and displaying a schema map, wherein the graphical mapping interface is displayed on a screen and implemented with computer-readable instructions, which are stored on a non-transitory computer-readable storage medium and executed on a processor, and wherein the graphical mapping interface comprises:

a main map window comprising a source schema region adapted for displaying a graphical representation of a primary source schema defining a structure of a primary data source;

a mini-map window adapted for creating a mapping between one or more nodes of the primary source schema and one or more nodes of an intermediate target schema, and further adapted for displaying a graphical representation of the mapping within the mini-map window; and

wherein upon closing the mini-map window, a graphical representation of the intermediate target schema is displayed in the source schema region of the main map window and accessible for mapping within the main map window.

2. The graphical mapping interface as recited in claim 1, wherein the mapping displayed in the mini-map window is adapted to perform a lookup operation on the primary source schema and provide results of the lookup operation to the intermediate target schema.

3. The graphical mapping interface as recited in claim 1, wherein the mapping displayed in the mini-map window is adapted to transfer at least a subset of data from the primary source schema to the intermediate target schema.

4. The graphical mapping interface as recited in claim 1, further comprising a second mini-map window adapted for creating a mapping between a second intermediate target schema and at least one of the primary source schema and the intermediate target schema, and further adapted for displaying a graphical representation of the mapping within the mini-map window, wherein upon closing the second mini-map window, a graphical representation of the second intermediate target schema is displayed in the source schema region and accessible for mapping within the main map window.

5. The graphical mapping interface as recited in claim 1, wherein the main map window is further adapted for displaying a graphical representation of a second intermediate target schema within the source schema region of main map window.

6. The graphical mapping interface as recited in claim 5, wherein the intermediate target schema and the second intermediate target schema are nested or chained within the source schema region of the main map window.

7. The graphical mapping interface as recited in claim 1, wherein the mini-map window comprises:

a source schema region adapted for displaying a graphical representation of the primary source schema;

a target schema region adapted for displaying a graphical representation of the intermediate target schema; and

a mapping region adapted for creating and displaying a graphical representation of one or more links connecting the one or more nodes of the primary source schema to the one or more nodes of the intermediate target schema.

8. The graphical mapping interface as recited in claim 7, wherein the mini-map window further comprises an expression region adapted for displaying at least one target field expression for at least one node of the intermediate target schema displayed in the target schema region of the mini-map window.

9. The graphical mapping interface as recited in claim 7, wherein the mapping region of the mini-map window is further adapted for displaying at least one control link connecting a source record node of the primary source schema to an intermediate record node of the intermediate target schema, and wherein a rule associated with the at least one control link specifies an event corresponding to the source record node, a conditional expression, and an action to be performed for the intermediate target node if an occurrence of the event is detected in the primary data source and the conditional expression is met.

10. The graphical mapping interface as recited in claim 9, wherein the rule is created and displayed in a console panel region of the main map window when the mini-map window is displayed.

11. The graphical mapping interface as recited in claim 1, wherein the main map window further comprises:

a target schema region adapted for displaying a graphical representation of at least one target schema; and

a mapping region adapted for creating and displaying a graphical representation of one or more links connecting one or more nodes of the primary source schema to one or more nodes of the at least one target schema.

12. The graphical mapping interface as recited in claim 9, wherein the mapping region of the main map window is further adapted for creating and displaying a graphical representation of a link connecting a node of the intermediate target schema displayed in the source schema region of the main map window to a node of the at least one target schema displayed in the target schema region of the main map window.

13. A method for creating a mapping in a graphical mapping interface that is displayed on a screen and implemented with computer-readable instructions, which are stored on a non-transitory computer-readable storage medium and executed on a processor, the method comprising:

displaying a main map window comprising a source schema region, which is adapted for displaying a graphical representation of a primary source schema defining a structure of a primary data source;

displaying a mini-map window comprising a source schema region, which is adapted for displaying the graphical representation of the primary source schema, and a target schema region, which is adapted for displaying a graphical representation of an intermediate target schema;

creating a mapping between the primary source schema and the intermediate target schema by drawing one or more graphical links connecting one or more nodes of the primary source schema to one or more nodes of the intermediate target schema within a mapping region of the mini-map window; and

displaying a graphical representation of the intermediate target schema in the source schema region of the main map window upon closing the mini-map window.

14. The method as recited in claim 13, further comprising creating, within a mapping region of the main map window, a mapping between the intermediate target schema displayed in the source schema region and a primary target schema displayed in a target schema region of the main map window.

15. The method as recited in claim 13, further comprising:

displaying a second mini-map window comprising a source schema region, which is adapted for displaying a graphical representation of at least one of the primary source schema and the intermediate target schema, and a target schema region, which is adapted for displaying a graphical representation of a second intermediate target schema;

creating a mapping within the second mini-map window between the second intermediate target schema and the at least one of the primary source schema and the intermediate target schema;

displaying a graphical representation of the second intermediate target schema in the source schema region of the main map window upon closing the second mini-map window.

16. The method as recited in claim 13, wherein the one or more graphical links comprise at least one control link and at least one data link, and wherein graphical representations of the control and data links are displayed in the mapping region of the mini-map window.

17. The method as recited in claim 16, wherein the at least one control link connects a particular primary source node to a particular intermediate target node, and wherein the at least one control link comprises a rule specifying an event corresponding to the particular source node, a conditional expression, and an action to be performed for the particular intermediate target node if an occurrence of the event is detected in the primary data source and the conditional expression is met.

18. The method as recited in claim 13, wherein the step of creating a mapping between the primary source schema and the intermediate target schema further comprises specifying at least one target field expression within an expression region of the mini-map window for at least one intermediate target node displayed in the target schema region of the mini-map window, and wherein a textual representation of the at least one target field expression is displayed in the expression region.

19. A data transformation system, comprising:

a graphical mapping interface for creating and displaying a schema map, wherein the graphical mapping interface is displayed on a screen and implemented with computer-readable instructions, which are stored on a non-transitory computer-readable storage medium and executed on a processor, and wherein the graphical mapping interface comprises;

a main map window comprising a source schema region adapted for displaying a graphical representation of a primary source schema defining a structure of a primary data source;

a mini-map window adapted for creating a mapping between one or more nodes of the primary source schema and one or more nodes of an intermediate target schema, and displaying a graphical representation of the mapping within the mini-map window; and

wherein upon closing the mini-map window, a graphical representation of the intermediate target schema is displayed in the source schema region of the main map window and accessible for mapping within the main map window.

20. The data transformation system as recited in claim 19, wherein the mini-map window comprises:

a source schema region adapted for displaying a graphical representation of the primary source schema;

a target schema region adapted for displaying a graphical representation of the intermediate target schema;

an expression region adapted for displaying at least one target field expression for at least one node of the intermediate target schema displayed in the target schema region of the mini-map window; and

a mapping region adapted for creating and displaying the graphical representation of the mapping by creating and displaying a graphical representation of one or more links connecting the one or more nodes of the primary source schema to the one or more nodes of the intermediate target schema.

21. The data transformation system as recited in claim 20, wherein the mapping region of the mini-map window is further adapted for displaying at least one control link connecting a source record node of the primary source schema to an intermediate record node of the intermediate target schema, and wherein a rule associated with the at least one control link specifies an event corresponding to the source record node, a conditional expression, and an action to be performed for the intermediate target node if an occurrence of the event is detected in the primary data source and the conditional expression is met.

22. The data transformation system as recited in claim 19, wherein the main map window further comprises:

a target schema region adapted for displaying a graphical representation of at least one target schema; and

a mapping region adapted for creating and displaying a graphical representation of one or more links connecting one or more nodes of the primary source schema to one or more nodes of the at least one target schema.

23. The data transformation system as recited in claim 22, wherein the mapping region of the main map window is further adapted for creating and displaying a graphical representation of a link connecting a node of the intermediate target schema displayed in the source schema region of the main map window to a node of the at least one target schema displayed in the target schema region of the main map window.

24. The data transformation system as recited in claim 22, wherein the at least one target schema displayed in the target schema region of the main map window comprises at least one target record node having multiple output operations associated therewith.

25. The data transformation system as recited in claim 24, wherein the multiple output operations are selected from a group comprising an insert operation, a delete operation, an update operation and an upsert operation.

26. The data transformation system as recited in claim 22, wherein the source schema region of the main map window is adapted for displaying a graphical representation of a plurality of source schemas, wherein the target schema region of the main map window is adapted for displaying a graphical representation of a plurality of target schemas, and wherein the plurality of source schemas and the plurality of target schemas comprise different schema types.

27. The data transformation system as recited in claim 26, wherein the different schema types are selected from a group comprising single mode, multi-mode, multi-record, flat and hierarchical schema types.

28. The data transformation system as recited in claim 19, further comprising a design repository configured for storing the schema map created via the graphical mapping interface.

29. The data transformation system as recited in claim 28, wherein the design repository is further configured for storing a library of mini-maps, which is defined independently of the schema map and usable with the schema map, as well as other schema maps.

30. The data transformation system as recited in claim 28, further comprising a package builder coupled for extracting the schema map from the design repository and configured for packaging the schema map into a deployment package.

31. The data transformation system as recited in claim 30, further comprising:

a read connector configured for retrieving data from the primary data source;

a target connector configured for storing transformed data to a data target; and

a transformation engine coupled to the read connector for receiving the data from the primary data source, coupled to the target connector for storing the transformed data in the data target, and coupled to the package builder for receiving the deployment package, wherein the transformation engine is configured for transforming the received data into the transformed data using the schema map included within the deployment package.