Database system management method and database system

Abstract

A control device 10 at a main center, in order for an update carried out in an operation database device M to be also conducted in an operation database device S at a sub-center, generates and transmits a differential log file 16 to a control device 20 at the sub-center. The control device 20 at the sub-center, when receiving a differential log file 22, updates the operation database device S on the basis of the log information in the differential log file 22, and accumulates the log information in a recovery log file 26. The log information of a recovery point set at the main center is incorporated into this recovery log file 26.

Description

BRIEF DESCRIPTION OF THE SEVERAL VIEWS OF THE DRAWING

FIG. 1 is a diagram showing architecture of a database system in the present embodiment;

FIG. 2 is a diagram showing a configuration of a control device within a main center;

FIG. 3 is a diagram showing a configuration of a control device within a sub-center;

FIG. 4 is a table showing one example of a data structure of a recovery log file of the main center;

FIG. 5 is a flowchart showing a flow of processes executed by a database clone generating module of a replica-side control device;

FIG. 6 is a flowchart showing a flow of a recovery information incorporating subroutine;

FIG. 7 is a flowchart showing a flow of the recovery information incorporating subroutine;

FIG. 8 is a view of one example of a data structure of an extraction file;

FIG. 9 is a flowchart showing a flow of a reflection subroutine;

FIG. 10 is a table showing one example of a data structure of a recovery log file of the sub-center;

FIG. 11 is an explanatory diagram schematically showing how an operation database device is, after getting unusable due to occurrence of disaster etc at the main center, restored to an operation enabled state;

FIG. 12 is a table showing one example of a data structure of the recovery log file of the main center;

FIG. 13 is a view of one example of the data structure of the table of the extraction file; and

FIG. 14 is a table showing one example of the data structure of the recovery log file of the sub-center.

Claims

1. A database system management method for managing a database system configured by a main center system having a first processing device which generates operation data by executing transaction constituting an operation according to request that has been sent via a network from any one of operation terminal computers in a normal state and having a first database device which stores the operation data or updates the stored data by new operation data at every time when new operation data are generated, and a sub-center system having a second processing device and a second database device respectively having same functions as that said first processing device and said first database device have, said method comprising: a first log information generating step in which said first processing device generates, whenever the operation data are updated within said first database device, its log information as first log information;an incorporating step in which said first processing device incorporates predetermined first delimiter information into an interval between two consecutive arbitrary pieces of first log information generated in said first log information generating step;a transmitting step in which said first processing device transmits the series of first log information into which the delimiter information is incorporated in said incorporating step to said second processing device;an updating step in which said second processing device divides the series of first log information transmitted in said transmitting step into plural groups and executes, for each of plural groups, update of the operation data stored in said second database device on the basis of the respective first log information constituting the group;a second log information generating step in which said second processing device generates, whenever the operation data are updated in said second database device in said updating step, its log information as second log information; anda storing step in which said second processing device incorporates second delimiter information associated with the first delimiter information into an interval corresponding to the interval within the series of second log information generated in said second log information and stores the series of the second log information in which the second delimiter information is incorporated.

2. A database system management method according to claim 1, the predetermined first delimiter information is incorporated into interval designated by any one of said operation terminal computers among intervals within the series of first log information.

3. A database system management method for operating a database system configured by a main center system having a first processing device which generates operation data by executing transaction constituting an operation according to request that has been sent via a network from any one of operation terminal computers in a normal state and having a first database device which stores the operation data or updates the stored data by new operation data at every time when new operation data are generated, and a sub-center system having a second processing device and a second database device respectively having same functions as that said first processing device and said first database device have, said method comprising: a first log information generating step in which said first processing device generates, whenever the operation data are updated within said first database device, its log information as first log information;a transmitting step in which said first processing device transmits the pieces of first log information generated in said first log information generating step to said second processing device;an updating step in which said second processing device updates the operation data in said second database device on the basis of the first log information transmitted in said transmitting step;a second log information generating step in which said second processing device generates, whenever the operation data are updated in said second database device in said updating step, its log information as second log information; andan associating step in which said second processing device associates the second log information generated in said second log information generating step with the first log information by adding time information contained in the first log information to each piece of second log information.

4. A database system management method according to claim 1 or 3, wherein said first processing device generates, in said first log information generating step, if transaction of which executing result should be reflect on plural database tables included in said first database device, the log information for each of those database tables.

5. A database system configured by a main center system having a first processing device which generates operation data by executing transaction constituting an operation according to request that has been sent via a network from any one of operation terminal computers in a normal state and having a first database device which stores the operation data or updates the stored data by new operation data at every time when new operation data are generated, and a sub-center system having a second processing device and a second database device respectively having same functions as that said first processing device and said first database device have, said first processing device comprising: a first log information generating unit generating, each time when the operation data are updated within said first database device, update log information thereof as first log information;a incorporating unit incorporating predetermined first delimiter information into an interval between two consecutive arbitrary first log information generated by said first log information generating unit; anda transmitting unit transmitting the respective pieces of first log information into which the delimiter information is incorporated by said incorporating unit to said second processing device; and said second processing device comprising:an updating unit dividing the series of first log information transmitted by said transmitting unit into plural groups and executing, for each of plural groups, update of the operation data stored in said second database device on the basis of the respective first log information constituting the group;a second log information generating unit generating, whenever the operation data are updated in said second database device by said updating unit, its log information as second log information; anda storing unit incorporating second delimiter information associated with the first delimiter information into an interval corresponding to the interval within the series of second log information and storing the series of the second log information in which the second delimiter information is incorporated.