Apparatus and method for processing of COBOL nested data record schemas

1 . A computer readable medium comprising executable instructions to:

parse a COBOL copybook, including executable instructions to determine that the COBOL copybook contains a nested data record schema; and

transform the COBOL copybook into a standardized data record schema.

2 . The computer readable medium of claim 1 , wherein the standardized data record schema is an expanded data record schema.

3 . The computer readable medium of claim 1 , wherein the standardized data record schema is a collapsed data record schema.

4 . The computer readable medium of claim 1 , wherein the standardized data record schema is used to store data in a relational database.

5 . The computer readable medium of claim 1 , wherein a type of the standardized data record schema is user selectable.

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

process a data record based on the standardized data record schema derived from the COBOL copybook; and

create a database table based on the standardized data record schema and the data record.

7 . The computer readable medium of claim 6 , wherein the standardized data record schema is a collapsed data record schema, and wherein the executable instructions to create further comprise executable instructions to add a number of rows to the database table, wherein the number of rows is based on the contents of the data record.

8 . The computer readable medium of claim 6 , further comprising executable instructions to receive a request to process the data record including executable instructions to:

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

select a second image representing the database table.

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

10 . The computer readable medium of claim 9 , wherein the executable instructions to link include executable instructions to specify a data transform.

11 . A computer readable medium comprising executable instructions to:

parse a data record schema represented in COBOL, including executable instructions to determine that the data record schema is a nested data record schema; and

create a standardized data record schema based on the nested data record schema.

12 . The computer readable medium of claim 11 , wherein the standardized data record schema is an expanded data record schema.

13 . The computer readable medium of claim 11 , wherein the standardized data record schema is a collapsed data record schema.

14 . The computer readable medium of claim 11 , wherein the standardized data record schema is used to store data in a relational database.

15 . The computer readable medium of claim 11 , wherein a type of the standardized data record schema is user selectable.

16 . The computer readable medium of claim 11 , further comprising executable instructions to:

process a data record based on the standardized data record schema; and

create a database table based on the standardized data record schema and the data record.

17 . The computer readable medium of claim 16 , wherein the standardized data record schema is a collapsed data record schema, and wherein the executable instructions to create further comprise executable instructions to add a number of rows to the database table, wherein the number of rows is based on the contents of the data record.

18 . The computer readable medium of claim 16 , further comprising executable instructions to receive a request to process the data record including executable instructions to:

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

select a second image representing the database table.

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

20 . The computer readable medium of claim 19 , wherein the executable instructions to link include executable instructions to specify a data transform.