JP7564438B2 - Information processing system, log transmission program, information processing device, and log transmission method - Google Patents

Description

The present invention relates to an information processing system, a log transmission program, an information processing device, and a log transmission method.

For example, in a securities trading system (hereinafter simply referred to as a trading system) that handles financial products, when a stock buy/sell order is received from a trading participant or when a stock trade is concluded, information about the stock trading status (hereinafter also referred to as trading information) is reflected in a database. The trading system then transmits a commit log when each piece of trading information is reflected in the database to an external information processing system (hereinafter also referred to as an external system) owned by, for example, a securities company or a trading participant.

Specifically, the above-mentioned trading system is composed of, for example, an information processing device (hereinafter also referred to as an active device) that performs processing associated with buying and selling stocks, an information processing device (hereinafter also referred to as a standby device) that takes over processing if an abnormality or the like occurs in the active device, and an information processing device (hereinafter also referred to as a cooperating device) that transmits a commit log to an external system. The active device then transmits a commit log to, for example, both the standby device and the cooperating device. This enables the active device to transmit a commit log to the external system and to synchronize the database of the active device with the database of the standby device (for example, see Patent Document 1).

Special Publication No. 2010-527087

When a standby device or a cooperating device such as the above receives a commit log from an active device, it sends a notification (hereinafter, a response notification) to the active device indicating that the commit log was received successfully. This enables the active device to determine whether the transmission of each commit log was completed successfully.

However, in this case, the active device must wait not only for the response notification sent from the standby device, but also for the response notification sent from the cooperating device. Therefore, for example, if the active device needs time to wait for the response notification sent from the cooperating device, the processing performance may be degraded.

In one aspect, the present invention aims to provide an information processing system, a log transmission program, an information processing device, and a log transmission method that can prevent a decrease in processing performance due to waiting for response notifications.

In one aspect of the embodiment, an information processing system includes a first information processing device that transmits a commit log for a transaction to a database, a second information processing device and a third information processing device that receive the commit log from the first information processing device, and a destination device that receives the commit log from the first information processing device, in which when the transaction is committed, the first information processing device determines which of the second information processing device and the third information processing device is an information processing device that will confirm receipt of the commit log at the destination device, and the first information processing device transmits the commit log to which identification information of the determined one of the information processing devices is added to the destination device and one of the information processing devices, and one of the information processing devices transmits the commit log to the previous information processing device. When the commit log is received from the first information processing device, it is determined whether the identification information included in the received commit log indicates its own device, and when the information processing device determines that the identification information included in the commit log indicates its own device, it stores the commit log in a storage unit and transmits an instruction to the destination device to confirm receipt of the commit log, and when the destination device receives the commit log from the first information processing device and receives an instruction to confirm receipt of the commit log from the one of the information processing devices, it transmits a receipt confirmation result to the one of the information processing devices indicating that the reception of the commit log at the destination device has been completed successfully, and when the one of the information processing devices receives the receipt confirmation result from the destination device, it deletes the commit log from the storage unit.

According to one aspect, it is possible to prevent a decrease in processing performance due to waiting for response notifications.

FIG. 1 is a diagram illustrating the configuration of a trading system 10. As shown in FIG. FIG. 2 is a diagram for explaining the hardware configuration of the active device 1. As shown in FIG. FIG. 3 is a diagram illustrating the hardware configuration of the standby device 2. As shown in FIG. FIG. 4 is a diagram illustrating the hardware configuration of the linking device 4. As shown in FIG. FIG. 5 is a functional block diagram of the active device 1. FIG. 6 is a block diagram of the functions of the standby device 2. FIG. 7 is a block diagram of the functions of the linked device 4. As shown in FIG. FIG. 8 is a flow chart outlining the log transmission process according to the first embodiment. FIG. 9 is a flow chart outlining the log transmission process according to the first embodiment. FIG. 10 is a flow chart outlining the log transmission process according to the first embodiment. FIG. 11 is a flowchart illustrating details of the log transmission process according to the first embodiment. FIG. 12 is a flowchart illustrating details of the log transmission process according to the first embodiment. FIG. 13 is a flowchart illustrating details of the log transmission process according to the first embodiment. FIG. 14 is a flowchart illustrating details of the log transmission process according to the first embodiment. FIG. 15 is a flowchart illustrating details of the log transmission process according to the first embodiment. FIG. 16 is a flowchart illustrating details of the log transmission process according to the first embodiment. FIG. 17 is a flowchart illustrating details of the log transmission process according to the first embodiment. FIG. 18 is a diagram illustrating a specific example of the commit log CL. FIG. 19 is a diagram for explaining a specific example of the correspondence information 131. As shown in FIG. FIG. 20 is a diagram illustrating a specific example of the commit log CL. FIG. 21 is a diagram for explaining a specific example of the correspondence information 131. As shown in FIG. FIG. 22 is a diagram illustrating a specific example of the first response notification RS1. FIG. 23 is a diagram illustrating a specific example of the first response notification RS1. FIG. 24 is a diagram illustrating a specific example of the third response notification RS3. FIG. 25 is a sequence chart illustrating a specific example of the log transmission process in the case where the retransmission of the commit log to the collaboration apparatus 4 does not occur. FIG. 26 is a sequence chart illustrating a specific example of a log transmission process in a case where a commit log needs to be resent to the coordination apparatus 4. In FIG.

[Configuration of Information Processing System]
First, a description will be given of the configuration of the trading system 10. FIG.

The trading system 10 (hereinafter also referred to as information processing system 10) shown in FIG. 1 has, for example, an active device 1, a standby device 2, a standby device 3, a cooperating device 4, and a reception device 5.

The reception device 5, for example, receives orders to buy and sell stocks sent from an information processing system (not shown) owned by a securities company. The reception device 5 then transmits to the active device 1, for example, a processing request (hereinafter also simply referred to as a processing request) requesting the execution of a process to execute the received buying and selling orders.

The processing unit 1a of the active device 1, for example, consolidates buy and sell orders (buy and sell orders received by the receiving device 5) corresponding to processing requests received from the receiving device 5, and completes the buying and selling of stocks. Then, the processing unit 1a, for example, reflects the content of the completed buying and selling in the database 1b (hereinafter also referred to as DB1b). Furthermore, the processing unit 1a generates a commit log that indicates the reflection result of the buying and selling in the database 1b. After that, the processing unit 1a transmits the generated commit log to each of the standby device 2, the standby device 3, and the cooperating device 4.

The processing unit 2a of the standby device 2 performs synchronization processing between database 1b and database 2b by reflecting the contents of the commit log sent from the active device 1 in database 2b (hereinafter also referred to as DB2b). Similarly, the processing unit 3a of the standby device 3 performs synchronization processing between database 1b and database 3b by reflecting the contents of the commit log sent from the active device 1 in database 3b (hereinafter also referred to as DB3b). Then, for example, if a specified abnormality occurs in the active device 1, the standby device 2 or standby device 3 takes over and executes the processing that was being executed by the active device 1.

Note that, although the following description will be given of a case where trading system 10 has two standby devices (standby device 2 and standby device 3), trading system 10 may have a number of standby devices other than two.

The coordinating device 4 transmits the commit log sent from the active device 1 to the external system 20. Specifically, the coordinating device 4 sequentially stores the commit log sent from the active device 1 in a message queue (not shown) that is accessible by the external system 20.

When each of the standby device 2, standby device 3, and cooperating device 4 receives a commit log from the active device 1, it sends a response notification to the active device 1 indicating that the commit log was received successfully. This enables the active device 1 to determine whether the transmission of each commit log was completed successfully.

However, in this case, the active device 1 needs to wait not only for the response notification sent from the standby device 2 and the standby device 3, but also for the response notification sent from the coordinating device 4. Therefore, in the active device 1, for example, if the waiting time for the response notification sent from the coordinating device 4 is long, a decrease in performance occurs in the processing associated with buying and selling stocks.

In this embodiment, when a transaction to database 1b is committed, active device 1 determines one of standby devices 2 and standby device 3 as the standby device that will confirm receipt of the commit log in collaboration device 4 (hereinafter also referred to as a specific standby device). Then, active device 1 transmits the commit log, to which the identification information of the determined specific standby device has been added, to each of collaboration device 4 and the specific standby device.

After that, when the specific standby device receives a commit log from the active device 1, it determines whether the identification information included in the received commit log indicates its own device. As a result, if it determines that the identification information included in the received commit log indicates its own device, the specific standby device stores the received commit log in a memory unit and sends an instruction to the cooperating device 4 to confirm receipt of the commit log.

Then, when the coordinating device 4 receives the commit log from the active device 1 and also receives an instruction from a specific standby device to confirm receipt of the commit log, it sends a response notification to the specific standby device indicating that receipt of the commit log has been completed successfully.

Furthermore, when a particular standby device receives a response notification from the cooperating device 4 indicating that reception of the commit log has been completed successfully, the particular standby device deletes the commit log received from the active device 1 from the memory unit.

In other words, in the trading system 10 of this embodiment, a specific standby device confirms receipt of the commit log in the linked device 4.

As a result, the trading system 10 in this embodiment can prevent a decrease in processing performance in the active device 1, even if it takes time to wait for a response notification sent from the linked device 4, for example.

[Hardware configuration of trading system]
Next, the hardware configuration of the trading system 10 will be described. Fig. 2 is a diagram for explaining the hardware configuration of the active device 1. Fig. 3 is a diagram for explaining the hardware configuration of the standby device 2. Fig. 4 is a diagram for explaining the hardware configuration of the cooperating device 4. Note that the hardware configuration of the standby device 3 is the same as that of the standby device 2, so a description thereof will be omitted.

First, we will explain the hardware configuration of active device 1.

As shown in FIG. 2, the active device 1 has a processor, a CPU 101, a memory 102, a communication device 103, and a storage medium 104. Each part is connected to each other via a bus 105.

The storage medium 104 has, for example, a program storage area (not shown) that stores a program 110 for performing a process of transmitting a commit log to the linkage device 4 (hereinafter also referred to as a log transmission process). The storage medium 104 also has, for example, an information storage area 130 that stores information used when performing the log transmission process. Note that the storage medium 104 may be, for example, a HDD (Hard Disk Drive) or an SSD (Solid State Drive).

The CPU 101 executes the program 110 loaded from the storage medium 104 to the memory 102 to perform the log transmission process.

The communication device 103 also communicates with the standby device 2, etc., via the network NW, for example.

Next, we will explain the hardware configuration of standby device 2.

As shown in FIG. 3, the standby device 2 has a processor, a CPU 201, a memory 202, a communication device 203, and a storage medium 204. Each part is connected to each other via a bus 205.

The storage medium 204 has, for example, a program storage area (not shown) that stores a program 210 for performing the log transmission process. The storage medium 204 also has, for example, an information storage area 230 that stores information used when performing the log transmission process. Note that the storage medium 204 may be, for example, an HDD or SSD.

The CPU 201 executes the program 210 loaded from the storage medium 204 to the memory 202 to perform the log transmission process.

The communication device 203 also communicates with the active device 1, etc., via the network NW.

Next, we will explain the hardware configuration of linked device 4.

As shown in FIG. 4, the linked device 4 has a processor, a CPU 401, a memory 402, a communication device 403, and a storage medium 404. Each part is connected to each other via a bus 405.

The storage medium 404 has, for example, a program storage area (not shown) that stores a program 410 for performing the log transmission process. The storage medium 404 also has, for example, an information storage area 430 that stores information used when performing the log transmission process. The storage medium 404 may be, for example, an HDD or SSD.

The CPU 401 executes the program 410 loaded from the storage medium 404 to the memory 402 to perform the log transmission process.

The communication device 403 also communicates with the active device 1, etc., via the network NW.

[Trading system functions]
Next, the functions of the trading system 10 will be described. Fig. 5 is a block diagram of the functions of the active device 1. Fig. 6 is a block diagram of the functions of the standby device 2. Fig. 7 is a block diagram of the functions of the cooperating device 4. Note that the functions of the standby device 3 are the same as those of the standby device 2, so a description thereof will be omitted.

First, we will explain the functions of the active device 1.

As shown in FIG. 5, the active device 1 realizes various functions including, for example, an information receiving unit 111, a transaction processing unit 112, an information management unit 113, an information generating unit 114, a device determination unit 115, and an information transmission unit 116, by organic cooperation between hardware such as a CPU 101 and a memory 102 and a program 110. Note that the processing unit 1a described in FIG. 1 corresponds to, for example, the information receiving unit 111, the transaction processing unit 112, the information management unit 113, the information generating unit 114, the device determination unit 115, and the information transmission unit 116.

In addition, as shown in FIG. 5, the active device 1 stores, for example, correspondence information 131 in the information storage area 130.

The information receiving unit 111 receives a processing request sent by the reception device 5. Specifically, the information receiving unit 111 receives, for example, a processing request to complete a buy or sell order accepted by the reception device 5.

The transaction processing unit 112, for example, consolidates buy and sell orders corresponding to processing requests received by the information receiving unit 111 and completes the buying and selling of stocks. Then, for example, when the transaction processing unit 112 completes the buying and selling of stocks, the information management unit 113 writes the contents of the buying and selling orders completed by the transaction processing unit 112 (buy and sell orders corresponding to processing requests received by the information receiving unit 111) in database 1b. Also, for example, when the transaction processing unit 112 does not complete the buying and selling of stocks, the information management unit 113 writes the contents of the buying and selling orders not completed by the transaction processing unit 112 (buy and sell orders corresponding to processing requests received by the information receiving unit 111) in database 1b.

When a transaction for database 1b (a transaction corresponding to a processing request received by the information receiving unit 111) is committed, the information generating unit 114 generates a commit log for that transaction.

The device determination unit 115 determines a specific standby device that will confirm receipt of the commit log generated by the information generation unit 114 in the cooperating device 4. The information generation unit 114 then adds identification information of the specific standby device determined by the device determination unit 115 to the commit log.

The information transmission unit 116 transmits the commit log, to which the identification information of the specific standby device is added, to the cooperating device 4 and the specific standby device, respectively. The correspondence information 131 will be explained later.

Next, we will explain the functions of standby device 2.

As shown in FIG. 6, the standby device 2 realizes various functions including, for example, an information receiving unit 211, an information managing unit 212, an information determining unit 213, a retransmission control unit 214, and an information transmitting unit 215, by organic cooperation between hardware such as a CPU 201 and a memory 202 and a program 210. Note that the processing unit 2a described in FIG. 1 corresponds to, for example, the information receiving unit 211, the information managing unit 212, the information determining unit 213, the retransmission control unit 214, and the information transmitting unit 215.

The information receiving unit 211 receives the commit log sent by the active device 1. Then, the information management unit 212 writes the contents of the commit log received by the information receiving unit 211 to the database 2b.

The information determination unit 213 determines whether the identification information included in the commit log received by the information receiving unit 211 indicates the device itself.

When the retransmission control unit 214 determines that the identification information included in the commit log received by the information receiving unit 211 indicates the device itself, the retransmission control unit 214 stores the commit log received by the information receiving unit 211 in the information storage area 130.

When the information sending unit 215 determines that the identification information included in the commit log received by the information receiving unit 211 indicates its own device, the information sending unit 215 sends an instruction to the cooperating device 4 to confirm receipt of the commit log received by the information receiving unit 211.

The information receiving unit 211 also receives a response notification from the coordinating device 4 indicating that reception of the commit log received by the information receiving unit 211 has been completed successfully. Then, when the information receiving unit 211 receives the response notification sent from the coordinating device 4, the retransmission control unit 214 deletes the commit log received by the information receiving unit 211 from the information storage area 130.

Note that, hereinafter, the process of resending the commit log to the collaboration device 4 (the process performed by the resend control unit 214) is also referred to as the resend process.

Next, we will explain the functions of linked device 4.

As shown in FIG. 7, the linkage device 4 realizes various functions including, for example, an information receiving unit 411, a reception determining unit 412, and an information transmitting unit 413, by organic cooperation between hardware such as a CPU 401 and a memory 402 and a program 410.

The information receiving unit 411 receives the commit log sent by the active device 1. The information receiving unit 411 also receives a receipt confirmation instruction sent by a specific standby device.

The reception determination unit 412 determines whether the information receiving unit 411 has received a commit log and an instruction to confirm receipt. Specifically, when the information receiving unit 411 receives an instruction to confirm receipt, the reception determination unit 412 determines whether the commit log corresponding to the instruction to confirm receipt has already been received.

When the reception determination unit 412 determines that the information receiving unit 411 has received the commit log and an instruction to confirm reception, the information transmitting unit 413 transmits a response notification to a specific standby device indicating that reception of the commit log received by the information receiving unit 411 has been completed successfully.

In addition, the information sending unit 413 sends the commit log received by the information receiving unit 411 to the external system 20.

[Overview of the first embodiment]
Next, an outline of the first embodiment will be described. Figures 8 to 10 are flow charts outlining the log transmission process in the first embodiment. Specifically, Figure 8 is a flow chart outlining the log transmission process in the active device 1. Also, Figure 9 is a flow chart outlining the log transmission process in the standby device 2. Furthermore, Figure 10 is a flow chart outlining the log transmission process in the cooperating device 4. Note that the process in the standby device 3 is the same as the process in the standby device 2, so a description thereof will be omitted.

First, we will provide an overview of the log transmission process in the active device 1.

As shown in FIG. 8, the active device 1 waits until the transaction for database 1b is committed (NO in S1).

Then, when the transaction for database 1b is committed (YES in S1), active device 1 determines a specific standby device that will confirm receipt of the commit log for the committed transaction in collaboration device 4 (S2).

Specifically, active device 1 determines, for example, either standby device 2 or standby device 3 as the specific standby device.

Then, the active device 1 transmits the commit log, to which the identification information of the specific standby device determined in the process of S2 has been added, to the specific standby device determined in the process of S2 and to the cooperating device 4 (S3).

Next, we will provide an overview of the log transmission process on the standby device 2.

As shown in FIG. 9, the standby device 2 waits until it receives the commit log sent from the active device 1 (NO in S11).

Then, when a commit log sent from the active device 1 is received (YES in S11), the standby device 2 determines whether the identification information included in the commit log received in the processing of S11 indicates its own device (S12).

As a result, if it is determined that the identification information included in the commit log received in processing S11 indicates the standby device 2 (YES in S13), the standby device 2 stores the commit log received in processing S11 in the information storage area 230 and instructs the cooperating device 4 to confirm receipt of the commit log received in processing S11 (S14).

Thereafter, if a response notification is received from the collaboration device 4 indicating that reception of the commit log has been completed successfully (YES in S15), the standby device 2 deletes the commit log received in the processing of S11 (the commit log stored in the processing of S14) from the information storage area 230 (S16).

On the other hand, if a response notification indicating that the receipt of the commit log has been completed successfully is not received from the collaboration device 4 (NO in S15), the standby device 2 does not perform the process of S16.

Furthermore, if it is determined in the processing of S11 that the identification information contained in the received commit log does not indicate the standby device 2 (NO in S13), the standby device 2 does not perform processing from S14 onwards.

Next, we will provide an overview of the log transmission process in the linked device 4.

As shown in FIG. 10, the coordinating device 4 receives the commit log from the active device 1 and waits until it receives a receipt confirmation instruction from a specific standby device (NO in S21).

Then, if a commit log and a receipt confirmation instruction are received (YES in S21), the coordinating device 4 sends a response notification to the received receipt confirmation instruction (a response notification indicating that reception of the commit log has been completed successfully) to a specific standby device (S22).

In other words, in the trading system 10 of this embodiment, a specific standby device confirms receipt of the commit log in the linked device 4.

As a result, the trading system 10 in this embodiment can prevent a decrease in processing performance in the active device 1, even if it takes time to wait for a response notification sent from the linked device 4, for example.

[Details of the First Embodiment]
Next, the details of the first embodiment will be described. Figures 11 to 17 are flow charts for explaining the details of the log transmission process in the first embodiment. Figures 18 to 26 are diagrams for explaining the details of the log transmission process in the first embodiment. Note that the process in the standby device 3 is the same as the process in the standby device 2, so a description thereof will be omitted.

[Details of log transmission process in active device]
First, a detailed description will be given of the log transmission process in the active unit 1. Fig. 11 to Fig. 13 are flow charts for explaining the details of the log transmission process in the active unit 1.

As shown in FIG. 11, the information receiving unit 111 waits, for example, until it receives a processing request sent by the reception device 5 (NO in S31).

Then, when a processing request sent by the reception device 5 is received (YES in S31), the information management unit 113 reflects the contents corresponding to the received processing request in the database 1b (S32).

Specifically, for example, if the trading processing unit 112 completes a stock trade, the information management unit 113 writes the contents of the trade order completed by the trading processing unit 112 (the trade order corresponding to the processing request received in the processing of S31) into database 1b. Also, for example, if the trading processing unit 112 does not complete a stock trade, the information management unit 113 writes the contents of the trade order not completed by the trading processing unit 112 (the trade order corresponding to the processing request received in the processing of S31) into database 1b.

Next, the information generation unit 114 generates a commit log for the transaction corresponding to the processing request received in the processing of S31 (S33). Below, a specific example of the commit log generated in the processing of S33 is described.

[Example of a commit log]
18 and 20 are diagrams for explaining specific examples of the commit log CL.

The commit log CL shown in FIG. 18 etc. has as its items "message type" in which the message type indicating the commit log CL is set, "sequence number" in which the sequence number that is the identification number of the transaction corresponding to each commit log CL is set, and "identification information" in which the identification information of the standby device that controls the retransmission of each commit log CL is set. In addition, the commit log CL shown in FIG. 18 etc. has as its items "record number" in which the storage location (storage location in database 1b) of the record corresponding to each commit log CL is set, and "record information" in which the contents of the record corresponding to each commit log CL is set.

Specifically, in the commit log CL shown in FIG. 18, "commit log" is set as the "message type," "0013" is set as the "sequence number," "-" is set as the "identification information" indicating that no information is set, and "0003" is set as the "record number." Note that hereinafter, the record number will also be referred to as a specific item.

Returning to FIG. 11, the device determination unit 115 determines a specific standby device that will confirm receipt of the commit log generated in the processing of S33 in the collaboration device 4 (S34). Details of the processing of S34 will be described below.

[Details of the process of S34]
FIG. 13 is a flow chart illustrating the details of the process of S34.

The device determination unit 115 determines whether or not correspondence information 131 including the record number included in the commit log generated in the process of S33 is stored in the information storage area 130 (S51). A specific example of the correspondence information 131 will be described below.

[Examples of correspondence information]
19 and 21 are diagrams for explaining specific examples of the correspondence information 131. FIG.

The correspondence information 131 shown in FIG. 19 etc. has the following items: "identification information," in which the identification information of each standby device is set, and "record number," in which the storage location of the record corresponding to the commit log for which each standby device performs retransmission control is set. For example, "Standby1," which indicates standby device 2, or "Standby2," which indicates standby device 3, is set as the "identification information."

Specifically, in the correspondence information 131 shown in FIG. 19, for example, in the information in the first line, "Standby2" is set as the "identification information" and "0001" is set as the "record number."

In addition, in the correspondence information 131 shown in FIG. 19, for example, in the information on the second line, "Standby1" is set as the "identification information" and "0002" is set as the "record number." Explanation of the other information included in FIG. 19 is omitted.

Returning to FIG. 13, if it is determined that correspondence information 131 including the record number included in the commit log generated in the processing of S33 is stored in the information storage area 130 (YES in S52), the device determination unit 115 refers to the correspondence information 131 stored in the information storage area 130 and determines the standby device corresponding to the record number included in the commit log generated in the processing of S33 as the specific standby device that will confirm receipt of the commit log generated in the processing of S33 (S53).

Specifically, in the correspondence information 131 described in FIG. 19, the "identification information" of the information (the information in the third line) in which "record number" is set to "0003" is set to "Standby1." Therefore, for example, if the record number included in the commit log generated in the processing of S33 is "0003," the device determination unit 115 determines standby device 2 as the specific standby device.

In other words, the correspondence information 131 includes information about the standby device that is sending (re-sending) the commit log that corresponds to each record number. Therefore, the device determination unit 115 can determine a specific standby device according to the correspondence information 131, thereby making it possible to have the same standby device send commit logs having the same record number.

This enables the active device 1 to prevent the transmission of commit logs having the same record number from being performed on multiple standby devices. Therefore, even if there is a possibility that the order of commit logs transmitted from each standby device may be changed due to network conditions, etc., the active device 1 can prevent the transmission order of commit logs having the same record number from being changed.

On the other hand, if it is determined that the correspondence information 131 including the record number included in the commit log generated in the processing of S33 is not stored in the information storage area 130 (NO in S52), the device determination unit 115 determines, for example, the standby device corresponding to the identification information with the smallest number (proportion) included in the correspondence information 131 stored in the information storage area 130 as the specific standby device that will confirm the reception of the commit log generated in the processing of S33 (S54).

Specifically, in the correspondence information 131 described in FIG. 19, for example, if the number of pieces of information (rows) in which "Identification Information" is set to "Standby1" is less than the number of pieces of information in which "Identification Information" is set to "Standby2", the device determination unit 115 determines standby device 2 as the specific standby device.

This allows the active device 1 to equalize the processing load on each standby device.

Then, the device determination unit 115 stores information associating the record number included in the commit log generated in the process of S33 with the identification information of the standby device determined in the process of S54 in the information storage area 130 as at least part of the correspondence information 131 (S55).

Returning to FIG. 11, the information generation unit 114 adds the identification information of the specific standby device determined in the processing of S34 to the commit log generated in the processing of S33 (S35).

Specifically, if the specific standby device determined in the processing of S34 is standby device 2, the information generation unit 114 sets, for example, "Standby1" to the "identification information" of the commit log described in FIG. 18, as shown in FIG. 20.

Then, the information sending unit 116 sends the commit log to which the identification information was added in the processing of S35 to all standby devices (standby device 2 and standby device 3) and the cooperating device 4 (S36).

Then, as shown in FIG. 12, the information receiving unit 111 waits until it receives a response notification (hereinafter, a first response notification) from all standby devices indicating that the commit log has been received successfully at each standby device (NO in S41). A specific example of the first response notification will be described later.

Then, if the first response notification has been received from all standby devices (YES in S41), the information generation unit 114 updates the correspondence information 131 stored in the information storage area 130 according to the contents of the first response notification received in the processing of S41 (S42).

Specifically, for example, when a first response notification is received from a specific standby device indicating that a commit log with a "record number" of "0002" has been successfully sent to the collaboration device 4, the information generation unit 114 deletes the information with a "record number" of "0002" (the information in the second row) from the correspondence information 131 described in FIG. 19, as shown in FIG. 21.

In other words, the information generation unit 114 updates the correspondence information 131 so that it contains only the record numbers that correspond to the commit logs stored in each standby device.

This allows the active device 1 to identify the record number corresponding to the commit log stored in each standby device by referring to the correspondence information 131 stored in the information storage area 130.

In addition, the information generating unit 114 may perform the process of S42, for example, in response to receiving a first response notification from a specific standby device.

Then, the information sending unit 116 sends a response notification (hereinafter also referred to as a second response notification) to the receiving device 5 indicating that the transaction corresponding to the processing request received in the processing of S31 has been committed in the database 1b (S43).

[Details of log transmission process on standby device]
Next, a detailed description will be given of the log transmission process in the standby device 2. Figures 14 to 16 are flow charts illustrating the details of the log transmission process in the standby device 2.

As shown in FIG. 14, the information receiving unit 211 waits until it receives the commit log sent by the active device 1 (NO in S61).

If a commit log is received (YES in S61), the information determination unit 213 determines whether the identification information included in the commit log received in S61 indicates the device itself (S62).

As a result, if it is determined that the identification information included in the commit log received in S61 does not indicate the device itself (NO in S63), the retransmission control unit 214 generates a first response notification to which the record number of the commit log deleted in the immediately preceding process of S84 is added (S64). A specific example of the first response notification generated in the process of S64 will be described below.

[Specific example (1) of first response notice]
22 and 23 are diagrams illustrating a specific example of the first response notification RS1. Specifically, Fig. 22 is a diagram illustrating a specific example of the first response notification RS1 generated in the process of S64.

The first response notification RS1 shown in FIG. 22 etc. has as its items "Message type" in which the message type indicating the first response notification RS1 is set, and "Sequence number" in which the sequence number that is the identification number of the transaction corresponding to each commit log is set. The first response notification RS1 shown in FIG. 22 etc. also has as its items "Record number" in which the storage location of the record corresponding to each commit log (storage location in database 1b) is set, "Operation type" in which the operation type corresponding to each commit log is set, and "Resent commit log" in which each commit log itself is set.

Specifically, in the first response notification RS1 shown in FIG. 22, "Response notification 1" is set as the "Message type," "0013" is set as the "Sequence number," "0002" is set as the "Record number (1)," "Delete" is set as the "Operation type (1)," and "-" is set as the "Resend commit log," indicating that no information (commit log) is set.

In other words, the first response notification RS1 shown in FIG. 22 is a response notification that is sent when the record number of the commit log deleted in the immediately preceding processing of S84 is "0002."

Returning to FIG. 14, the information transmission unit 215 transmits the first response notification generated in the processing of S64 to the active device 1 (S65).

On the other hand, in the process of S63, if it is determined that the identification information included in the commit log received in S61 indicates the own device (YES in S63), the retransmission control unit 214 stores the commit log received in the process of S61 in the information storage area 230 (S71), as shown in FIG. 15.

Next, the retransmission control unit 214 generates a first response notification to which the record number of the commit log received in the processing of S61 and the record number of the commit log deleted immediately before in S84 are added (S72).

[Specific example (2) of first response notice]
FIG. 23 is a diagram illustrating a specific example of the first response notification RS1 generated in the process of S72.

Specifically, in the first response notification RS1 shown in FIG. 23, "response notification 1" is set as the "message type", "0013" is set as the "sequence number", "0002" is set as the "record number (1)", and "delete" is set as the "operation type (1)". Also, in the first response notification RS1 shown in FIG. 23, "response notification 1" is set as the "message type", "0003" is set as the "record number (2)", "add" is set as the "operation type (2)", and "-" is set as the "re-sent commit log".

In other words, the first response notification RS1 shown in FIG. 23 is a response notification that is sent when the record number of the commit log deleted in the immediately preceding processing of S84 is "0002" and the record number of the commit log received in processing of S61 is "0003."

Returning to FIG. 15, the retransmission control unit 214 determines whether any commit logs other than the commit log received in the processing of S61 are stored in the information storage area 230 (S73).

As a result, if it is determined that no commit logs other than the commit log received in the processing of S61 are stored in the information storage area 230 (NO in S74), the information sending unit 215 sends the first response notification generated in the processing of S72 to each of the active device 1 and the cooperating device 4 (S75).

On the other hand, if it is determined that a commit log other than the commit log received in the processing of S61 is stored in the information storage area 230 (YES in S74), the retransmission control unit 214 adds the commit log other than the commit log received in the processing of S61 to the first response notification generated in the processing of S72 (S81), as shown in FIG. 16.

Specifically, the retransmission control unit 214 sets, for example, the contents of the commit logs stored in the information storage area 230 other than the commit log received in the processing of S61 to the "retransmitted commit log" in the first response notification described in FIG. 23.

Then, the information sending unit 215 sends the first response notification to which the commit log was added in the processing of S81 to the active device 1 and the cooperating device 4 (S82).

Furthermore, after processing of S75 or processing of S82, if a response notification (hereinafter also referred to as a third response notification) indicating that the commit log sent by the active device 1 in processing of S36 has been successfully received is received from the linked device 4 within a predetermined time period (YES in S83), the retransmission control unit 214 deletes the commit log from the information storage area 230 in accordance with the contents of the third response notification received in processing of S83 (S84).

On the other hand, if the third response notification is not received from the linked device 4 within the predetermined time period after the process of S75 or S82 (NO in S83), the retransmission control unit 214 does not execute the process of S84. Specific examples of the third response notification are described below.

[Specific example of third response notice]
FIG. 24 is a diagram illustrating a specific example of the third response notification RS3.

The third response notification RS3 shown in FIG. 24 has the following fields: "Message type," in which the message type indicating the third response notification RS3 is set, and "Sequence number," in which the sequence number that is the identification number of the transaction corresponding to each commit log is set.

Specifically, in the third response notification RS3 shown in FIG. 24, "Response notification 3" is set as the "Message type" and "0013" is set as the "Sequence number."

In other words, the retransmission control unit 214 performs control so that, among the commit logs sent from the active device 1 to the coordinating device 4, those commit logs for which a third response notification indicating that reception has been successfully completed has not been received from the coordinating device 4 are stored in the information storage area 230.

This allows the standby device 2 to easily identify the commit logs that need to be resent to the collaboration device 4 by referring to the commit logs stored in the information storage area 230.

[Details of the log transmission process in the linked device]
Next, the details of the log transmission process in the linking device 4 will be described. FIG. 17 is a flow chart illustrating the details of the log transmission process in the linking device 4.

As shown in FIG. 17, the information receiving unit 411 receives a commit log from the active device 1 and waits until it receives a first response notification from a specific standby device (NO in S91).

Then, when a commit log is received from the active device 1 and a first response notification is received from a specific standby device (YES in S91), the information sending unit 413 sends the received commit log to the external system 20 (S92).

Then, the reception determination unit 412 determines whether the first response notification received in the processing of S91 includes a commit log (S93).

As a result, if it is determined that the first response notification received in the processing of S91 includes a commit log (YES in S94), the information sending unit 413 sends the commit log included in the first response notification received in the processing of S91 to the external system 20 (S95).

On the other hand, if it is determined in the process of S91 that the first response notification received does not include a commit log (NO in S94), the information sending unit 413 does not execute the process of S95.

Then, the information transmission unit 413 transmits a third response notification to the specific standby device indicated by the identification information included in the commit log received in the processing of S91 (S96).

This enables the coordinating device 4 to send a third response notification corresponding to the successfully received commit log to a specific standby device.

In this way, in this embodiment, when a transaction to database 1b is committed, active device 1 determines a specific standby device that will confirm receipt of the commit log in collaboration device 4. Then, active device 1 transmits the commit log, to which the identification information of the determined specific standby device has been added, to each of collaboration device 4 and the specific standby device.

After that, when the specific standby device receives a commit log from the active device 1, it determines whether the identification information included in the received commit log indicates its own device (the specific standby device). As a result, if it determines that the identification information included in the received commit log indicates its own device, the specific standby device stores the commit log in the memory unit and sends an instruction to the cooperating device 4 to confirm receipt of the commit log.

Then, when the coordinating device 4 receives the commit log from the active device 1 and receives an instruction to confirm receipt of the commit log from a specific standby device, it sends a response notification to the specific standby device indicating that confirmation of receipt of the commit log has been completed successfully.

Furthermore, when a particular standby device receives a response notification from the cooperating device 4 indicating that confirmation of receipt of the commit log has been successfully completed, the particular standby device deletes the commit log received from the active device 1 from the memory unit.

In other words, in the trading system 10 of this embodiment, a specific standby device confirms receipt of the commit log in the linked device 4.

As a result, the trading system 10 in this embodiment can prevent a decrease in processing performance in the active device 1, even if it takes time to wait for a response notification sent from the linked device 4, for example.

[Specific example of log transmission process (1)]
Next, a specific example of the log transmission process in the case where the retransmission of the commit log to the collaboration device 4 does not occur will be described. Fig. 25 is a sequence chart diagram illustrating a specific example of the log transmission process in the case where the retransmission of the commit log to the collaboration device 4 does not occur. Note that the following description will be given for the case where the standby device 3 is a specific standby device.

Specifically, the reception device 5 transmits a processing request (1) sent from, for example, an information processing system (not shown) of a securities company to the active device 1.

When the active device 1 receives a processing request (1) sent from the receiving device 5, it sends a commit log (1) for the transaction corresponding to the processing request (1) to each of the standby device 2, the standby device 3, and the cooperating device 4.

Then, in response to receiving the commit log (1) sent by the active device 1, the standby device 2 sends a first response notification (1) to the active device 1.

In addition, upon receiving the commit log (1) sent by the active device 1, the standby device 3 stores the received commit log (1) in the information storage area 130, sends a first response notification (2) to the active device 1, and further sends a first response notification (3) to the cooperating device 4.

Then, in response to receiving the first response notification (2) sent by the standby device 3, the active device 1 sends a second response notification (1) to the receiving device 5. In this case, the active device 1 generates correspondence information 131 that associates the commit log (1) with the identification information of the standby device 3 and stores it in the information storage area 130.

In addition, in response to receiving the first response notification (3) sent by the standby device 3, the cooperating device 4 sends the commit log (1) sent by the active device 1 to the external system 20, and further sends a third response notification (1) to the standby device 3. After that, in response to receiving the third response notification (1) sent by the cooperating device 4, the standby device 3 deletes the commit log (1) stored in the information storage area 330.

Then, for example, after receiving the second response notification (1) sent by the active device 1, the reception device 5 sends a processing request (2) to the active device 1.

Then, when the active device 1 receives the processing request (2) sent from the receiving device 5, it sends a commit log (2) for the transaction corresponding to the processing request (2) to each of the standby device 2, the standby device 3, and the cooperating device 4.

Then, in response to receiving the commit log (2) sent by the active device 1, the standby device 2 sends a first response notification (4) to the active device 1.

In addition, upon receiving the commit log (2) sent by the active device 1, the standby device 3 stores the received commit log (2) in the information storage area 330, sends a first response notification (5) to the active device 1, and further sends a first response notification (6) to the cooperating device 4.

Then, in response to receiving the first response notification (5) sent by the standby device 3, the active device 1 sends a second response notification (2) to the receiving device 5. In this case, the active device 1 deletes the correspondence information 131 that associates the commit log (1) with the identification information of the standby device 3 from the information storage area 130, and generates correspondence information 131 that associates the commit log (2) with the identification information of the standby device 3 and stores it in the information storage area 130.

In addition, in response to receiving the first response notification (6) sent by the standby device 3, the cooperating device 4 sends the commit log (2) sent by the active device 1 to the external system 20, and further sends a third response notification (2) to the standby device 3. After that, in response to receiving the third response notification (2) sent by the cooperating device 4, the standby device 3 deletes the commit log (2) stored in the information storage area 330.

[Specific example of log transmission process (2)]
Next, a specific example of the log transmission process will be described in the case where a retransmission of a commit log occurs to the coordination device 4. Fig. 26 is a sequence chart diagram illustrating a specific example of the log transmission process in the case where a retransmission of a commit log occurs to the coordination device 4.

Specifically, the reception device 5 transmits a processing request (1) sent from, for example, an information processing system (not shown) of a securities company to the active device 1.

When the active device 1 receives a processing request (1) sent from the receiving device 5, it sends a commit log (1) for the transaction corresponding to the processing request (1) to each of the standby device 2, the standby device 3, and the cooperating device 4.

Then, in response to receiving the commit log (1) sent by the active device 1, the standby device 2 sends a first response notification (1) to the active device 1.

In addition, upon receiving the commit log (1) sent by the active device 1, the standby device 3 stores the received commit log (1) in the information storage area 130, sends a first response notification (2) to the active device 1, and further sends a first response notification (3) to the cooperating device 4.

Then, in response to receiving the first response notification (2) sent by the standby device 3, the active device 1 sends a second response notification (1) to the receiving device 5. In this case, the active device 1 generates correspondence information 131 that associates the commit log (1) with the identification information of the standby device 3 and stores it in the information storage area 130.

Here, if the transmission of commit log (1) from active device 1 to coordinating device 4 fails, unlike the case described in FIG. 25, coordinating device 4 does not transmit third response notification (1) to standby device 3 even if it receives first response notification (3) sent by standby device 3. Therefore, in this case, the standby device 3 does not delete commit log (1).

Then, for example, after receiving the second response notification (1) sent by the active device 1, the reception device 5 sends a processing request (2) to the active device 1.

Then, when the active device 1 receives the processing request (2) sent from the receiving device 5, it sends a commit log (2) for the transaction corresponding to the processing request (2) to each of the standby device 2, the standby device 3, and the cooperating device 4.

Then, in response to receiving the commit log (2) sent by the active device 1, the standby device 2 sends a first response notification (4) to the active device 1.

In addition, in response to receiving the commit log (2) sent by the active device 1, the standby device 3 stores the received commit log (2) in the information storage area 330 and sends a first response notification (5) to the active device 1. Here, both the commit log (1) and the commit log (2) are stored in the information storage area 330. Therefore, unlike the case described in FIG. 25, the standby device 3 sends not only the first response notification (6) but also the commit log (1) to the cooperating device 4.

Then, in response to receiving the first response notification (5) sent by the standby device 3, the active device 1 sends a second response notification (2) to the receiving device 5. In this case, the active device 1 generates correspondence information 131 that associates the commit log (2) with the identification information of the standby device 3 and stores it in the information storage area 130.

In addition, in response to receiving the first response notification (6) and commit log (1) sent by the standby device 3, the coordinating device 4 transmits the commit log (1) sent (retransmitted) by the standby device 3 and the commit log (2) sent by the active device 1 to the external system 20, and further transmits a third response notification (2) to the standby device 3. After that, in response to receiving the third response notification (2) sent by the coordinating device 4, the standby device 3 deletes the commit log (1) and the commit log (2) stored in the information storage area 330.

This enables the standby device 3 (a specific standby device) to resend the commit log to the cooperating device 4 on behalf of the active device 1. Therefore, the standby device 3 can reduce the processing load on the active device 1.

The above embodiments can be summarized as follows:

(Appendix 1)
An information processing system including a first information processing device that transmits a commit log for a transaction on a database, a second information processing device and a third information processing device that receive the commit log from the first information processing device, and a transmission destination device that receives the commit log from the first information processing device,
When the transaction is committed, the first information processing device determines that an information processing device that will perform a reception confirmation of the commit log at the destination device is one of the second information processing device and the third information processing device;
the first information processing device transmits the commit log to which identification information of the determined one of the information processing devices has been added, to the destination device and the one of the information processing devices, respectively;
When the information processing device receives the commit log from the first information processing device, the information processing device determines whether the identification information included in the received commit log indicates the information processing device itself;
When the information processing device determines that the identification information included in the commit log indicates the information processing device itself, the information processing device stores the commit log in a storage unit and transmits an instruction to the transmission destination device to confirm receipt of the commit log;
the destination device receives the commit log from the first information processing device and, upon receiving an instruction to confirm the receipt of the commit log from any one of the information processing devices, transmits a receipt confirmation result indicating that the receipt of the commit log at the destination device has been successfully completed to any one of the information processing devices;
When any of the information processing devices receives the receipt confirmation result from the destination device, the information processing device deletes the commit log from the storage unit.
An information processing system comprising:

(Appendix 2)
In Appendix 1,
The first information processing device,
storing, in a storage unit, correspondence information that associates information corresponding to a specific item included in the commit log with the identification information;
When a new transaction is committed to the database, refer to the storage unit and determine whether or not the corresponding information including information corresponding to the specific item included in a new commit log for the new transaction is stored in the storage unit;
When it is determined that the corresponding information is stored in the storage unit, referring to the storage unit, the identification information associated with the information corresponding to the specific item included in the new commit log is identified;
determining the information processing device indicated by the specified identification information as an information processing device that will perform reception confirmation of the new commit log at the destination device;
An information processing system comprising:

(Appendix 3)
In Appendix 2:
When the first information processing device determines that the correspondence information is not stored in the storage unit, the first information processing device refers to the storage unit, and identifies an information processing device that includes the smallest ratio of the identification information in the correspondence information as an information processing device that will perform reception confirmation of the new commit log at the transmission destination device.
An information processing system comprising:

(Appendix 4)
In Appendix 2:
when the first information processing device receives a notification from any one of the information processing devices indicating that the commit log has been deleted from the storage unit, the first information processing device deletes the correspondence information from the storage unit.
An information processing system comprising:

(Appendix 5)
In Appendix 1,
Any one of the information processing devices,
When a new commit log is received from the first information processing device, it is determined whether or not the identification information included in the received new commit log indicates the first information processing device;
When it is determined that the identification information included in the new commit log indicates the own device, the new commit log is stored in the storage unit, and when the commit log is stored in the storage unit, an instruction to confirm receipt of the new commit log and the commit log are transmitted to the transmission destination device;
when receiving, from the destination device, a reception confirmation result indicating that the reception of the new commit log at the destination device has been completed normally, the commit log and the new commit log are deleted from the storage unit;
An information processing system comprising:

(Appendix 6)
A log transmission program that causes a computer to execute a process of transmitting a commit log about a transaction for a database to a destination device,
determining another information processing device that will acknowledge receipt of the commit log in the destination device when the transaction is committed;
transmitting the commit log to which the identification information of the determined other information processing device has been added, to the destination device and the other information processing device, respectively;
A log transmission program comprising:

(Appendix 7)
A log transmission program that causes a computer to execute a process of transmitting a commit log about a transaction for a database to a destination device,
When the commit log is received from the other information processing device, it is determined whether or not identification information included in the received commit log indicates the own device;
When it is determined that the identification information included in the commit log indicates the own device, the commit log is stored in a storage unit, and an instruction to the transmission destination device to confirm receipt of the commit log is transmitted;
when receiving, from the destination device, a reception confirmation result indicating that reception of the commit log at the destination device has been completed normally, the commit log is deleted from the storage unit;
A log transmission program comprising:

(Appendix 8)
An information processing device that transmits a commit log regarding a transaction for a database to a destination device,
a device determination unit that determines another information processing device that will acknowledge receipt of the commit log in the destination device when the transaction is committed;
an information transmission unit that transmits the commit log to which the identification information of the determined other information processing device is added, to the destination device and the other information processing device,
23. An information processing apparatus comprising:

(Appendix 9)
An information processing device that transmits a commit log regarding a transaction for a database to a destination device,
an information determination unit that, when receiving the commit log from another information processing device, determines whether or not identification information included in the received commit log indicates the information processing device itself;
an information transmission unit that stores the commit log in a storage unit and transmits an instruction to the destination device to confirm receipt of the commit log when it is determined that the identification information included in the commit log indicates the destination device;
a retransmission control unit that deletes the commit log from the storage unit when a reception confirmation result indicating that the reception of the commit log at the transmission destination device has been completed normally is received from the transmission destination device.
23. An information processing apparatus comprising:

(Appendix 10)
A log transmission method in an information processing system having a first information processing device that transmits a commit log for a transaction on a database, a second information processing device and a third information processing device that receive the commit log from the first information processing device, and a destination device that receives the commit log from the first information processing device, comprising:
When the transaction is committed, the first information processing device determines that an information processing device that will perform a reception confirmation of the commit log at the destination device is one of the second information processing device and the third information processing device;
the first information processing device transmits the commit log to which identification information of the determined one of the information processing devices has been added, to the destination device and the one of the information processing devices, respectively;
When the information processing device receives the commit log from the first information processing device, the information processing device determines whether the identification information included in the received commit log indicates the information processing device itself;
When the information processing device determines that the identification information included in the commit log indicates the information processing device itself, the information processing device stores the commit log in a storage unit and transmits an instruction to the transmission destination device to confirm receipt of the commit log;
the destination device receives the commit log from the first information processing device and, upon receiving an instruction to confirm the receipt of the commit log from any one of the information processing devices, transmits a receipt confirmation result indicating that the receipt of the commit log at the destination device has been successfully completed to any one of the information processing devices;
When any of the information processing devices receives the receipt confirmation result from the destination device, the information processing device deletes the commit log from the storage unit.
A log transmission method comprising:

1: Active device 1a: Processing unit 1b: Database 2: Standby device 2a: Processing unit 2b: Database 3: Standby device 3a: Processing unit 3b: Database 4: Cooperative device 5: Reception device 10: Information processing system 20: External system

Claims (8)

An information processing system including a first information processing device that transmits a commit log for a transaction on a database, a second information processing device and a third information processing device that receive the commit log from the first information processing device, and a transmission destination device that receives the commit log from the first information processing device,
When the transaction is committed, the first information processing device determines that an information processing device that will perform a reception confirmation of the commit log at the destination device is one of the second information processing device and the third information processing device;
the first information processing device transmits the commit log to which identification information of the determined one of the information processing devices has been added, to the destination device and the one of the information processing devices, respectively;
When the information processing device receives the commit log from the first information processing device, the information processing device determines whether the identification information included in the received commit log indicates the information processing device itself;
When the information processing device determines that the identification information included in the commit log indicates the information processing device itself, the information processing device stores the commit log in a storage unit and transmits an instruction to the transmission destination device to confirm receipt of the commit log;
the destination device receives the commit log from the first information processing device and, upon receiving an instruction to confirm the receipt of the commit log from any one of the information processing devices, transmits a receipt confirmation result indicating that the receipt of the commit log at the destination device has been successfully completed to any one of the information processing devices;
When any of the information processing devices receives the receipt confirmation result from the destination device, the information processing device deletes the commit log from the storage unit.
An information processing system comprising: In claim 1,
The first information processing device,
storing, in a storage unit, correspondence information that associates information corresponding to a specific item included in the commit log with the identification information;
When a new transaction is committed to the database, refer to the storage unit and determine whether or not the corresponding information including information corresponding to the specific item included in a new commit log for the new transaction is stored in the storage unit;
When it is determined that the corresponding information is stored in the storage unit, referring to the storage unit, the identification information associated with the information corresponding to the specific item included in the new commit log is identified;
determining the information processing device indicated by the specified identification information as an information processing device that will perform reception confirmation of the new commit log at the destination device;
An information processing system comprising: In claim 2,
When the first information processing device determines that the correspondence information is not stored in the storage unit, the first information processing device refers to the storage unit, and identifies an information processing device that includes the smallest ratio of the identification information in the correspondence information as an information processing device that will perform reception confirmation of the new commit log at the transmission destination device.
An information processing system comprising: In claim 2,
when the first information processing device receives a notification from any one of the information processing devices indicating that the commit log has been deleted from the storage unit, the first information processing device deletes the correspondence information from the storage unit.
An information processing system comprising: In claim 1,
Any one of the information processing devices,
When a new commit log is received from the first information processing device, it is determined whether or not the identification information included in the received new commit log indicates the first information processing device;
When it is determined that the identification information included in the new commit log indicates the own device, the new commit log is stored in the storage unit, and when the commit log is stored in the storage unit, an instruction to confirm receipt of the new commit log and the commit log are transmitted to the transmission destination device;
when receiving, from the destination device, a reception confirmation result indicating that the reception of the new commit log at the destination device has been completed normally, the commit log and the new commit log are deleted from the storage unit;
An information processing system comprising: A log transmission program that causes a computer to execute a process of transmitting a commit log about a transaction for a database to a destination device,
When the commit log is received from the other information processing device, it is determined whether or not identification information included in the received commit log indicates the own device;
When it is determined that the identification information included in the commit log indicates the own device, the commit log is stored in a storage unit, and an instruction to the transmission destination device to confirm receipt of the commit log is transmitted;
when receiving, from the destination device, a reception confirmation result indicating that reception of the commit log at the destination device has been completed normally, the commit log is deleted from the storage unit;
A log transmission program comprising: An information processing device that transmits a commit log regarding a transaction for a database to a destination device,
an information determination unit that, when receiving the commit log from another information processing device, determines whether or not identification information included in the received commit log indicates the information processing device itself;
an information transmission unit that stores the commit log in a storage unit and transmits an instruction to the destination device to confirm receipt of the commit log when it is determined that the identification information included in the commit log indicates the destination device;
a retransmission control unit that deletes the commit log from the storage unit when a reception confirmation result indicating that the reception of the commit log at the transmission destination device has been completed normally is received from the transmission destination device.
23. An information processing apparatus comprising: A log transmission method in an information processing system having a first information processing device that transmits a commit log for a transaction on a database, a second information processing device and a third information processing device that receive the commit log from the first information processing device, and a destination device that receives the commit log from the first information processing device, comprising:
When the transaction is committed, the first information processing device determines that an information processing device that will perform a reception confirmation of the commit log at the destination device is one of the second information processing device and the third information processing device;
the first information processing device transmits the commit log to which identification information of the determined one of the information processing devices has been added, to the destination device and the one of the information processing devices, respectively;
When the information processing device receives the commit log from the first information processing device, the information processing device determines whether the identification information included in the received commit log indicates the information processing device itself;
When the information processing device determines that the identification information included in the commit log indicates the information processing device itself, the information processing device stores the commit log in a storage unit and transmits an instruction to the transmission destination device to confirm receipt of the commit log;
the destination device receives the commit log from the first information processing device and, upon receiving an instruction to confirm the receipt of the commit log from any one of the information processing devices, transmits a receipt confirmation result indicating that the receipt of the commit log at the destination device has been successfully completed to any one of the information processing devices;
When any of the information processing devices receives the receipt confirmation result from the destination device, the information processing device deletes the commit log from the storage unit.
A log transmission method comprising:

Images