Method and system for visual data mapping and code generation to support data integration
First Claim
Patent Images
1. A data integration method operative in a data processing system having a windows-based graphical user interface (GUI), comprising:
- (a) displaying “
n”
structured data objects, wherein any given structured data object is positionable in any juxtaposition with respect to any other given structured data object;
(b) visually defining mappings between at least a first structured data object and a second structured data object, each mapping taking one or more data elements of the first structured data object and associating the one or more data elements, or an output from a data processing function thereof, to one or more data elements in the second structured data object; and
(c) responsive to step (b), automatically generating given program code, wherein the given program code enables programmatic data transformation from the first structured data object to the second structured data object in a given application execution environment.
1 Assignment
0 Petitions
Accused Products
Abstract
A data integration method and system that enables data architects and others to simply load structured data objects (e.g., XML schemas, database tables, EDI documents or other structured data objects) and to visually draw mappings between and among elements in the data objects. From there, the tool auto-generates software program code required, for example, to programmatically marshal data from a source data object to a target data object.
177 Citations
29 Claims
-
1. A data integration method operative in a data processing system having a windows-based graphical user interface (GUI), comprising:
-
(a) displaying “
n”
structured data objects, wherein any given structured data object is positionable in any juxtaposition with respect to any other given structured data object;
(b) visually defining mappings between at least a first structured data object and a second structured data object, each mapping taking one or more data elements of the first structured data object and associating the one or more data elements, or an output from a data processing function thereof, to one or more data elements in the second structured data object; and
(c) responsive to step (b), automatically generating given program code, wherein the given program code enables programmatic data transformation from the first structured data object to the second structured data object in a given application execution environment. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 27, 28, 29)
-
-
9. A data integration method operative in a data processing system having a windows-based graphical user interface (GUI), comprising the unordered steps:
-
(a) displaying “
n”
structured data objects, wherein any given structured data object is positionable in any juxtaposition with respect to any other given structured data object;
(b) displaying a given data processing element;
(c) visually defining at least one mapping from a first structured data object to a second structured data object through the given data processing element; and
(d) responsive to step (c), automatically generating given program code, wherein the given program code enables programmatic data transformation from the first structured data object to the second structured data object in a given application execution environment. - View Dependent Claims (10, 11)
-
-
12. A data object for use in a data integration display method, comprising:
-
a structured content model representation;
a first set of one or more sockets representing one or more inputs to the structured content model representation; and
a second set of one or more sockets representing one or more outputs from the structured content model representation;
wherein the sockets facilitate creation of a given visual mapping when the data object is displayed in juxtaposition with one or more other data objects. - View Dependent Claims (13, 14, 15)
-
-
16. A data processing system having a windows-based graphical user interface (GUI), comprising:
-
a display environment in which “
n”
structured data objects are displayed, wherein any given structured data object is positionable in any juxtaposition with respect to any other given structured data object;
code responsive to visual mappings among the structured data objects for automatically generating given program code, wherein the given program code enables programmatic data transformation from any first set of one or more structured data objects to any second set of the one more structured data objects in a given application execution environment. - View Dependent Claims (17, 18, 19, 20, 21, 22, 23, 24)
-
-
25. A data integration method operative in a data processing system having a windows-based graphical user interface (GUI), comprising the unordered steps:
-
(a) displaying “
n”
structured data objects, wherein any given structured data object is positionable in any juxtaposition with respect to any other given structured data object;
(b) visually defining one or more mappings from any first set of one or more structured data objects to any second set of one or more structured data objects;
(c) responsive to step (b), automatically generating given program code, wherein the given program code enables programmatic data transformation from any first set of one or more structured data objects to any second set of one or more structured data objects in a given application execution environment; and
(d) selectively displaying a preview of the programmatic data transformation.
-
-
26. A data integration method operative in a data processing system having a windows-based graphical user interface (GUI), comprising the unordered steps:
-
(a) displaying, in juxtaposition, a set of two or more structured data objects, wherein a given structured data object comprises;
a structured content model representation;
a first set of one or more sockets representing one or more inputs to the structured content model representation; and
a second set of one or more sockets representing one or more outputs from the structured content model representation;
(b) visually defining mappings among given elements of the structured data objects;
(c) responsive to step (b), automatically generating given program code, wherein the given program code enables programmatic data transformation in a given application execution environment.
-
Specification