Efficient creation of a secondary database system

A computer system for generating a copy of a database using a data streaming protocol, said computer system comprising:

• one or more processors;
• one or more computer readable storage media communicatively coupled to said one or more processors, wherein said one or more computer readable storage media includes program instructions embodied therewith, said program instructions executable by said one or more processors to cause said one or more processors to:
• set up a structure of a secondary database identical to a primary database;
• configure parallel execution degrees of data objects to be copied from said primary database to said secondary database;
• build a working set of data objects to be copied from said primary database to said secondary database;
• prioritize data objects in said working set of data objects to be copied from said primary database to said secondary database over other data objects;
• copy data objects in parallel from said primary database to said secondary database using a data streaming protocol for said prioritized data objects;
• restore data corresponding to said data objects in said secondary database in parallel to said copying data objects from said primary database to said secondary database;
• apply changes made to said data corresponding to a first data object of said data objects in said primary database during said copying of said first data object to corresponding elements in said secondary database, after said first data object has been copied;
• and activate said secondary database for use as a duplicate of said primary database, subsequent to said copy, said restore, and said apply of changes of all data objects from said primary database to said secondary database.

A computer program product for generating a copy of a database using a data streaming protocol database, said computer program product comprising:

• a computer readable storage medium having program instructions embodied therewith, said program instructions being executable by one or more computer processors to cause said one or more computer processors to:
• set up a structure of a secondary database identical to a primary database;
• configure parallel execution degrees of data objects to be copied from said primary database to said secondary database;
• build a working set of data objects to be copied from said primary database to said secondary database;
• prioritize data objects in said working set of data objects to be copied from said primary database to said secondary database over other data objects;
• copy data objects from said primary database to said secondary database using a data streaming protocol for said prioritized data objects;
• restore data corresponding to said data objects in said secondary database in parallel to said copying data objects from said primary database to said secondary database;
• apply changes made to said data corresponding to a first data object of said data objects in said primary database during said copying of said first data object to corresponding elements in said secondary database, after said first data object has been copied;
• and
• activate said secondary database for use as a duplicate of said primary database subsequent to said copy, said restore, and said apply of changes of all data from said primary database to said secondary database.

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;
• configuring, by the one or more computer processors, a degree of parallel copy execution of a data streaming protocol;
• refining 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;
• 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 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 copied data objects in 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.

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.