JP4334251B2 - Transaction execution management program and transaction processing apparatus - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a transaction execution management program for causing a computer to execute execution management for a transaction composed of a plurality of processes, and a transaction processing apparatus for executing the transaction processing .
[0002]
[Prior art]
For example, as shown in Non-Patent Document 1, a transaction management mechanism that regards a plurality of processes related to each other as a single block (transaction) for convenience and manages the execution of each process constituting this transaction is an RDBMS (relational It has been mainly used for execution management of computer systems such as databases and management systems.
[0003]
For example, as shown in FIG. 6, in a financial institution or the like, when a public fee Y such as a gas fee is transferred from a customer account 1 to a gas company account 2, the balance confirmation R [A] of the customer account 1 Write the result of subtracting the charge Y into the customer account 1 W [A], the balance confirmation R [X] of the gas company account 2, and the amount obtained by adding the utility charge Y to the balance is written into the gas company account 2 The transaction tr is composed of four processes with the result writing W [X].
[0004]
tr = R [A] → W [A] → R [X] → W [X]
Under such an environment, if one of the four processes R [A] to W [X] does not end normally, it is necessary to cancel the execution result of the process that has ended normally. That is, generally, in the transaction tr, all the processes R [A] to W [X] constituting the transaction tr are normally completed (commit), or all the processes R [A] to W [X] are nothing. Either it was not done (Abort) was the transaction termination method.
[0005]
Therefore, generally, if all processing ends normally, the transaction management mechanism automatically issues a commit to all processing, and if any processing does not end normally, an abort is generally issued. It is.
[0006]
In addition, in the execution result of each process that constitutes a transaction, when a process that ends normally and a process that does not end normally coexist, an instruction to commit or abort the entire transaction is sent to the transaction requester or In some cases, an application program can be specified. For example, a relational database. In this case, however, it is only possible to specify whether to commit or abort all processing.
[0007]
Non-Patent Document 2 describes Web service technology that collects or provides various services such as travel information via the Internet.
[0008]
[Non-Patent Document 1]
By Media Mix Project, edited by Ishizaki Co., Ltd. “Illustration Trilogy Database”, Natsume 2002.3, p180-p187
[0009]
[Non-Patent Document 2]
Toshiba Corporation Nishizawa, Hayase, Yamada, Yano, Yamamoto, “Web Service Design and Analysis Guide -Object-oriented Modeling Guide-”, Softbank Publishing Co., Ltd. 2002.12, p7-p11
[0010]
[Problems to be solved by the invention]
However, the above-described model for committing or aborting the entire transaction is not always convenient when various services such as travel information described in Non-Patent Document 2 are applied to Web services that are collected or provided via the Internet. Not good.
[0011]
The first problem is that the management of the processing status on the system is not sufficient. For example, even if the sale processing of a product for a certain customer can be processed on the Web service process, the business cannot be said to be finished until the delivery of the product to the customer is actually finished. Therefore, it is necessary to manage the state including the delivery of this product.
[0012]
The second problem is that when an actual business (including a human system) is managed, an alternative idea such as commit / abort may not be sufficient. For example, in the real world, as shown in FIG. 7, it is assumed that three processes of [taxi reservation], [restaurant reservation], and [hotel reservation] are incorporated in one transaction tr.
[0013]
In this case, according to the above-described transaction theory, in principle, this transaction is committed only when a normal reservation can be made in the three processes, and each reservation result is notified to the customer who requested execution of the transaction.
[0014]
However, depending on the customer, if only a restaurant can be reserved, it may be accepted, or no reservation may be made (aborted). In other words, the transaction execution requester (customer) generally determines whether or not to accept the execution result of each process of the transaction according to each result for the initial request.
[0015]
The present invention has been made in view of such circumstances, and the execution requester of the transaction can selectively receive the execution result of each process, and can realize various requests of the execution requester of the transaction. It is an object of the present invention to provide a transaction execution management program that enables processing similar to the determination / termination in the world and can greatly improve the service to the transaction execution requester.
[0016]
[Means for Solving the Problems]
In order to solve the above-described problems, the present invention provides a function for causing a computer to instruct a process execution unit to execute each process constituting an operation-designated transaction and an execution result of each process constituting the transaction. This is a transaction execution management program for realizing a function for terminating each processing based on the above.
[0017]
In addition, the transaction execution management program has a function that causes the computer to output the execution result of each process when all processes included in the transaction are completed in the process execution unit, and an operation is designated after the execution result of each process is output. The function to input the termination method is realized. Further, the function for terminating each process terminates each process constituting the corresponding transaction in accordance with the inputted termination method.
[0018]
In the transaction execution management program configured as described above, each process constituting the transaction designated by the transaction execution requester is sequentially executed by the process execution unit, and the execution result of each process is displayed and output, for example. . The transaction execution requester refers to the execution result of each process displayed and output, and designates a closing method for the transaction. The transaction is terminated according to this termination method.
[0019]
As a closing method, when the execution results of some processes that make up a transaction are the target results and the execution results of other processes are not the target results, the execution results for the processes that have obtained the target results that make up the transaction are confirmed. Termination method that cancels the execution result for a process for which the target result cannot be obtained, and when the execution result of some processes constituting the transaction is the target result and the execution result of the other processes is not the target result, all the processes constituting the transaction A termination method for canceling the execution results of processes, a termination method for determining the execution results of all processes constituting a transaction when the execution results of all processes constituting the transaction are the target results, and the like can be realized.
[0020]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
FIG. 1 is a block diagram showing a schematic configuration of a transaction execution management apparatus to which a transaction execution management program according to an embodiment of the present invention is applied.
[0021]
The transaction execution management apparatus 3 instructs the process execution unit 5 to execute each process 6 specified by the user 4 who is the transaction execution requester, and displays the execution result of each process 6 on the display 7. Then, according to the termination method designated by the user 4, the corresponding transaction is terminated.
[0022]
Next, the specific configuration of each unit will be described in order.
The transaction definition unit 8 sets each transaction in the transaction definition table 10 based on a setting instruction given by a setting person 9 such as an administrator of the transaction execution management apparatus 3. In the transaction definition table 10, as shown in FIG. 2, for each transaction 11, a plurality of processes 6 that are executed in the transaction 11 are stored. In this example, two types of transactions 11 are defined, tr1 and tr2. The transaction 11 of tr1 is a transaction that sequentially executes three processes 6 such as p1, p2, and p3. The tr2 transaction 11 is a transaction that executes the processes 6 of p3 and p4 in parallel.
[0023]
The execution transaction specifying unit 12 reads the transaction 11 specified by the user 4 from the transaction definition table 10, assigns and sets a transaction execution number to the transaction execution status table 13, and sends it to the transaction execution instruction unit 14.
[0024]
In the transaction execution status table 13, as shown in FIG. 3, for each transaction execution number, the transaction name (ID) of the transaction 11 such as tr1, tr2, etc., and the latest execution status of each process 6 constituting the transaction 11 are shown. 15 is stored. For example, in the transaction 11 of tr3 having the transaction execution number “1”, the process 6 of p3 is “executed” and the process 6 of p4 is “being executed”.
[0025]
The transaction execution instruction unit 14 sends an execution instruction for the transaction 11 read from the transaction definition table 10 to the process execution unit 5. The process execution unit 5 executes the processes 6 of the transaction 11 in the designated order.
[0026]
The transaction execution monitoring unit 15 detects the execution state of each process 6 in each transaction 11 in the process execution unit 5 at regular time intervals, and determines the execution state 15 of each process 6 in the transaction 11 in the transaction execution status table 13. Update. Further, when the execution state of all the processes 6 constituting the transaction 11 being executed becomes “executed”, the transaction execution monitoring unit 15 sends the execution result of each process 6 of the transaction 11 to the transaction execution result table 17. Write.
[0027]
In the transaction execution result table 17, as shown in FIG. 4, for each transaction execution number, the transaction name (ID) of the transaction 11 such as tr 1, tr 2, and the execution result 18 of each process 6 constituting the transaction 11 are stored. It is written. For example, the process result 18 of the process 3 of p3 in the transaction 11 with the transaction execution number “1” is the target result “OK”, and the process result 18 of the process 6 of p4 is “NG” which is not the target result.
[0028]
The execution result notifying unit 19 displays and outputs the execution result 18 of each process 6 of each transaction 11 written in the transaction execution result table 17 on the display unit 7.
[0029]
The termination method input unit 20 transfers the termination method input by the user 4 who has confirmed the execution result 18 of each process 6 of the transaction 11 displayed on the display 7 to the transaction termination unit 21. The transaction termination unit 21 terminates the transaction 11 with a designated termination method.
[0030]
Here, an example of a closing method for the transaction 11 designated by the user 4 will be described.
[0031]
(A) When the execution result 18 objective result of the part of the processing 6 forming the transaction 11 [OK] a and the execution result 18 of other processing 6 is not the objective results [NG], the purpose of constituting a transaction 11 The execution result 18 for the process 6 in which the result is obtained is confirmed, and the execution result 18 for the process 6 in which the target result is not obtained is canceled.
[0032]
(B) When the execution result 18 The purpose of some of the process 6 constituting the transaction 11 Results [OK] a is another execution of the processing result 18 is not the objective results [NG], all constituting the transaction 11 Cancels the execution result 18 of the process 6.
[0033]
(C) When the execution results 18 of all the processes 6 constituting the transaction are the target result [OK], the execution results 18 of all the processes 6 constituting the transaction 11 are determined.
[0034]
(D) When the execution results 18 of all the processes 6 constituting the transaction 11 are not the target result [NG] , the execution results 18 of all the processes 6 constituting the transaction 11 are canceled.
[0035]
(E) Only the execution result 18 of the arbitrarily designated process 6 among the processes 6 of the target result [OK] constituting the transaction 11 is confirmed, and the execution results 18 of all other processes 6 are canceled.
[0036]
In this way, the user 4 can terminate the transaction 11 by any termination method with reference to the execution result 18 of each process 6 of the transaction 11 displayed on the display 7.
[0037]
A transaction execution management program 23 is stored in a storage device 22 such as an HDD provided in the transaction execution management device 3 constituted by a kind of information processing device such as a computer. The transaction execution management device 3 such as this computer activates the transaction execution management program 23 to realize the above-described units 8, 12, 14, 16, 19, 20, and 21.
[0038]
Then, each of the above-described units 8, 12, 14, 16, 19, 20, and 21 realized in the transaction execution management apparatus 3 executes execution management for the transaction 11 according to the flowchart shown in FIG.
[0039]
When the transaction name (ID) of the transaction 11 to be executed is input from the user 4 (S1), a transaction number is issued to the transaction 11 (S2), and the transaction 11 is read from the transaction definition table 10. The previously issued transaction number is assigned and set in the transaction execution status table 13 (S3). Then, the corresponding transaction 11 is activated (S4).
[0040]
When the execution of one process 6 is completed in S5, an “executed” execution status 16 indicating completion is written in the corresponding process 6 of the corresponding transaction 11 in the transaction execution status table 13 (S6). When the execution status 16 of all the processes 6 constituting the transaction 11 in the transaction execution status table 13 is “executed” indicating completion (S7), each transaction 11 in the transaction execution result table 17 is displayed in the transaction execution result table 17. The execution result 18 of process 6 is written (S8). Then, the execution result 18 of each process 6 of the transaction 11 is output and displayed on the display 7 (S9).
[0041]
When the user 4 inputs a termination method for the transaction 11 (S10), the transaction 11 is terminated by the designated termination method (S11).
[0042]
In the transaction execution management apparatus 3 to which the transaction execution management program configured as described above is applied, each process 6 constituting the transaction 11 designated by the user 4 who is the execution requester of the transaction 11 is a process execution unit. When the execution for all the processes 6 constituting the transaction 11 is completed, the execution result 18 of each process 6 is displayed on the display unit 7.
[0043]
When the user 4 refers to the execution result 18 of each process 6 of the transaction 11 displayed on the display device 7 and designates a termination method for the transaction 11, the transaction 11 is terminated according to the termination method.
[0044]
In this way, since the user 4 can arbitrarily designate the termination method for the transaction 11, it is possible to terminate the request in the same way as the request termination method in the real world. effective.
[0045]
For example, when a web service becomes widespread, an application receives provision of several web services and configures processing as a whole. Each Web service may consider that each process 6 of the transaction 11 corresponds to actual work such as “taxi reservation”, “restaurant reservation”, and “hotel reservation” as shown in FIG. it can. In such a case, according to each reservation result (execution result), whether to reserve only a taxi or only a hotel can be freely specified. Very convenient.
[0046]
In addition, each component demonstrated by each said embodiment may be combined freely, and may be divided | segmented into a some element. Further, the transaction execution management program 23 in the embodiment may be distributed over a plurality of computers and operate in cooperation with each other.
[0047]
Further, the transaction execution management program 23 can be applied to a computer by being transmitted through a communication medium. The operation of the computer that has read the transaction execution management program 23 is controlled by the transaction execution management program 23 to realize the above-described functions.
[0048]
【The invention's effect】
As described above, in the transaction execution management program of the present invention, the transaction execution requester can selectively accept the execution result of each process, and various requests of the transaction execution requester can be realized. It is possible to perform the same processing as the determination / termination in the world, and the service for the requester of the transaction can be greatly improved.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a schematic configuration of a transaction execution management apparatus to which a transaction execution management program according to an embodiment of the present invention is applied. FIG. 2 is a storage content of a transaction definition table formed in the transaction execution management apparatus. FIG. 3 is a view showing the storage contents of a transaction execution status table formed in the transaction execution management apparatus. FIG. 4 is a view showing storage contents of a transaction execution result table formed in the transaction execution management apparatus. FIG. 5 is a flowchart showing transaction execution management operations in the transaction execution management apparatus. FIG. 6 is a diagram showing conventional transaction processing operations. FIG. 7 is a diagram showing an example of applying a transaction to a real-world Web service. Explanation of]
DESCRIPTION OF SYMBOLS 3 ... Transaction execution management apparatus, 4 ... User, 5 ... Process execution part, 6 ... Process, 7 ... Display, 8 ... Transaction definition part, 10 ... Transaction definition table, 11 ... Transaction, 12 ... Transaction designation | designated part, 13 ... Transaction execution status table, 14 ... Transaction execution instruction section, 16 ... Transaction execution monitoring section, 17 ... Transaction execution result table, 18 ... Execution result, 20 ... Termination input section, 21 ... Transaction termination section, 23 ... Transaction execution management program

Claims (2)

A function for causing a computer to instruct the execution of each process constituting the operation-designated transaction to be executed and a function for terminating each process based on the execution result of each process constituting the transaction. In the transaction execution management program for
A function for causing the computer to output an execution result of each process when all the processes included in the transaction are completed in the process execution unit and a termination method designated for operation after outputting the execution result of each process are input to the computer Function and
The function for terminating each process is characterized in that each process constituting the transaction is terminated according to the input termination method,
The operation designated termination method is
(A) When an execution result of a part of the processes constituting the transaction is a target result and an execution result of another process is not the target result, the execution result for the process from which the target result constituting the transaction is obtained is determined. And a termination method for canceling an execution result for a process for which the target result cannot be obtained,
(B) a termination method for canceling the execution results of all the processes constituting the transaction when the execution results of some processes constituting the transaction are the target results and the execution results of other processes are not the target results;
(C) A function of selecting any one termination method from among termination methods for determining execution results of all the processes constituting the transaction when the execution results of all the processes constituting the transaction are target results. A transaction execution management program characterized by comprising: A transaction execution instruction unit for instructing execution of each process constituting the transaction in accordance with a user operation;
A process execution unit for executing transaction processing in accordance with an instruction from the transaction execution instruction unit;
A display unit that presents information about the execution result of each process executed by the process execution unit to the user, and a termination method designated by the user for the information about the execution result of each process displayed on the display unit A transaction ending unit for ending the transaction process specified by the operation,
The transaction closing unit follows a closing method designated by the user,
(A) When an execution result of a part of the processes constituting the transaction is a target result and an execution result of another process is not the target result, the execution result for the process from which the target result constituting the transaction is obtained is determined. And a termination process for canceling the execution result for the process for which the target result cannot be obtained,
(B) a termination process for canceling the execution results of all the processes constituting the transaction when the execution results of some processes constituting the transaction are the target results and the execution results of other processes are not the target results;
(C) When the execution result of all the processes constituting the transaction is the target result, executing one of the termination processes for finalizing the execution results of all the processes constituting the transaction A transaction processing apparatus.

Images