Patent ID: 11960369
Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 24:
25. A computer-implemented method for generating a copy of a database using a data streaming protocol, the method comprising:
creating, by one or more computer processors, a secondary database including a structure identical to a primary database;
prioritizing, by the one or more computer processors, data objects of the primary database to be copied to said secondary database;
determining, by the one or more processors, a current workload of said primary database;
configuring, by the one or more computer processors, a degree of parallel copy execution of a data streaming protocol, based on said workload of said primary database;
refining, by the one or more processors, the degree of parallel copy execution of the data streaming protocol to validate additional object transfers based on availability of system resources at regular intervals of said primary database;
copying, by the one or more computer processors, said prioritized data objects of said primary database to said secondary database by said data streaming protocol that includes a parallel copy execution of multiple data objects of said prioritized data objects based on said configured degree;
restoring, by the one or more computer processors, said data objects in said secondary database in parallel to said copying of said data objects from said primary database to said secondary database;
applying, by the one or more computer processors, changes made to said data objects in said primary database during copying of said data objects to said secondary database, based on a comparison of the log sequence numbers (LSNs) of said data objects of the primary database and said data objects copied to said secondary database; and
activating, by the one or more computer processors, said secondary database as a duplicate of said primary database, subsequent to copying, restoring, and applying changes of all data objects from said primary database to said secondary database.