JP2939414B2 - Database Equivalent Processor for Dual Computer - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an apparatus for equivalently storing data of the same general-purpose common language among a plurality of databases in a dual computer.

[0002]

2. Description of the Related Art FIG.
FIG. 1 is a configuration diagram illustrating a conventional database equivalence processing device of a dual computer disclosed in Japanese Unexamined Patent Publication. In FIG. 14,
1 is an A-system server computer, 2 is an A-system database of the A-system server computer 1, 2a is an A-system total data storage database of the A-system server computer 1,
3 is a B-system server computer, 4 is a B-system database of the B-system server computer 3, 3a is a B-system all data storage database of the B-system server computer 3,
Reference numeral 6 denotes a client computer having a general-purpose common language, and reference numeral 5 denotes a bus-type transmission line that connects the A-system server computer 1 and the B-system server computer 3 to the client computer 6.

Next, the operation of the above-mentioned conventional database equivalence processing device for a dual computer will be described. When the client computer 6 instructs the A-system / B-system server computers 1 and 3 to change the data using the bus-type transmission line 5, the A-system and B-system server computers 1 and 3 store their own data in their databases 2 and 4, respectively. To change at the same time. As a result, the databases 2 and 4 have an equivalent data storage state in which the data is kept in the same state.

During the data change, if the B-system server computer 3 stops functioning for some reason and
If the system database 4 cannot be changed, only the system A database 2 is updated, so that the system B database 4 is out of date and the data of the system B database 4 is inconsistent with the data of the system A database 2. Occurs.
At this time, in order to resolve the inconsistency of data in the A-system / B-system databases 2 and 4, the client computer 6 uses the B-system server computer 3 by its abnormality monitoring function.
Monitor the normal return of. Then, when the B-system server computer 3 returns to a normal state, the client computer 6 causes the A-system / B-system server computers 1 and 3 to make the data of the B-system database 4 equal to the A-system database 2 by the database management function. Is given. This equivalent process is specifically achieved by the following processes (1) to (3).

(1) The A-system server computer 1 downloads all data in the A-system database 2 to the A-system full data storage database 2a. That is, all the data of the A-system database 2 is stored in the A-system all data storage database 2a. Then, the A-system server computer 1 transfers the data of the A-system full data storage database 2a to the B-system server computer 3 using the bus-type transmission path 5.

(2) The B-system server computer 3 writes (copies) the data of the A-system all data storage database 2a transferred from the A-system server computer 1 to the B-system database 4.

(3) If the data in the A-system database 2 is changed during the processing of (1) and (2),
Since the data in the B-system database 4 does not become equivalent to the data in the A-system database 2, the client computer 6 keeps the data in the A-system database 2 in the A-system server computer 1 during the operations (1) and (2). Prohibit updating of. Alternatively, the client computer 6 takes (1) and (2) the working transaction log by its database management function and reflects it in the B system database 4, but during the reflection of the transaction log, the A system database 2 If it is changed, the B-system database 4 will not be in the latest equivalent state as described above.
Prohibits updating of data in the A-system database 2 in the A-system server computer 1.

[0008]

As described above, the above-described conventional database equivalent processing apparatus of the dual computer reads all the data of the A-system database 2 into the A-system full data storage database 2a and then transfers the data to the B-system database 4. There is a problem that it takes a lot of processing time because the configuration is such that all data input processing is performed.

The present invention has been made to solve the above-mentioned problems. A first object is to increase the processing speed, and a second object is to enable data updating even during equivalent processing.
The fourth object is to increase the reliability of data equalization, the fourth object is to be able to respond to data update from a plurality of client computers, the fifth object is to be able to select an equalization process according to the situation, and the sixth object is to be equivalent. This is to reduce the restriction on the processing data and continue the equivalent processing even if an abnormality occurs.

[0010]

According to a first aspect of the present invention, there is provided a database equivalent processing apparatus for a dual computer, wherein a client computer having data in a general-purpose common language is connected to a client computer having a bus-type transmission path. Databases of a plurality of connected server computers each have a difference data storage area for storing a difference between data stored therein, and a client computer has a transfer unit and a copy unit. One of the plurality of server computers issues an instruction to transfer the difference data stored in the difference data storage area to the other server computer, and the copying means performs the difference data transfer to the other server computer. Is instructed to copy to the difference data storage area.

According to a second aspect of the present invention, in the database equivalence processing apparatus for a dual computer according to the second aspect, the client computer according to the first aspect of the present invention has a comparing means, and the comparing means comprises the comparing means of the first aspect. After the copying by the copying means from one differential data storage area to the other differential data storage area is completed, the two data amounts are compared. If the two data amounts do not match, the copy data in the other differential data storage area is deleted. Further, copying from one differential data storage area to the other differential data storage area is performed again.

According to a third aspect of the present invention, in the database equivalence processing apparatus for a dual computer according to the third aspect, the database of the first invention is provided with an update instruction storage area, and the client computer or the plurality of servers are provided. One of the computers is provided with an update instruction means, and the update instruction means writes an update instruction in the equivalent processing to the update instruction storage area when performing equivalent processing from one database to the other database. The configuration is such that the equivalent processing is repeated until there is no more storage area.

According to a fourth aspect of the present invention, there is provided a database equivalence processing apparatus for a dual computer according to the fourth aspect, wherein the plurality of server computers of the first invention have a verification means, and the verification means comprises the first This is a configuration for verifying the consistency of the database amount after copying from one database to the other database by the copying means of the present invention.

According to a fifth aspect of the present invention, in the database equivalence processing device for a dual computer according to the fifth aspect, the plurality of server computers of the first invention have update order means, and the update order means has a plurality of update order means. In response to the data update from the client computer, the differential data is written to the differential data storage area in the same transaction as the data update, and a serial number in time order is given to the differential data.

According to a sixth aspect of the present invention, there is provided a database equalization processing apparatus for a dual computer according to the first aspect of the present invention, wherein the plurality of server computers of the first invention store data by the all data equalization process. Any one of the plurality of server computers or the client computers has a comparison and selection unit, and the comparison and selection unit is configured such that the ratio of the difference data capacity to the difference data storage area with respect to the storage area of the database is smaller than the reference value. Is configured to execute a differential data equalization process using a differential data storage area, and execute an all data equalization process using an all data storage database when the above ratio exceeds a reference value.

According to a seventh aspect of the present invention, there is provided a database equalization processing apparatus for a dual computer, wherein the plurality of server computers according to the first invention store data by all data equalization processing. Any one of the plurality of server computers or the client computers has a comparison determination unit, and the comparison determination unit stores the difference data when the difference data amount to the difference data storage area is smaller than the difference data storage area. When the difference data amount exceeds the difference data storage area, a difference data equalization process using the entire data storage database is executed.

According to an eighth aspect of the present invention, there is provided a database equalization processing apparatus for a dual computer according to the eighth invention, wherein the plurality of server computers of the first invention store data by all data equalization processing. Any of the plurality of server computers or the client computers has an abnormality countermeasure unit, and the abnormality countermeasure unit is configured to determine the difference when an error occurs during the differential data equalization processing of the difference data to the difference data storage area. The configuration is such that the data equalization processing is stopped and the all data equalization processing using the all data storage database is executed.

[0018]

According to a first aspect of the present invention, a database equivalent processing apparatus for a dual computer copies a difference described in a general-purpose common language from a difference data storage area of one database to a difference data storage area of another database. By making a change to the other database with the difference data, the equivalent processing speed of the database is increased.

In a second aspect of the invention, the database equivalence processing device for a dual computer compares the number of general-purpose common languages of the difference data before and after copying, and performs the equalization processing of the difference data until the number of characters before and after the copying matches. By repeating, the data can be updated even during the equivalent processing.

The database equivalence processing device of the dual computer according to the third invention copies the difference data from the difference data storage area of one database to the difference data storage area of the other database until there is no difference data. By making changes to the other database with data, data can be updated while making changes to the database.

The database equivalence processing device of the dual computer according to the fourth aspect of the present invention increases the reliability of data equivalence by verifying the consistency of the database amount after data equivalence.

According to a fifth aspect of the present invention, the database equivalence processing device of the dual computer writes the difference data in the same transaction as the data update for the data update, and gives the difference data a serial number in time order, so that the plurality of clients can receive the data. Data can be easily updated.

In a sixth aspect of the present invention, the database equalization processing apparatus for a dual computer compares the data capacity of the difference data with the entire data capacity, and performs the difference data equalization processing for copying the difference data and the entire data by the ratio between the two. By selecting the faster one of all data equivalent processes to be copied, the processing speed is increased.

In a seventh aspect of the present invention, the database equalization processing apparatus for a dual computer selectively uses difference data equalization processing and all data equalization processing depending on whether or not difference data exceeds a predetermined capacity. Restrictions are eliminated.

According to an eighth aspect of the present invention, when an error occurs during the differential data equalization process, the database equalization processing device of the dual computer suspends the difference data equalization process, and performs the all data equalization process to obtain the data. Equivalent reliability increases.

[0026]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, embodiments of the present invention will be described with reference to FIGS.
In the following description, the same parts as those of the above-described conventional example are denoted by the same reference numerals. Embodiment 1 (corresponding to claim 1). FIG. 1 is a configuration diagram illustrating the database equivalence processing device of the dual computer according to the first embodiment. In FIG. 1, an A-system server computer 1 and a B-system server computer 3 are connected to a client computer 6 via a bus-type transmission line 5, and the A-system server computer 1 includes an A-system database 2; 2 is provided with an A-system difference data storage area 7 for storing an update for the A-system database 2, and a B-system server computer 3 is provided with a B-system database 4. Is provided in the B-system difference data storage area 8 for storing the data. The client computer 6 has data 6a stored in a general-purpose common language such as SQL, for example, and includes a transfer unit 6b and a copy unit 6c.

Next, the operation of the first embodiment will be described.
The client computer 6 transfers the same data to the A-system / B-system databases 2 and 4 at the same time by transferring the same data to the A-system / B-system server computers 1 and 2 by the two-phase commitment method using the bus-type transmission line 5. change.
That is, the A-system / B-system server computers 1 and 3 change the data of the A-system and B-system databases 2 and 4 at the same time by receiving the data change instruction from the client computer 6. Becomes an equivalent storage state of data. However, during the data change, if the B-system database 4 is not changed due to the stoppage of the function of the B-system server computer 3, the data of the B-system database 4 will not be updated and the data of the A-system database 2 will not be updated. A discrepancy occurs, and the data of the B-system database 4 and the A-system database 2 become unequal. Therefore, the client computer 6 monitors the malfunction of the B-system server computer 3 by the abnormality monitoring function and the normal recovery of the function recovery, and when the B-system server computer 3 returns to the normal state, the client computer 6 performs the operation. A system by database management function
An equivalent processing instruction for making the data in the B-system database 4 equal to the data in the A-system database 2 is given to the B-system server computers 1 and 3. This equivalent processing is specifically described in (1) below.
This is achieved by the processing of (4).

(1) When the client computer 6 receives an error message indicating an abnormality of the B-system server computer 3 in the two-phase commitment system, the client computer 6 issues a write instruction to the A-system differential data storage area 7 based on the data change instruction. Give to computer 1. In response to this instruction, the A-system server computer 1 converts the instruction accompanying the data change of the A-system database 2 into a character string of a general-purpose common language.
The data is written to the system difference data storage area 7.

(2) When the client computer 6 receives the available message indicating the abnormal recovery of the B-system server computer 3 by the two-phase commitment system, the client computer 6 sends the A-system server computer 1 to the A-system server computer 1 by the transfer means 6b. System difference data storage area 7
Is transferred to the B-system server computer 3 only. The A-system server computer 1 having received the transfer instruction transfers only the contents stored in the A-system difference data storage area 7 to the B-system server computer 3 using the bus-type transmission path 5. After the completion of the transfer, the client computer 6 gives an instruction to the B-system server computer 3 to copy to the B-system difference data storage area 8 transferred from the A-system server computer 1 by the copying means 6c. Upon receiving the copy instruction, the B-system server computer 3 writes (copies) a character string in a general-purpose common language as transfer data from the A-system difference data storage area 7 to the B-system difference data storage area 8. After the copying is completed, the client computer 6 sends the A
An instruction to delete the contents of the system difference data storage area 7 is given. By this erasure instruction, the A-system server computer 1
Deletes the data in the A-system difference data storage area 7.

(3) Subsequently, the client computer 6 gives an instruction to change the contents of the B-system database 4 to the B-system server computer 3 by the copying means 6c. By this change instruction, the B-system server computer 3
Reads a character string in a general-purpose common language from the B-system difference data storage area 8 and uses the read contents as a B-system database 4
Is changed (the B system database 4 is updated), and after the change, the data in the B system difference data storage area 8 is deleted.

(4) During the processing of the above (1) to (4),
The client computer 6 gives the A-system server computer 1 an instruction to prohibit the A-system database 2 from updating data. That is, if the data of the A-system database 2 is updated during the processing of (1) to (4), the B-system database 4 does not become the latest state. To prevent this,
During the processing of (1) to (4), updating of the A-system database 2 is prohibited. As a result, by the processes (1) to (4), one cycle of the data equalization process of the A-system database 2 and the B-system database 4 is completed.

Embodiment 2 (corresponding to claim 2). FIG. 2 is a configuration diagram showing a database equivalence processing device of a dual computer according to the second embodiment, and FIG. 3 is a flowchart showing the equivalence processing of the second embodiment. It is characterized in that the A-system database 2 can be updated except for the above operation.

In FIG. 2, the A-system / B-system server computers 1 and 3 are separately provided with A-system / B-system databases 2 and 4 including A-system and B-system differential data storage areas 7 and 8, respectively.
The B-system server computers 1 and 3 are connected to a client computer 6 via a bus-type transmission line 5. The client computer 6 holds data 6a composed of a general-purpose common language and includes a transfer unit 6b and a copying unit 6c as shown in FIG. A comparison means 6d for executing the processing shown is provided.

Next, the operation of the second embodiment will be described with reference to FIG. (1) Upon receiving, for example, an error message indicating an abnormality in the B-system server computer 3, the client computer 6 gives the A-system server computer 1 an instruction to write to the A-system difference data storage area 7 based on the data change instruction. In response to this instruction, the A-system server computer 1 writes, in the A-system difference data storage area 7, a command that has changed the data of the A-system database 2 in accordance with the data change of the A-system database 2 as a character string in a general-purpose common language. (2) When the client computer 6 receives the usable message indicating the abnormal recovery of the B-system server computer 3 in the two-phase commitment system, the client computer 6 causes the transfer means 6b and the copying means 6c to execute the A-system difference data storage area 7 Is executed to copy the data of step S1 into the B-system difference data storage area 8 (step 10).
1).

(3) When the above-mentioned copying process is completed, the client computer 6 performs the processes after step 102 by the comparing means 6d. That is, in steps 102 and 103, the number of characters of the general-purpose common language character string in the A-system data storage area 7 and the number of general-purpose common language character strings in the B-system data storage area 8 are counted. Subsequently, in step 104, it is checked whether the number of characters in the A / B difference data storage areas 7 and 8 is the same.

(4) If the number of characters is the same,
It is predicted that the data in the B-system difference data storage areas 7 and 8 are the same, and
Is changed in the B-system database 4 with the contents of the character string of the general-purpose common language, and after the change, the data in the A-system / B-system difference data storage areas 7 and 8 is deleted in step 106, and one cycle of the equivalent processing is completed I do.

(5) If the number of characters is different, it means that the data in the A-system / B-system difference data storage areas 7 and 8 are not the same, so in step 107 the data in the B-system difference data storage area 8 is deleted. Returning to step 101, the character string of the general-purpose common language sentence is copied from the A-system difference data storage area 7 to the B-system difference data storage area 8 again. Steps 101 to 104 and step 107 are repeated until the number of characters becomes the same.

In short, according to the second embodiment, when performing the equivalent processing from the A-system difference data storage area 7 to the B-system difference data storage area 8, the A-system / B-system difference data storage areas 7, 8
Is repeated from the A-system difference data storage area 7 to the B-system difference data storage area 8 until they become the same, so that the general-purpose common data of the B-system difference data storage area 8 in step 105 described in (4) above is used. During most operations other than the period in which the contents of the language character strings are changed in the B-system database 4, the data of the A-system database 2 can be updated. In other words, when the data of the A-system database 2 is updated during the equivalence processing from the A-system difference data storage area 7 to the B-system difference data storage area 8, the general-purpose data of the A-system difference data storage area 7 is updated with the data update. The character string of the common language is also automatically changed, and as a result, the processing of steps 101 to 104 and step 107 is repeated, and the latest data after updating the data of the A-system database 2 is stored in the B-system database 4. You. Therefore, even if the data of the A-system database 2 is updated during the equivalence processing from the A-system difference data storage area 7 to the B-system difference data storage area 8, the A-system / B-system databases 2 and 4 after the equalization processing are updated. Equivalent integrity can be ensured.

Embodiment 3 (corresponding to claim 3). FIG. 4 is a configuration diagram showing a database equivalence processing device of a dual computer according to the third embodiment. This embodiment 3 is characterized in that the A system database 2 can be updated during data equivalence processing. .

Referring to FIG. 4, a client computer 6 has data 6a in a general-purpose common language, and has an update instruction means 6e in addition to a transfer means 6b and a copying means 6c.
The system / B system server computers 1 and 3 are connected by a bus-type transmission line 5, and in the A system database 2 owned by the A system server computer 1, in addition to the A system difference data storage area 7,
A system update instruction storage area 7a is provided, and a B system update instruction storage area 8a is provided in the B system database 4 owned by the B system server computer 3 in addition to the B system difference data storage area 8.

Next, the operation of the third embodiment will be described. (1) When the client computer 6 receives the error message indicating the abnormality of the B-system server computer 3,
A write instruction to the A-system difference data storage area 7 is given to the A-system server computer 1 based on the data change instruction.
In response to this instruction, the A-system server computer 1 converts the command in which the data of the A-system database 2 is changed in accordance with the change of the data of the A-system database 2 into a character string of a general-purpose common language.
The data is written to the system difference data storage area 7. (2) When the client computer 6 receives the usable message indicating the abnormal recovery of the B-system server computer 3 in the two-phase commitment system, the client computer 6 causes the transfer means 6b and the copying means 6c to execute the A-system difference data storage area 7 After performing the copying process of the data in the A-system difference data storage area 8, the A-system server computer 1 deletes the data in the A-system difference data storage area 7. (3) Subsequently, the client computer 6 gives an instruction to change the contents of the B-system database 4 to the B-system server computer 3 by the copying means 6c. In response to this change instruction, the B-system server computer 3 reads a character string in a general-purpose common language from the B-system difference data storage area 8,
The B-system database 4 is changed with the read contents, and after the change, the data in the B-system difference data storage area 8 is deleted. (4) During the processing of (2) and (3) above, the client computer 6 instructs the A-system server computer 1 to store an update instruction during data update in the A-system update instruction storage area 7a by the update instruction means 6e. give. In response to this instruction, the A-system server computer 1 writes an update instruction during data update to the A-system update instruction storage area 7a. (5) The above (3) and (4) are repeated until the A-system update storage area 7a becomes empty.

In short, according to the third embodiment, during the equivalent processing from the A-system difference data storage area 7 to the B-system difference data storage area 8 by the operations (4) and (5), 2 is updated, an update instruction accompanying the data update is written to the A-system update instruction storage area 7a, and the A-system update instruction storage area 7a is updated.
The equivalent processing from the A-system difference data storage area 7 to the B-system difference data storage area 8 is repeated until A becomes empty.
The latest data after updating the data in the A-system database 2 is also sequentially stored in the B-system database 4. Therefore, even if the data in the A-system database 2 is updated during the entire equivalence processing from the A-system difference data storage area 7 to the B-system difference data storage area 8, the A
The data equivalent integrity of the B-system databases 2 and 4 can be ensured.

Embodiment 4 (corresponding to claim 4). FIG. 5 is a configuration diagram showing a database equivalent processing device of a dual computer according to the fourth embodiment. This fourth embodiment verifies the consistency of the data amount after copying from one database to the other database is completed. There is a feature.

In FIG. 5, A-system server computer 1
Has a verification means 9, and the B-system server computer 3 has a verification means 10. These verification means 9 and 10 verify the consistency of the data amount after copying from one database to the other database is completed. The client computer 6 has data 6a composed of a general-purpose common language and includes a transfer unit 6b and a copying unit 6c. A / B system server computers 1 and 3 are connected to the client computer 6 via a bus transmission line 5. , A system
The A-system / B-system database 2 having the A-system / B-system difference data storage areas 7 and 8 is stored in the B-system server computers 1 and 3.
4 are provided.

According to the fourth embodiment, for example, the copy from the A-system difference data storage area 7 to the B-system difference data storage area 8 and the B-system difference data storage Region 8 to B
After the completion of the data equivalent processing in which the change to the system database 4 is completed, the verification means 9 and 10
By verifying the consistency between the data amounts of the data and the B database 4, a simple check of the data consistency can be performed, and the reliability can be improved.

Embodiment 5 (corresponding to claim 5). FIG. 6 is a configuration diagram showing a database equivalent processing device of a dual computer according to the fifth embodiment. In the fifth embodiment, when data is updated from a plurality of client computers, difference data is transmitted in the same transaction as the data update. It is characterized in that it is written into the difference data storage area and a serial number in time order is given to the difference data.

In FIG. 6, the A-system server computer 1
Is provided with the update order means 11, and the B-system server computer 3
Includes an update order unit 12. These update order means 1
Reference numerals 1 and 12 denote a plurality of client computers 6A and 6B.
In response to the data update from, the difference data is written to the A-system / B-system difference data storage areas 7 and 8 in the same transaction as the data update, and the difference data is given a serial number in chronological order. These client computers 6A and 6B store data 6 in a general-purpose common language.
a and transfer means 6b and copy means 6c
And has the same function as the client computer 6 of the first embodiment. A-system / B-system server computers 1 and 3 are connected to these client computers 6A and 6B via a bus-type transmission line 5, and A-system and B-system difference data storage areas 7 are connected to the A-system and B-system server computers 1 and 3, respectively. , 8 are provided. Therefore, each of the plurality of client computers 6A and 6B can spread and communicate the same data between the A-system and B-system server computers 1 and 3 using the bus transmission path 5. Specifically, one client computer 6A transfers the same data to each of the A-system and B-system server computers 1 and 3 by spread communication using the bus-type transmission line 5, and the other client computer 6B transmits The same data is transferred to each of the B-system server computers 1 and 3 by spread communication using the bus transmission path 5. Each client computer 6
For each update from A, 6B to the A-system / B-system server computers 1, 3, the update ordering means 11, 12 writes the differential data to the A-system / B-system differential data storage areas 7, 8 in the same transaction as the data update. At the same time, a serial number in time order is given to the difference data.

In short, according to the fifth embodiment, the update order means 11 and 12 correspond to the A-system / B-system server computers 1 and
3, the update order means 11 and 12 receive data updates from a plurality of client computers 6A and 6B. Then, the update order means 11 updates the A-system database 2 and the A-system difference data storage area 7 within the same transaction, and gives the SQL statements in the A-system difference data storage area 7 serial numbers in time order. . Also,
The update ordering means 12 updates the B-system database 4 and the B-system difference data storage area 8 within the same transaction, and gives the SQL statements in the B-system difference data storage area 8 serial numbers in chronological order. As a result, the consistency of the order of the data update is determined by the plurality of client computers 6A and 6B.
Can be secured for the request.

Embodiment 6 (corresponding to claim 6). FIG. 7 is a configuration diagram showing a database equivalent processing device of a dual computer according to the sixth embodiment, FIG. 8 is an experimental result diagram for explaining reference values of the sixth embodiment, and FIG. 9 is a flowchart showing processing of the sixth embodiment. In the sixth embodiment, the A-system / B-system difference data storage areas 7, 8 for the storage areas of the A-system / B-system databases 2 and 4 are provided.
It is characterized in that all data equalization processing and difference data equalization processing are selectively used depending on the ratio of the difference data capacity described above.

In FIG. 7, a client computer 6 has data 6a in a general-purpose common language and includes a transfer means 6b and a copying means 6c. A / B system databases 2 and 4 having A / B system difference data storage areas 7 and 8 connected to A / B system server computers 1 and 3 and data by all data equalization processing. A and B-system all data storage databases 2a and 3a are provided. As one of the plurality of server computers 1 and 3 and the client computer 6, as an example, the plurality of server computers 1 and 3 are provided with a comparison / selection unit 1.
3 and 14 are provided. These comparison and selection means 13 and 14
When the ratio of the difference data capacity in the A-system / B-system difference data storage areas 7 and 8 to the storage areas of the A-system and B-system databases 2 and 4 is smaller than the reference value a, the A-system / B-system difference data storage When the ratio exceeds the reference value a, the differential data equalization processing using the areas 7 and 8 is executed, and the all data equalization processing using the A-system and B-system all data storage databases 2a and 3a is executed.

The reference value a will be described with reference to FIG. 8, the horizontal axis indicates the ratio of the difference data capacity in the A-system difference data storage area 7 to the storage area of the A-system database 2, and the vertical axis indicates the equivalent processing time as the processing time required equivalently. is there. Then, according to an error message indicating an abnormality of the B-system server computer 3, the copying from the A-system difference data storage area 7 to the B-system difference data storage area 8 and the copying from the B-system difference data storage area 8 to B
With respect to the data equivalence that has been changed to the system database 4, the difference data equalization process using the A system difference data storage area 7 and the all data equalization process using the A system all data storage database 2a are performed, and the difference data The result of measuring the equivalent processing time with respect to the ratio between the storage area of the A-system database 2 and the difference data capacity in the A-system difference data storage area 7 at the time of the equivalent processing is a straight line L1, and the A-system database 2 at the time of all data equivalent processing is obtained. The result obtained by measuring the equivalent processing time with respect to the ratio of the storage area to the total data capacity is a straight line L2. Considering FIG. 8, the straight line L1 representing the difference data equalization processing has a shorter equivalent processing time as the ratio of the difference data capacity is smaller, and the straight line L1 representing the difference data equalization processing has a high dependency on the difference data capacity. Further, the processing time of the straight line L2 representing the all data equivalent processing is not so short even if the ratio of the total data capacity is small, and the straight line L2 representing the all data equivalent processing has a low dependence on the total data capacity. Both straight lines L
1 and L2 intersect, and it can be seen that the equivalent processing time is equal at the intersection b. When the ratio of the difference data capacity at the intersection b was analyzed, it was found that the character capacity of the general-purpose common language in the A-system difference data storage area 7 was a times as large as the A-system database 2 storage area. Further, starting from the point that the character capacity of the general-purpose common language in the A-system difference data storage area 7 is a times as large as the storage capacity of the A-system database 2, the difference data capacity indicated by a straight line L1 indicates that the ratio of the difference data capacity is low. It can be understood that the equivalent processing time is shorter in the processing, and that the equivalent data processing time of the all data equivalent processing indicated by the straight line L2 is shorter when the ratio of the difference data capacity is higher. Therefore, in the sixth embodiment, the point at which the character capacity of the general-purpose common language in the difference data is a times the storage capacity of the A-system database 2 is set as the reference value a in the comparison and selection unit 13 in advance.

Next, the operation of the sixth embodiment will be described with reference to FIG. (1) When the client computer 6 receives the error message indicating the abnormality of the B-system server computer 3,
A write instruction to the A-system difference data storage area 7 based on the data change instruction is given to the A-system server computer 1.
In response to these instructions, the A-system server computer 1 reads the character capacity of the general-purpose common language in the A-system difference data storage area 7 in the A-system database 2 by the comparison and selection means 13 (step 201). (2) Subsequently, the A-system server computer 1 stores the A-system difference data storage area 7 read by the comparison / selection means 13.
It is determined whether the character capacity of the general-purpose common language is equal to or smaller than the reference value a (step 202). (3) If the character capacity of the general-purpose common language in the A-system difference data storage area 7 is equal to or smaller than the reference value a, the A-system server computer 1 causes the comparison / selection means 13 to execute the A-system / B-system difference data storage area 7, Then, the differential data equalization process using No. 8 is executed (step 203). (4) Conversely, when the character capacity of the general-purpose common language in the A-system difference data storage area 7 exceeds the reference value a, the A-system server computer 1 uses the comparison and selection means 13 to store the A-system total data storage database 2a. The all data used process is executed (step 204).

As a result, according to the sixth embodiment, the capacity of the A-system difference data storage area 7 is
If the difference is equal to or less than the reference value a indicating the a-times, the difference data equalization process is performed. If the difference exceeds the reference value a, the entire data equalization process is performed. Data equivalent processing with a high equivalent processing speed corresponding to the ratio of the data storage area 7 can be obtained.

Embodiment 7 (corresponding to claim 7). FIG. 10 is a configuration diagram showing a database equivalent processing device of a dual computer according to the seventh embodiment, and FIG. 11 is a flowchart showing processing of the seventh embodiment. The feature is that all data equalization processing and difference data equalization processing are selectively used depending on the ratio to the data storage areas 7 and 8.

In FIG. 10, a client computer 6 has data 6a in a general-purpose common language and includes a transfer means 6b and a copying means 6c. A / B system databases 2 and 4 having A / B system difference data storage areas 7 and 8 connected to A / B system server computers 1 and 3 and data by all data equalization processing. A and B-system all data storage databases 2a and 3a are provided. Further, as one of the plurality of server computers 1 and 3 and the client computer 6, for example, the plurality of server
5 and 16 are provided. These comparison determination means 15 and 16
Executes difference data equalization processing using the A-system / B-system difference data storage areas 7, 8 when the difference data amount for the equalization processing is smaller than the A-system / B-system difference data storage areas 7, 8. When the difference data amount exceeds the A-system / B-system difference data storage areas 7 and 8, all data equivalent processing using the A-system and B-system all data storage databases 2a and 3a is executed.

Next, the operation of the seventh embodiment will be described with reference to FIG. (1) When the client computer 6 receives the error message indicating the abnormality of the B-system server computer 3,
A write instruction to the difference data storage area 7 based on the data change instruction is given to the A-system server computer 1. In response to these instructions, the A-system server computer 1 reads the character capacity of the general-purpose common language in the A-system database 2 by the comparison determination means 15 (step 301). (2) Subsequently, the A-system server computer 1 determines whether the character capacity of the general-purpose common language read by the comparison determination means 15 exceeds the A-system difference data storage area 7 (step 302). (3) If the character capacity of the general-purpose common language exceeds the A-system difference data storage area 7, the A-system server computer 1
Executes the all data equivalent process using the A system all data storage database 2a by the comparison determination means 15 (step 303). (4) Conversely, if the character capacity of the general-purpose common language is less than or equal to the A-system data storage area 7, difference data equalization processing using the A-system / B-system difference data storage areas 7 and 8 is executed (step 304). .

Normally, when the capacity of the difference data exceeds the A-system difference data storage area 7 secured in advance, A
Although the system difference data storage area 7 cannot store all of the difference data, there arises a problem in data equalization using the difference.
According to the seventh embodiment, when the capacity of the difference data exceeds the A-system difference data storage area 7, all data equalization processing is performed without any upper limit imposed on the storage capacity of the A-system difference data storage area 7. Accordingly, each time the difference data capacity is compared with the A-system difference data storage area 7, an appropriate difference between the difference data equalization process having a high equivalent processing speed and the all data equalization process which does not cause storage of the difference data is appropriate. Data equivalency processing can be performed.

Embodiment 8 FIG. FIG. 12 is a block diagram showing a database equivalent processing device of a dual computer according to the eighth embodiment. FIG. 13 is a flowchart showing processing of the eighth embodiment. When an error occurs during the differential data equalization processing by storing the data in the differential data storage areas 7 and 8, the differential data equalization processing is stopped and the A-system and B-system all data storage databases 2a and 3a are used. It is characterized by executing data equalization processing.

In FIG. 12, a client computer 6 has data 6a in a general-purpose common language and includes a transfer means 6b and a copying means 6c. A / B system databases 2 and 4 having A / B system difference data storage areas 7 and 8 connected to A / B system server computers 1 and 3 and data by all data equalization processing. A and B-system all data storage databases 2a and 3a are provided. Further, as one of the plurality of server computers 1 and 3 and the client computer 6, as an example, the plurality of server computers 1 and 3 are provided with an abnormality countermeasure unit 1.
7, 18 are provided. These abnormality countermeasures 17 and 18
When an error occurs during the differential data equalization processing by storing the differential data in the differential data storage areas 7 and 8 by the copying means 6c, the differential data equalization processing is stopped and the A-system / B-system all data storage database All data equivalent processing using 2a and 3a is executed.

Next, the operation of the eighth embodiment will be described with reference to FIG. For example, B system server computer 3
During the equivalence processing from the writing of the difference data to the A-system difference data storage area 7 to the completion of the change to the B-system database 4 (step 401), the abnormality countermeasure means 17 and 18 receive an error message indicating the abnormality of When an abnormality is detected (step 402), the difference data equalization process is stopped, and an all data equalization process using the A-system all data storage database 2a is executed (step 403). As a result, according to the eighth embodiment, when an abnormality occurs that makes it impossible to perform the difference data equalization process during the equalization process, the difference data equalization process is stopped.
Since all data equivalent processing using the system-wide data storage database 2a is executed, highly reliable data equivalent processing can be obtained.

In the first to eighth embodiments, the equivalent processing from the A-system database 2 to the B-system database 4 has been described as an example. However, the equivalent processing from the B-system database 4 to the A-system database is similarly applied. it can.

[0062]

As described above, according to the first aspect of the present invention, an apparatus for holding a difference between two databases in a general-purpose common language, means for transferring the difference from one database to another database, Since there is provided a means for reading the difference described in the common language and making a change to the database, the database is equivalently processed, so that there is an effect that a database equivalent processing method with a high processing speed can be obtained.

According to the second aspect, the number of general-purpose common languages of the difference data is compared before and after copying, and the equalizing process of the difference data is repeated until the number of characters before and after the copying becomes the same. In this case, there is an effect that a database equivalent process capable of updating data from the client computer can be obtained even during the copying of the difference data.

According to the third aspect of the present invention, the difference data is transferred from one database to the other database until the difference data is exhausted, and the change is made to the database. There is an effect that a database equivalent processing method that can be updated is obtained.

According to the fourth aspect, by verifying the consistency of the database amount after data equalization, the reliability of the data equalization process can be easily improved.

According to the fifth invention, the difference data is written in the same transaction as the data update for the data update from a plurality of clients, and the difference data is given a serial number in time order. There is an effect that it is possible to easily respond to data update from the client.

According to the sixth aspect of the present invention, the data capacity of the differential data is compared with the total data capacity, and the ratio between the two is used to compare the differential data and the entire data. By selecting the faster one, there is an effect that data equalization processing with a high processing speed can always be appropriately obtained.

According to the seventh aspect of the present invention, the difference data equalization process and the entire data equalization process are selectively used depending on whether the difference data exceeds a predetermined capacity, thereby limiting the upper limit of the difference data capacity. There is an effect that a data equalization process that is not affected can be obtained.

According to the eighth aspect, when an error occurs during the differential data equalization processing, the differential data equalization processing is stopped, and the entire data equalization processing is performed. There is an effect that processing can be obtained.

[Brief description of the drawings]

FIG. 1 is a configuration diagram illustrating a database equivalent processing device of a dual computer according to a first embodiment.

FIG. 2 is a configuration diagram illustrating a database equivalent processing device of a dual computer according to a second embodiment.

FIG. 3 is a flowchart illustrating a process according to a second embodiment.

FIG. 4 is a configuration diagram illustrating a database equivalence processing device of a dual computer according to a third embodiment.

FIG. 5 is a configuration diagram illustrating a database equivalence processing device of a dual computer according to a fourth embodiment.

FIG. 6 is a configuration diagram illustrating a database equivalent processing apparatus of a dual computer according to a fifth embodiment.

FIG. 7 is a configuration diagram illustrating a database equivalent processing device of a dual computer according to a sixth embodiment.

FIG. 8 is an experimental result diagram illustrating a reference value of the sixth embodiment.

FIG. 9 is a flowchart illustrating a process according to a sixth embodiment.

FIG. 10 is a configuration diagram illustrating a database equivalent processing device of a dual computer according to a seventh embodiment.

FIG. 11 is a flowchart illustrating a process according to a seventh embodiment.

FIG. 12 is a configuration diagram illustrating a database equivalence processing device of a dual computer according to an eighth embodiment.

FIG. 13 is a flowchart illustrating a process according to the eighth embodiment.

FIG. 14 is a configuration diagram showing a conventional database equivalence processing device of a dual computer.

[Explanation of symbols]

1 A server computer, 2 A database,
2a A system all data storage database, 3B system server computer, 3a B system all data storage database,
4B system database, 6 client computer, 6b transfer unit, 6c copy unit, 6d comparison unit, 6e update instruction unit, 7A system difference data storage area, 7a A system update instruction storage area, 8B system difference data storage area, 8a B system update command storage area, 9,10 verification means, 11,12 update order means, 13,14 comparison selection means, 15,16 comparison determination means, 17,18 abnormality countermeasure means.

Claims (8)

(57) [Claims] A client computer having data described in a general-purpose common language and a plurality of server computers having a database are connected by a bus-type transmission line, and the client computer transmits the same data to the bus-type transmission line. The plurality of server computers transfer the data to each of the plurality of server computers, and each of the plurality of server computers equivalently stores the data in a database. A difference data storage area for storing is separately provided, and either one of the client computer or the plurality of server computers stores the difference stored in the database of one of the plurality of server computers in the difference data storage area. Other data Transfer means for instructing transfer to the other server computer, and copying means for copying the difference data transferred to the other server computer by the transfer means to the difference data storage area. Database equivalent processing unit for dual computers. 2. The client computer or the plurality of server computers compare the data amounts of both after completion of copying from one differential data storage area to the other differential data storage area by the copying means. If the two data volumes do not match, comparison means is provided for erasing the copy data in the other differential data storage area and copying again from one differential data storage area to the other differential data storage area. 2. The database equivalence processing apparatus for a dual computer according to claim 1, wherein: 3. An update instruction storage area is provided in each of the plurality of databases, and one of the client computer and the plurality of server computers performs an equalization process from one database to the other database in the equalization process. 2. The database equivalence processing device for a dual computer according to claim 1, further comprising update instruction means for writing the update instruction in the update instruction storage area and repeating the equivalence processing until the update instruction storage area is exhausted. 4. A method according to claim 1, wherein said plurality of server computers are provided with verification means for verifying the consistency of the amount of database after completion of copying from one database to another database by said copying means. 2. The database equivalence processing device for a dual computer according to claim 1, wherein: 5. The plurality of server computers receive the data update from the plurality of client computers, write the differential data to the differential data storage area in the same transaction as the data update, and assign a serial number to the differential data in time order. 2. The apparatus according to claim 1, further comprising an update sequence unit for assigning a value. 6. A plurality of server computers are provided with an all data storage database for storing data obtained by an all data equalization process, and one of the plurality of server computers or the client computers is provided with differential data for a storage area of the database. When the ratio of the boundary difference data capacity to the storage area is smaller than the reference value, the difference data equalization process using the difference data storage area is executed, and when the ratio exceeds the reference value, the entire data storage database is used. 2. The apparatus according to claim 1, further comprising comparison / selection means for executing all data equalization processing. 7. A plurality of server computers are provided with an all data storage database for storing data obtained by an all data equalization process, and one of the plurality of server computers or the client computers is provided with a data storage area for the difference data storage area. If the difference data amount is smaller than the difference data storage area, a difference data equalization process using the difference data storage area is performed. If the difference data amount exceeds the difference data storage area, all data using the entire data storage database is used. 2. The database equivalence processing apparatus for a dual computer according to claim 1, further comprising comparison determination means for executing equivalence processing. 8. The plurality of server computers are provided with an all data storage database for storing data obtained by an all data equalization process, and one of the plurality of server computers or the client computers stores a difference data of the difference data. An abnormality countermeasure means is provided for canceling the differential data equalization processing when an error occurs during the differential data equalization processing for the area and executing the all data equalization processing using the all data storage database. Item 2. A database equivalence processing device for a dual computer according to item 1.