Patent ID: 7899851

Claim:
A database management method in a database management system comprising a plurality of database processing modules executed in a database server which are coupled to a front-end module and access to data composing a database table, a first storage which is shared by said plurality of database processing modules and stores said data composing the database table which is divided into a plurality of partitioned tables each assigned to one of said plurality of database processing modules, a second storage which is shared by each of said plurality of database processing modules and has a first index area storing indexes for said database table, said first index area being divided into a plurality of partitioned index areas each corresponding to respective ones of said partitioned tables and being assigned to one of said plurality of database processing modules to which a corresponding partitioned table is assigned, and a plurality of third storages, each of which is exclusively coupled to one of said database processing modules and have a second index area including indexes for a whole of said partitioned tables which are assigned to the database processing module to which the third storage having the second index area is coupled, said method being executed by the database processing modules, and comprising the steps of: invalidating indexes of said second index areas; altering configuration of the database management system whereby each of said plurality of partitioned tables is reassigned to one of said plurality of database processing modules and each of said plurality of partitioned index areas is reassigned to one of said plurality of database processing modules to which the corresponding partitioned table is reassigned; re-creating indexes of said second index areas; accessing, by said database processing modules, to said database table by using indexes of said first index area while the indexes of said second index area are being re-created; and validating indexes of said second index areas when re-creation of the indexes of said second index are completed.