Patent ID: 8510269

Claim:
A method for reorganizing a first database, comprising: using one or more computer systems to determine, based on one or more control statements, that a new index structure of a first database is required, the one or more control statements comprising one or more DBMS control statements that identify that the first database has been modified and that an index structure of the first database requires reorganization to reflect the modification to the first database; in response to determining that the new index structure of the first database is required, using the one or more computer systems to create a second database; using the one or more computer systems to copy data from the first database to the second database, the second database having an index structure that is different from the index structure of the first database such that the index structure of the second database is updated to include the modification to the first database; using the one or more computer systems to update the second database to reflect a modification made to the first database since the commencement of the copying; and switching the second database for the first database.