Method and System for Data Processing with High Availability

1. A method for database processing in a database management system including a plurality of database processors each having a database processing program, the system holding a database divided into multiple storage regions and processing the database by executing the database processing program assigned to the corresponding storage region, the method comprising the steps of: determining a destination database processor from the database processors in service when failure of a database processor is detected; assigning the storage region assigned to the failed database processor by the destination database processor to a database processing program that operates in the destination database processor; and starting the database processing program in the destination database processor, wherein the step of determining a destination database processor when failure of a database processor is detected comprises: referring to switchover-destination-in-failure information including the name of the failed database processor and the name of a database processor that is to be the destination database processor when failure occurs, obtaining a name of a database processor that is included in the switchover-destination-in-failure information and is associated with the failed database processor, and determining the database processor indicated by the obtained names of the database processor to be the destination database processor.

2. The method for database processing according to claim 1 , wherein the switchover-destination-in-failure information is generated in advance on instruction from a user.

3. The method for database processing according to claim 2 , wherein the policy is generated to switch all the plurality of database processing programs contained in the specified database processor to different units, or to switch the database processing programs equally in number to specified database processors.

4. The method for database processing according to claim 1 , wherein the switchover-destination-in-failure information is generated by the database management system in advance according to a policy given from a user.

5. A method for database processing in a database management system including a plurality of database processors each having a database processing program, the system holding a database divided into multiple storage regions and processing the database by executing the database processing program assigned to the corresponding storage region, the method comprising the steps of: determining a destination database processor from the database processors in service when failure of a database processor is detected; assigning the storage region assigned to the failed database processor by the destination database processor to a database processing program that operates in the destination database processor; and starting the database processing program in the destination database processor, wherein when failure of a database processor is detected, the step of determining a destination database processor of the failed database processor comprises: referring to a policy given from a user in advance, when a reference result is a database processor with a light load, comparing the load of a database processor with the loads of the other database processors, wherein when the load of the database processor is lighter, determining the database processor to be the destination, when the reference result is a database processor with an empty resource, comparing the space of the resources including a memory of the database processor and a control block disposed on the memory with the space of the resources of the other database processors, wherein when the space of the resources the database processor is larger, determining the database processor to be the destination, and when the reference result is to switch the DB access servers equally to multiple specified database processor in service, obtaining an operating state of the other database processors and determining the database processor to be the destination from the number of the operating database processors.

6. A program, stored on a storage medium, for database processing in a database management system including a plurality of database processors each having a database processing program, the system holding a database divided into multiple storage regions and processing the database by executing the database processing program assigned to the corresponding storage region, the program, when executed, causes the database management system to perform the steps of: determining a destination database processor from the database processors in service when failure of a database processor is detected; assigning the storage region assigned to the failed database processor by the destination database processor to a database processing program that operates in the destination database processor; and starting the database processing program in the destination database processor, wherein the step of determining a destination database processor when failure of a database processor is detected comprises: referring to switchover-destination-in-failure information including the name of the failed database processor and the name of a database processor that is to be the destination database processor when failure occurs, obtaining a name of a database processor that is included in the switchover-destination-in-failure information and is associated with the failed database processor, and determining the database processor indicated by the obtained names of the database processor to be the destination database processor.

7. The program according to claim 6 , wherein the switchover-destination-in-failure information is generated in advance on instruction from a user.

8. The program according to claim 7 , wherein the policy is generated to switch all the plurality of database processing programs contained in the specified database processor to different units, or to switch the database processing programs equally in number to specified database processors.

9. The program according to claim 6 , wherein the switchover-destination-in-failure information is generated by the database management system in advance according to a policy given from a user.

10. A program, stored on a storage medium, for database processing in a database management system including a plurality of database processors each having a database processing program, the system holding a database divided into multiple storage regions and processing the database by executing the database processing program assigned to the corresponding storage region, the program, when executed causes the database management system to perform the steps of: determining a destination database processor from the database processors in service when failure of a database processor is detected; assigning the storage region assigned to the failed database processor by the destination database processor to a database processing program that operates in the destination database processor; and starting the database processing program in the destination database processor, wherein when failure of a database processor is detected, the step of determining a destination database processor of the failed database processor comprises: referring to a policy given from a user in advance, when a reference result is a database processor with a light load, comparing the load of a database processor with the loads of the other database processors, wherein when the load of the database processor is lighter, determining the database processor to be the destination, when the reference result is a database processor with an empty resource, comparing the space of the resources including a memory of the database processor and a control block disposed on the memory with the space of the resources of the other database processors, wherein when the space of the resources the database processor is larger, determining the database processor to be the destination, and when the reference result is to switch the DB access servers equally to multiple specified database processor in service, obtaining an operating state of the other database processors and determining the database processor to be the destination from the number of the operating database processors.

11. A database management system for database processing comprising: a plurality of database processors each having a database processing program; and a database divided into multiple storage regions, wherein the database is processed by executing the database processing program assigned to the corresponding storage region, wherein said database management system determines a destination database processor from the database processors in service when failure of a database processor is detected, assigns the storage region assigned to the failed database processor by the destination database processor to a database processing program that operates in the destination database processor, and starts the database processing program in the destination database processor, wherein the processing of determining a destination database processor when failure of a database processor is detected comprises: referring to switchover-destination-in-failure information including the name of the failed database processor and the name of a database processor that is to be the destination database processor when failure occurs, obtaining a name of a database processor that is included in the switchover-destination-in-failure information and is associated with the failed database processor, and determining the database processor indicated by the obtained names of the database processor to be the destination database processor.

12. The database management system according to claim 11 , wherein the switchover-destination-in-failure information is generated in advance on instruction from a user.

13. The database management system according to claim 12 , wherein the policy is generated to switch all the plurality of database processing programs contained in the specified database processor to different units, or to switch the database processing programs equally in number to specified database processors.

14. The database management system according to claim 11 , wherein the switchover-destination-in-failure information is generated by the database management system in advance according to a policy given from a user.

15. A database management system for database processing comprising: a plurality of database processors each having a database processing program; and a database divided into multiple storage regions, wherein the database is processed by executing the database processing program assigned to the corresponding storage region, wherein said database management system determines a destination database processor from the database processors in service when failure of a database processor is detected, assigns the storage region assigned to the failed database processor by the destination database processor to a database processing program that operates in the destination database processor, and starts the database processing program in the destination database processor, wherein when failure of a database processor is detected, the processing of determining a destination database processor of the failed database processor comprises: referring to a policy given from a user in advance, when a reference result is a database processor with a light load, comparing the load of a database processor with the loads of the other database processors, wherein when the load of the database processor is lighter, determining the database processor to be the destination, when the reference result is a database processor with an empty resource, comparing the space of the resources including a memory of the database processor and a control block disposed on the memory with the space of the resources of the other database processors, wherein when the space of the resources the database processor is larger, determining the database processor to be the destination, and when the reference result is to switch the DB access servers equally to multiple specified database processor in service, obtaining an operating state of the other database processors and determining the database processor to be the destination from the number of the operating database processors.