Apparatus and method for processing data corresponding to multiple COBOL data record schemas

1. A computer readable storage medium comprising executable instructions to:

receive an identification of a plurality of data records comprising at least a first type and a second type, wherein the first type of data record is defined by a first data record schema represented in COBOL, and the second type of data record is defined by a second data record schema represented in COBOL;

create a first standardized data record schema corresponding to the first data record schema, wherein the first standardized data record schema includes a first data record key corresponding to the first type of data record;

create a second standardized data record schema corresponding to the second data record schema, wherein the second standardized data record schema includes a second data record key corresponding to the second type of data record;

process the plurality of data records to determine data records of the first type by comparing the first data record key of the first standardized data record schema to a corresponding field included in the plurality of data records, wherein each data record of the first type has a first set of fields; and

process the plurality of data records to determine data records of the second type by comparing the second data record key of the second standardized data record schema to the corresponding field included in the plurality of data records, wherein each data record of the second type has a second set of fields different from the first set of fields;

wherein the first data record key and the corresponding field included in each data record of the first type have a first common value; and

wherein the second data record key and the corresponding field included in each data record of the second type have a second common value different from the first common value.

2. The computer readable storage medium of claim 1 , further comprising executable instructions to:

create a database table based on the first standardized data record schema and the data records of the first type; and

execute a data manipulation language statement dependent on the database table.

3. The computer readable storage medium of claim 1 , further comprising executable instructions to:

parse a COBOL copybook, including executable instructions to determine that the COBOL copybook contains the first data record schema and the second data record schema.

4. The computer readable storage medium of claim 3 , wherein the first data record key is a value of a field in the first standardized data record schema.

5. The computer readable storage medium of claim 3 , further comprising executable instructions to:

specify the first data record key for the first standardized data record schemas; and

specify the second data record key for the second standardized data record schema.

6. The computer readable storage medium of claim 2 , wherein the executable instructions to specify the first data record key further include executable instructions to:

select a first image representing an association of the first standardized data record schema and the data records of the first type; and

select a second image representing the database table.

7. The computer readable storage medium of claim 6 , further comprising executable instructions to link the first image and the second image to represent a data flow.

8. The computer readable storage medium of claim 7 , wherein the executable instructions to link include executable instructions to specify a data transform.

9. A method of processing data records, comprising:

receiving an identification of a plurality of data records comprising at least a first type and a second type, wherein the first type of data record is defined by a first data record schema represented in COBOL, and the second type of data record is defined by a second data record schema represented in COBOL;

creating a first standardized data record schema corresponding to the first data record schema, wherein the first standardized data record schema includes a first data record key corresponding to the first type of data record;

creating a second standardized data record schema corresponding to the second data record schema, wherein the second standardized data record schema includes a second data record key corresponding to the second type of data record;

processing the plurality of data records to determine data records of the first type by:

comparing the first data record key of the first standardized data record schema to a corresponding field included in the plurality of data records, wherein each data record of the first type has a first set of fields; and

determining that the first data record key and the corresponding field included in each data record of the first type have a first common value; and

processing the plurality of data records to determine data records of the second type by:

comparing the second data record key of the second standardized data record schema to the corresponding field included in the plurality of data records, wherein each data record of the second type has a second set of fields different from the first set of fields; and

determining that the second data record key and the corresponding field included in each data record of the second type have a second common value.

10. The method of claim 9 , further comprising:

creating a database table based on the first standardized data record schema and the data records of the first type; and

executing a data manipulation language statement dependent on the database table.

11. The method of claim 9 , further comprising:

parsing a COBOL copybook, including executable instructions to determine that the COBOL copybook contains the first data record schema and the second data record schema.

12. The method of claim 11 , wherein the first data record key is a value of a field in the first standardized data record schema.

13. The method of claim 11 , further comprising:

specifying the first data record key for the first standardized data record schemas; and

specifying the second data record key for the second standardized data record schema.

14. The method of claim 10 , wherein specifying the first data record key further includes:

selecting a first image representing an association of the first standardized data record schema and the data records of the first type; and

selecting a second image representing the database table.

15. The method of claim 14 , further comprising linking the first image and the second image to represent a data flow.

16. The method of claim 15 , wherein the executable instructions to link include executable instructions to specify a data transform.