System for transforming and exchanging data between distributed heterogeneous computer systems
DC CAFCFirst Claim
1. A distribution system for transforming and exchanging data between heterogeneous computer systems, comprising:
- a) a systems interface for defining logical import and export data interfaces, data transformation rule sets and scripts;
b) a metadata database for storing said logical import and export data interfaces, data transformation rule sets and scripts;
c) a script processor for utilizing metadata from the metadata database to control data transformation within said systems interface and movement of said data into and out of said distribution system; and
d) a rule set processor responsive to said script processor for manipulating a data bag for storing imported data and a data bag for storing export data.
3 Assignments
Litigations
0 Petitions
Reexaminations
Accused Products
Abstract
A system and method is described for importing data from a source computer system, manipulating and transforming of that data, and exporting the data to a target computer system under control of a script processor using stored metadata definitions. Metadata is used to describe the properties of the data being manipulated. The system includes a means for manipulating the metadata definitions. The metadata definitions are created to import data into the system, export data from the system, create views of the external data, store generic format data within the system, manipulate generic format data within the system and to control data flow through the system. Data is imported into the system using an import data definition to map the external data into an import data bag. Data imported into an import data bag becomes independent of the original data source. Data is manipulated within the system using script control commands and data is transformed within the system using rule sets that act upon data bags. Data is exported from the system using an export data definition to map the import data bag into the required export data bag format and then to write data in the export data bag to the external data target.
-
Citations
19 Claims
-
1. A distribution system for transforming and exchanging data between heterogeneous computer systems, comprising:
-
a) a systems interface for defining logical import and export data interfaces, data transformation rule sets and scripts;
b) a metadata database for storing said logical import and export data interfaces, data transformation rule sets and scripts;
c) a script processor for utilizing metadata from the metadata database to control data transformation within said systems interface and movement of said data into and out of said distribution system; and
d) a rule set processor responsive to said script processor for manipulating a data bag for storing imported data and a data bag for storing export data. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. In a distribution system for transforming and exchanging data between heterogeneous computer systems, a method of controlling data transformation within said distribution system, comprising the steps of:
-
a) operating a script processor that utilizes metadata stored in a metadata database to control the loading of data into an import data bag from a logical import data interface and performing any one or more of the following steps to convert the data to a desired format in an export data bag;
1) sorting said data according to a predetermined order;
2) merging data from a number of data bags into one data bag;
3) appending data from a first data bag into another data bag of the same type;
4) copying data from a first data bag into another data bag of the same type;
5) joining data from two or more data bags into another data bag using a specified key;
6) formatting data from a data bag into another data bag of a different type, using a defined rule set; and
b) saving the data in the export data bag out to an export data connection. - View Dependent Claims (14, 15, 16)
-
-
17. A computer readable memory for transforming and exchanging datastore data between heterogeneous computer systems using different datastore formats for storing similar information, comprising:
-
a) executable code for providing a systems interface for defining logical import and export data interfaces, data transformation rule sets and scripts;
b) executable code for providing a script processor for utilizing metadata from a metadata database to control data transformation within said systems interface and movement of said data into and out of said distribution system; and
c) executable code for providing a rule set processor responsive to said script processor for manipulating a data bag for storing imported data and a data bag for storing export data. - View Dependent Claims (18, 19)
-
Specification