US Patent No. 10,691,712

SYSTEM AND METHOD FOR MERGING A MAINFRAME DATA FILE TO A DATABASE TABLE FOR USE BY A MAINFRAME REHOSTING PLATFORM


Patent No. 10,691,712
Issue Date June 23, 2020
Title System And Method For Merging A Mainframe Data File To A Database Table For Use By A Mainframe Rehosting Platform
Inventorship Weixuan (Wade) Zhang, Beijing (CN)
Weiguo Zhu, Beijing (CN)
Hui Shen, Beijing (CN)
Assignee ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)

Claim of US Patent No. 10,691,712

1. A system for merging records of a mainframe data file in an associated mainframe computer system into a target database table (TEST01) of a relational database, the system comprising:a microprocessor;
a mainframe rehosting platform executing on the microprocessor, wherein the mainframe rehosting platform comprises the relational database, wherein the relational database comprises the target database table TEST01, wherein the target database table TEST01 has a target table structure; and
a rehosting workbench generating an uploading program and a plurality of scripts based on the target database table TEST01 and the mainframe data file in the associated mainframe computer system,
wherein the plurality of scripts operate to:
download the target table structure of the target database table from the mainframe rehosting platform;
create an empty temporary table (TEST01_TMP) in the relational database, wherein the empty temporary table TEST01_TMP in the relational database has the same target table structure as the target database table TEST01;
retrieve records of the mainframe data file from the associated mainframe computer system; and
store the retrieved records of the mainframe data file in a workbench data file of the rehosting workbench in a data array that can be inserted into the empty temporary table TEST01_TMP in an insert operation, and
wherein the uploading program operates to:
upload the workbench data file to the empty temporary table TEST01_TMP having the same target table structure as the target database table TEST01 by inserting the retrieved records stored in the data array into the empty temporary table TEST01_TMP using the insert operation; and
merge the records of the mainframe data file into the target database table TEST01 by invoking an existing embedded merge function within the relational database to merge the temporary table TEST01_TMP comprising the inserted retrieved records stored in the data array into the target database table TEST01.