Database restructuring apparatus, and computer-readable recording medium recording database restructuring program

A computer-readable, non-transitory medium recording a database restructuring program for migrating a current database in a first volume to a second volume, the database restructuring program causing a computer to execute a procedure comprising:

• creating a switching destination database in the second volume, and generating a switching destination schema defining a data structure of the switching destination database;
• sequentially copying data from an extent range of the current database which is specified by extent range information to the switching destination database, while updating copy address information according to progress of said copying so as to manage which portion of the specified extent range has already been copied;
• distributing online electronic messages as data update access to the current database;
• specifying, when an online electronic message is input to the current database, a physical position in the current database using a current schema defining a data structure of the current database, and accessing the specified physical position in the current database;
• updating, responsive to a data update access received during said copying, both the current database and switching destination database when a target address of the data update access is equal to or smaller than an address indicated by the updated copy address information;
• switching, after completion of said copying, a distribution destination of online electronic messages from the current database to the switching destination database, such that only the switching destination database is to be updated when a data update access to copied data is received;
• and
• specifying, when an online electronic message is input to the switching destination database, a physical position in the switching destination database using the switching destination schema, and accessing the specified physical position in the switching destination database.

A database restructuring method for migrating a current database in a first volume to a second volume, the database restructuring method comprising:

• creating a switching destination database in the second volume, and generating a switching destination schema defining a data structure of the switching destination database;
• sequentially copying data from an extent range of the current database which is specified by extent range information to the switching destination database, while updating copy address information according to progress of said copying so as to manage which portion of the specified extent range has already been copied;
• distributing online electronic messages as data update access to the current database;
• specifying, when an online electronic message is input to the current database, a physical position in the current database using a current schema defining a data structure of the current database, and accessing the specified physical position in the current database;
• updating, responsive to a data update access received during said copying, both the current database and switching destination database when a target address of the data update access is equal to or smaller than an address indicated by the updated copy address information;
• switching, after completion of said copying, a distribution destination of online electronic messages from the current database to the switching destination database, such that only the switching destination database is to be updated when a data update access to copied data is received;
• and
• specifying, when an online electronic message is input to the switching destination database, a physical position in the switching destination database using the switching destination schema, and accessing the specified physical position in the switching destination database.