Patent ID: 8429129

Claim:
A database restructuring apparatus for migrating a current database in a first volume to a second volume, the database restructuring apparatus comprising: a processor 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.