JP4138329B2 - Data processing system and data processing method - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a data processing system and a data processing method, and in particular, allows a plurality of DBs (databases) to be processed as one global transaction, and the state of a remote DB can be synchronized with the result of this global transaction. The present invention relates to a data processing system and a data processing method .
[0002]
[Prior art]
In general, RMs (resource managers, specifically DBMSs, etc., hereinafter referred to as DBMSs) that manage DBs have their own database duplication functions. It is possible to synchronize with the contents of the database.
[0003]
FIG. 5 is a block diagram showing the configuration of a DB system for explaining DB duplication according to the prior art. In FIG. 5, 1 and 14 are servers, 35 and 36 are DBMSs, 43 is a user application (UAP), 44 and 45 are DBs, 46 is a network, and 47 is a communication means.
[0004]
The DB system shown in FIG. 5 is configured by connecting two server machines 1 and 14 constituting a DB device via a network 46. In the server machine 1 in which the DB apparatus as the production system is configured, a UAP 43, a DB 44 updated by the UAP 43, and a DBMS 35 that manages the DB 44 are configured. In addition, a DB 45 and a DBMS that manages the DB 45 are configured in the server machine 14 configured with a DB device as a backup system installed in a remote place.
[0005]
The DBMS 35 on the server machine 1 manages the DB 44 updated by the UAP 43 managed by the DBMS 35, and uses the original communication means 47 to update the DBMS 36 of the server machine 14 at a remote location through the network 46. Transfer information. The DBMS 36 receiving this information can thereby update the database 45 managed by the own DBMS 36, that is, synchronize the contents of the DBs in the server machines 1 and 14 with each other.
[0006]
[Problems to be solved by the invention]
The above-described conventional technology can update the database of a remote system even if there is a delay in updating. However, the above-described conventional technology can update contents between single DB apparatuses, and this update is performed by a function unique to the DBMS. For this reason, when the conventional technology as described above is applied to a large-scale system that has a plurality of DB devices composed of a DB and a DBMS and processes the plurality of DBs as one global transaction, It becomes impossible to synchronize the state of the remote database with the result of the global transaction.
[0007]
A global transaction is a unit in which a plurality of transactions (these are called transaction branches) can be bundled and controlled. In this global transaction, it is possible to include a plurality of DB devices. In this case, a function for controlling the conclusion of a plurality of DBMSs and a plurality of transaction branches is required. This function is a basic function of a program called TM (transaction manager). The TM controls information for a plurality of settlements, and controls a plurality of transaction branches as one global transaction. The DB update result in the transaction branch under the control of one global transaction is uniquely determined according to the conclusion of the global transaction controlled by the TM.
[0008]
FIG. 4 is a block diagram showing the configuration of a DB system for explaining DB update by a global transaction. In FIG. 4, 22 and 27 are TMs, 23 and 30 are UAPs, 26 is a communication means, 31 and 32 are DBs, and 33 and 34 are DBMSs. In the system shown in FIG. 4, each DB system including TMs 22 and 27 is assumed to operate as a production system and a backup system.
[0009]
In FIG. 4, a link function 28 called an XA link function defined by X / OPEN is provided between each TM and each DBMS, and the TM uses this link function 28 to connect to the DBMS. Perform transaction control. The UAP 23 has a DB update function 24, that is, a function of updating the database 31 using SQL, and can make a processing request to another UAP 30 using the communication means 29 provided by the TM 22. Is possible. At this time, the UAP 30 becomes a transaction branch for the transaction of the UAP 23. The update to the database 32 by the DB update function 24 of the UAP 30 is managed by the TM 22 and TM 27 as one global transaction including the transaction of the UAP 23.
[0010]
The UAP 23 can call the transaction control function 25 of the TM 22 to settle the transaction. At this time, the TM 22 instructs the TM 27 to settle the transaction using the contact means 26 in order to settle the transaction of the UAP 30 managed by the TM 27.
[0011]
As described above, the update of the DB 31 by the UAP 23 and the update of the DB 32 by the UAP 30 in the global transaction managed by the TM 22 and the TM 27 are performed in synchronization, so that only one DB is updated. It will not be in a state. In other words, the results of a plurality of transaction branches in the global transaction are uniquely maintained by the TM control.
[0012]
The current duplicate function of the DBMS, for example, in the example described with reference to FIG. 4, the DBMS 33 and the DBMS 34 update the DB managed by the remote DBMS at a timing independent of each other. For this reason, the result of updating the DB 31 by the UAP 23 is reflected in the DB 32 at a remote location, but there may still be a timing that the result of updating the DB 32 by the UAP 30 is not reflected in the DB 31 yet.
[0013]
For this reason, in a large-scale system that needs to update a plurality of databases within a global transaction and that needs to reflect the update result in a remote DB such as a disaster countermeasure system, the user's own device It was necessary to take measures to synchronize. For example, restricting the configuration of business applications such as not depending on multiple DBs or creating a transaction branch, transferring the original data that caused the transaction, and generating a similar transaction It was necessary to implement parallel processing in business applications by using means.
[0014]
An object of the present invention is to provide a means for synchronously updating a plurality of DBs at a remote location by using a TM for managing a global transaction, avoiding the above-described necessity, and updating a database of a plurality of DBs at a remote location to a global transaction. It is an object of the present invention to provide a data processing system and a data processing method that can be synchronized.
[0015]
[Means for Solving the Problems]
According to the present invention, the object is configured by connecting a plurality of database devices including a database and a DBMS for managing the database, and connecting at least two database systems including a transaction manager by communication means provided by the transaction manager. In the data processing system, the transaction manager of one database system provides transaction management information for reflecting the update results of a plurality of databases updated in the global transaction of the own database system to the database in the other database system. Each of the DBMSs of the plurality of database devices of the other database system. The update information for a plurality of databases of one of the database system transmitted from a plurality of database apparatus of one of the database system, comprising means for holding in the DBMS as times Fukujo report, the transaction manager of the other database system Based on the received transaction management information, the means for instructing the transaction to the DBMS participating in the transaction and the recovery information stored in each DBMS of the own system And a means for updating the database.
[0016]
DETAILED DESCRIPTION OF THE INVENTION
Embodiments of a global transaction control system and a control method according to the present invention will be described below in detail with reference to the drawings.
[0017]
FIG. 1 is a block diagram showing the configuration of a DB system using global transaction control according to an embodiment of the present invention, and FIG. 2 shows the configuration of a remote site DB system for explaining recovery processing in the remote site DB system. FIG. 3 is a block diagram for explaining the transaction management information 13. 1-3, 2, 12 are TM, 3 is a global transaction, 4 is UAP, 5, 6, 8, 10 is DB, 9, 11 is recovery information, 13 is transaction management information, 15, 16, 37 , 38 are DBMSs, and the other symbols are the same as those in FIG.
[0018]
The DB system shown in FIG. 1 is configured by connecting two server machines 1 and 14 constituting a DB system via a network 46. In the server machine 1 in which the DB system as the production system is configured, TM2, UAP4, DB5 updated by this UAP4 and DB device by DBMS15 managing DB5, DB6 updated by UAP4, and A DB device by the DBMS 16 that manages the DB 6 is configured. A global transaction is configured by the UAP 4 and the two DB devices described above.
[0019]
Further, in the server machine 14 in which a DB system as a disaster countermeasure backup system installed in a remote place is configured, a DB device by TM12, a DBMS 37 that manages DB8 and DB8, and a DBMS38 that manages DB10 and DB10. A transaction management information 13 for managing a transaction transferred from TM2 is stored.
[0020]
Normally, the client terminal (not shown) of the DB system shown in FIG. 1 performs business with the server machine 1 as a partner, but some trouble occurs in the area where the server machine 1 exists, and the business on the server machine 1 continues. When it becomes difficult, the server machine 14 is requested to perform business processing. Now, it is assumed that a business from a client is a global transaction 3. Normally, a transaction is not generated from a client terminal. Therefore, the operation in the server machine will be described below.
[0021]
In response to a business request from the client terminal, the DB 5 managed by the DBMS 15 and the DB 6 managed by the DBMS 16 are updated in the global transaction 3 and the global transaction 3 is committed. Since DB5 and DB6 update the contents of the database in synchronization with the function of TM2, the update contents of DB5 and DB6 are correctly synchronized. Various business requests are input from the client to the illustrated system, and the results are reflected in DB5 and DB6.
[0022]
Each of the DBMS 15 and the DBMS 16 updates the DB 8 managed by the DBMS 37, which is a replication DB corresponding to each remote location, and the DB 10 managed by the DBMS 38 to the contents of the DB 5 and DB 6 through the network 7 by the conventional database duplication function. be able to. The transfer process in this case is executed by the DBMS 15 and 16, but the transfer interval is not synchronized between the DBMS 15 and the DBMS 16. In the embodiment of the present invention, in addition to the replication to the remote DB by the duplicate function of the DBMS as described above, the transaction management information 13 for synchronization between the DB 8 and the DB 10 is displayed. Is transferred to the remote TM 12 by using the function 17 for transferring.
[0023]
As shown in FIG. 3, the transaction management information 13 includes a plurality of transaction information 42. One transaction information 42 includes a transaction identifier 39, settlement information 40 such as transaction commit / rollback, information on the DBMS 41 participating in the transaction, and the like.
[0024]
Next, with reference to FIG. 2, the recovery process in the remote-side server machine 14 will be described.
[0025]
The updated contents of DB5 and DB6 transferred by the DBMS15 and DBMS16 are temporarily held in the DBMS 37 and DBMS 38 as the recovery information 9 and 11 shown in FIG. On the other hand, the TM 12 in the server machine 14 installed at a remote location, based on the transferred transaction management information 13 at the transfer source TM 2, transmits the transaction information to the DBMS 37 and DBMS 38 based on the participating DBMS information 41. In accordance with the transaction information of the settlement information 40, a transaction settlement preparation instruction is sent to the DBMS 37, 38 using the function 20 for issuing a transaction settlement preparation instruction. The transaction identifier 39 is used for this instruction.
[0026]
The DBMS 37 and DBMS 38 that have received the transaction settlement preparation instruction check whether the information for database update corresponding to the instructed transaction identifier 39 exists in the recovery information 9 and the recovery information 11, respectively. If yes, reply that you are ready. When the TM 12 receives the response from the DBMS 37 and DBMS 38 and can determine that the update is possible, the TM 12 updates the DBMS 37 and DBMS 38 using the function 21 for instructing the transaction completion. Instruct. Receiving the update instruction, the DBMS 37 and the DBMS 38 update the database 8 and the database 10 using the recovery information 9 and the recovery information 11, respectively.
[0027]
FIG. 6 is a flowchart for explaining the operation of the recovery process in the above-mentioned DB system on the remote site side. Next, this will be explained.
[0028]
(1) The transaction management information 13 is read, and if there is transaction management information, the transaction identifier, the settlement information such as the transaction commit or rollback, and the information of the participating DBMS are acquired (step 100). .
[0029]
(2) Based on the information acquired in step 100, first, an instruction for preparation for settlement is given to one DBMS participating in the transaction in the information, and an answer to the instruction may be settled. It is checked whether or not there is (steps 101 and 102).
[0030]
(3) If an answer indicating that it can be settled is obtained in step 102, it is confirmed whether or not the next DB, that is, DBMS exists, and whether or not there is another DB is checked. If there is another DB, the process returns to the process from step 101, and a decision preparation instruction is given to the other DBMS (step 104, step 105).
[0031]
(4) If the check in step 102 does not give an answer that it can be settled, after holding for a certain period of time, the process returns to step 101 and is executed again (step 103).
[0032]
(5) If there is no other DB in the check in step 105, that is, if there is an answer that all the DBMSs are ready, it will be settled for the DBMS participating in all these transactions. An instruction is given (step 106).
[0033]
(6) After that, it is checked whether or not there is transaction information. If it exists, the process returns to step 100, and the transaction is processed based on the information. If there is no information, it waits for information to be transferred (steps 107 and 108).
[0034]
Each processing according to the embodiment of the present invention described above can be configured as a processing program, and this processing program is stored in a recording medium such as HD, DAT, FD, MO, DVD-ROM, CD-ROM, and provided. can do.
[0035]
According to the above-described embodiment of the present invention, the update contents of DB5 and DB6 updated as the global transaction 3 in the server machine 1 that is the transfer source are synchronized with the DB15 and DB16 in the remote server machine 14. The database system can be updated correctly, and a highly reliable DB system can be realized by building a redundant system in a remote place such as a disaster countermeasure system.
[0036]
【The invention's effect】
As described above, according to the present invention, in a large-scale system in which a plurality of databases are updated by a global transaction, it is possible to correctly reflect and update the update information at a remote location. As a result, it is possible to improve the reliability of the disaster countermeasure system in which a redundant system is constructed in a remote place.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a configuration of a DB system using global transaction control according to an embodiment of the present invention.
FIG. 2 is a block diagram showing a configuration of a remote site DB system for explaining recovery processing in the remote site DB system;
FIG. 3 is a diagram for explaining transaction management information 13;
FIG. 4 is a block diagram showing a configuration of a DB system for explaining DB update by a global transaction.
FIG. 5 is a block diagram showing the configuration of a DB system for explaining DB duplication according to the prior art.
FIG. 6 is a flowchart for explaining the operation of recovery processing in a remote-side DB system.
[Explanation of symbols]
1, 14 Server machine 2, 12, 22, 27 TM
3 Global transaction 4, 23, 30, 43 User application (UAP)
5, 6, 8, 10, 31, 32, 44, 45 DB
9, 10 Recovery information 13 Transaction management information 15, 16, 33-38 DBMS
26 Communication means 46 Network 47 Communication means

Claims (3)

In a data processing system comprising a plurality of database devices including a database and a DBMS for managing the database and connecting at least two database systems including a transaction manager by communication means provided by the transaction manager,
The transaction manager of one database system transmits transaction management information for reflecting the update results of a plurality of databases updated in the global transaction of the own database system to the database in the other database system, and the transaction manager of the other database system. With means to transfer to
Each of the DBMS of the plurality of database apparatus of the other database system, the update information for a plurality of databases of one of the database system transmitted from a plurality of database apparatus of one of the database system, as in time Fukujo report the DBMS Means for holding,
The transaction manager of the other database system holds each of the means for instructing the transaction to the DBMS participating in the transaction based on the received transaction management information and the DBMS of its own system. A data processing system comprising: means for updating a database in the own system based on recovery information. In a data processing method in a data processing system including a plurality of database devices each including a database and a DBMS that manages the database and connecting at least two database systems including a transaction manager by communication means provided by the transaction manager ,
The transaction manager of one database system transmits transaction management information for reflecting the update results of a plurality of databases updated in the global transaction of the own database system to the database in the other database system, and the transaction manager of the other database system. Forward to
Each of the DBMS of the plurality of database apparatus of the other database system, the update information for a plurality of databases of one of the database system transmitted from a plurality of database apparatus of one of the database system, as in time Fukujo report the DBMS Hold and
Based on the received transaction management information, the transaction manager of the other database system issues a transaction settlement instruction to the DBMS participating in the transaction, and each of the DBMSs of its own system stores the recovery information held therein. A data processing method characterized in that the database in the own system is updated. A data processing program in a data processing system comprising a plurality of database devices each including a database and a DBMS for managing the database and connecting at least two database systems including a transaction manager by communication means provided by the transaction manager There,
In the other database system,
Receiving transaction management information for reflecting the update results of a plurality of databases updated in the global transaction of one database system transmitted from the transaction manager of one database system to the database in the other database system;
Updates to multiple databases of one of the database system transmitted from a plurality of database apparatus of one of the database system, the step of holding in a DBMS of the own system as times Fukujo report,
A step of instructing the DBMS that has participated in the transaction based on the received transaction management information;
A data processing program that causes each DBMS of its own system to execute a step of updating a database in the own system based on the stored recovery information.

Images