System for converting data from input data environment using first format to output data environment using second format by executing the associations between their fields

• US 5,708,828 A
• Filed: 05/25/1995
• Issued: 01/13/1998
• Est. Priority Date: 05/25/1995
• Status: Expired due to Fees

• Current Assignee: BMC Software Incorporated (KKR & Co., Inc.)
• Original Assignee: Reliant Data Systems
• Inventors: Coleman, J. Todd
• Primary Examiner(s): Meky, Moustafa M.
• Application Number:
  US08/450,040
• Time in Patent Office: 964 Days
• Field of Search: 395/500, 395/200.17, 395/200.18, 395/831, 395/850, 395/883, 395/885, 395/890, 395/894, 395/785, 395/800, 395/707, 395/604, 395/886
• US Class Current: 715/205
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: H04L 69/08 Protocols for interworking; Protocol conversion
• CPC Class Codes: H04L 9/40 Network security protocols

Abstract

A data conversion system and method which converts data between different software and hardware platforms. The DCLE of the present invention converts data from any number of different types or formats from any of various platforms to a single common data standard having a pre-defined generic data type, and the data is then converted from this generic type to a new desired format or type and stored on an existing or new destination platform. Thus, the system and method of the present invention allows for multiple database conversions to be created easily and efficiently. The data conversion process begins by first defining a complete data map of the input and output data environments, as well as zero or more intermediate environments. Data objects referred to as data bridges and streams are created to logically connect or associate the input and output environments as well as the tables in the input and output data environments. In response to user input, the data conversion system and method creates an association between fields or parts in the tables (units) in the input environment and the fields in the output environment. This essentially involves creating user specified mappings between fields in the input data environment and fields in the output data environment. When an execute command is received, the data conversion system and method accesses data from the first input environment, i.e., accesses data from the storage medium storing the data to be converted, and converts the data from the first input data environment to data having a pre-defined generic data type. Converting the data first to a pre-defined generic data type greatly simplifies the conversion process, since conversion code is only required to and from the generic data type and is not required between every possible data format. Thus, the development of conversion code is much simpler and more efficient. Once data has been converted to the generic data object, the associations are executed to convert the data from the pre-defined genetic data type to the output data using the second data format.

Claims

1. A method for converting data from an input data environment using a first data format to an output data environment using a second data format, wherein the input data environment includes one or more tables, each of the one or more tables in the input data environment having records including one or more fields, wherein the output data environment includes one or more tables, each of the one or more tables in the output data environment having records including one or more fields, the method comprising the steps of:

receiving a definition of the first data format;

receiving a definition of the second data format;

creating a logical association between the input data environment and the output data environment;

creating one or more logical associations between the one or more tables in the input data environment and the one or more tables in the output data environment;

creating one or more associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment;

performing a data conversion between the input data environment and the output data environment, wherein said performing comprises;

accessing the data from the input data environment;

converting the data from the input data environment using the first data format to data having a pre-defined generic format; and

executing the associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment, wherein said step of executing converts said data having said pre-defined generic format to output data having said second data format.

2. The method of claim 1, wherein said step of executing comprises:

for each table in the output data environment, for each of said logical associations between the one or more tables in the input data environment and a respective table in the output data environment, performing a data conversion for each of the associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the respective table in the output data environment.

3. The method of claim 1, wherein said step of executing comprises:

performing a data conversion for each of the associations between the one or more fields in one or more of the one or more tables in the input data environment and the one or more fields in a respective table in the output data environment;

wherein said step of performing is performed for each of said logical associations between said one or more of the one or more tables in the input data environment and said respective table in the output data environment;

wherein said step of performing is performed for each of said tables in said output data environment.

4. The method of claim 3, wherein the one or more tables in the output data environment have an order including a first table and a last table;

wherein said step of performing is performed for each of said tables in said output data environment according to said order of the one or more tables in the output data environment beginning with said first table in the output data environment and ending with said last table in the output data environment.

5. The method of claim 3, wherein the one or more tables in the input data environment include an order including a first table and a last table;

wherein said step of performing is performed for each of said logical associations between said one or more of the one or more tables in the input data environment and said respective table in the output data environment according to said order of the one or more tables in the input data environment beginning with said first table in the input data environment and ending with said last table in the input data environment.

6. The method of claim 1, wherein said data from the input data environment comprises a data portion and a type portion, wherein said step of converting the data from the input data environment using the first data format to said data having said pre-defined generic format comprises:

storing said data portion of said data from the input data environment in a first memory field; and

storing said type portion of said data from the first input data environment in a second memory field.

7. The method of claim 6, further comprising;

creating an instance of a generic data object prior to said steps of storing said data portion and storing said type portion.

8. The method of claim 1, wherein said pre-defined generic format comprises a pre-defined generic data type, and wherein said step of converting the data from the input data environment using the first data format to data having a pre-defined generic format comprises converting the data from the input data environment using the first data format to data having said pre-defined generic data type.

9. The method of claim 1, wherein said step of creating said one or more associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment comprises:

creating one or more mathematical associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment;

wherein said step of executing comprises executing said one or more mathematical associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment.

10. The method of claim 1, wherein said step of creating said one or more associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment comprises:

creating one or more logical associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment;

wherein said step of executing comprises executing said one or more logical associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment.

11. The method of claim 1, wherein said step of creating said one or more associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment comprises:

creating one or more conditional associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment;

wherein said step of executing comprises executing said one or more conditional associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment.

12. The method of claim 1, wherein the data in the input data environment using said first data format comprises data having one or more different data types;

and

wherein the data in the output data environment using said second data format comprises data having one or more different data types.

13. The method of claim 1, further comprising:

storing said output data having said second data format in said output data environment after said step of executing.

14. The method of claim 13, wherein the input data environment comprises a first storage media storing the input data according to the first data format, and wherein the output data environment comprises a second storage media adapted to receive and store the output data according to the second data format;

wherein said step of accessing the input data comprises accessing the input data from the first storage media; and

wherein said step of storing said converted output data having said second data format comprises writing said converted output data having said second data format to said second storage media.

15. The method of claim 1, wherein said step of receiving a definition of the first data format comprises:

receiving a user-specified definition of the first data format, including a definition of the one or more tables in the input environment and the one or more fields for each of said one or more tables.

16. The method of claim 1, wherein the input data environment includes a data dictionary defining said first data format;

wherein said step of receiving said definition of the first data format comprises;

receiving said data dictionary of the first data format; and

converting said data dictionary of the first data format into said definition of the first data format.

17. The method of claim 1, wherein the one or more tables in the input data environment each comprise one or more records of like data type, wherein the one or more tables in the output data environment each comprise one or more records of like data type.

18. The method of claim 17, wherein said input data environment comprises a database and said output data environment comprises a database.

19. The method of claim 18, wherein said input data environment comprises a hierarchical database and said output data environment comprises a relational database.

20. The method of claim 1, wherein said step of creating an association between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment comprises:

creating one or more MapTo commands between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment.

21. A system for converting data from a first data format to a second data format, the system comprising:

a first storage medium for storing input data using a first data format, wherein the input data using the first data format includes one or more tables, each of the one or more tables in the input data having records including one or more fields;

a second medium for storing output data using a second data format, wherein the output data using the second data format includes one or more tables, each of the one or more tables in the output data having records including one or more fields;

an input data environment object which receives a definition of the first data format, wherein said definition of the first data format includes one or more tables each having one or more fields;

an output data environment object which receives a definition of the second data format, wherein said definition of the second data format includes one or more tables each having one or more fields;

a workplace object for storing one or more associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment;

a generic data object for storing data using a pre-defined generic format,

means for converting the data from the first input data environment using the first data format to data having said pre-defined generic format; and

means for executing the associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment, wherein said means for executing converts said data having said pre-defined generic format to output data having said second data format.

22. The method of claim 21, wherein said data from the first input data environment comprises a data portion and a type portion;

wherein said generic data object comprises a first memory field storing a data portion and a second memory field storing a type portion.

23. A method for converting data from an input data file using a first data format to an output data file using a second data format, wherein the input data file includes one or more tables, each of the one or more tables in the input data environment having records including one or more fields, wherein the output data file includes one or more tables, each of the one or more tables in the output data file having records including one or more fields, the method comprising the steps of:

receiving a definition of the first data format;

receiving a definition of the second data format;

creating a logical association link between the input data file and the output data file;

creating one or more logical association links between the one or more tables in the input data file and the one or more tables in the output data file;

creating one or more association links between the one or more fields in the one or more tables in the input data file and the one or more fields in the one or more tables in the output data file;

performing a data conversion between the input data file and the output data file, wherein said performing comprises;

accessing the data from the input data file;

converting the data from the input data file using the first data format to data having a pre-defined generic format; and

executing the association links between the one or more fields in the one or more tables in the input data file and the one or more fields in the one or more tables in the output data file, wherein said step of executing converts said data having said pre-defined generic format to output data having said second data format.

24. A method for converting data from an input data file using a first data format to an output data file using a second data format, wherein the input data file includes one or more tables, each of the one or more tables in the input data file having records including one or more fields, wherein the output data file includes one or more tables, each of the one or more tables in the output data file having records including one or more fields, the method comprising the steps of:

creating an input environment link to the input data file;

receiving a definition of the first data format;

creating an output environment link to the output data file;

receiving a definition of the second data format;

creating a logical association between the input environment link and the output environment link;

creating one or more logical associations between the one or more tables in the input data file and the one or more tables in the output data file;

creating one or more associations between the one or more fields in the one or more tables in the input data file and the one or more fields in the one or more tables in the output data file;

performing a data conversion between the input data file and the output data file, wherein said performing comprises;

accessing the data from the input data file;

converting the data from the input data file using the first data format to data having a pre-defined genetic format; and

executing the associations between the one or more fields in the one or more tables in the input data file and the one or more fields in the one or more tables in the output data file, wherein said step of executing converts said data having said pre-defined generic format to output data having said second data format.

25. A method for converting data from an input data environment using a first data format to an output data environment using a second data format, wherein the input data environment includes one or more tables, each of the one or more tables in the input data environment having records including one or more fields, wherein the output data environment includes one or more tables, each of the one or more tables in the output data environment having records including one or more fields, the method comprising the steps of:

receiving a definition of the first data format;

receiving a definition of the second data format;

creating a logical association between the input data environment and the output data environment;

creating one or more user-defined links between the one or more tables in the input data environment and the one or more tables in the output data environment,

wherein said user-defined links are configured to link any one or more tables in the input data environment to any one or more tables in said output data environment;

creating one or more associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment;

performing a data conversion between the input data environment and the output data environment, wherein said performing comprises;

accessing the data from the input data environment;

converting the data from the input data environment using the first data format to data having a pre-defined generic format; and

executing the associations between the one or more fields in the one or more tables in the input data environment and the one or more fields in the one or more tables in the output data environment, wherein said step of executing converts said data having said pre-defined generic format to output data having said second data format.