JPH09198347A - On-line transaction processing server computer - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a high load transaction processing system having extendibility and flexibility. SOLUTION: The transaction management part 21 of a server computer 2 receiving/transmitting transaction request/response messages 101 and 102 with a client computer 1 through a communication line schedules a transaction processing, rearranges the transaction request message 101 in a reception queue in order from the message whose processing period is the shortest and starts the transaction processing. A transaction processing part 22 takes out the request message 101 by the respective means from the reception queue of the transaction management part 21, acquires necessary journal information, updates data, returns the response message 102 to the transaction management part 21 and terminates the processing.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an OLTP server computer applied to high load / large scale online transaction processing (OLTP).

[0002]

2. Description of the Related Art A conventional OLTP server computer disclosed in, for example, Japanese Patent Laid-Open No. 62-145366 has a transaction processing request / response message 101/102 with a client computer 1 via a communication line as shown in FIG.
In the server computer 2 that receives / sends the request / response message 101/1,
02 is received / transmitted, the transaction process is scheduled, and the request message 101 received from the client computer 1 by the transaction process activation management means is processed in a first-in first-out (FIFO) operation at regular time intervals or in a queue (waiting). The transaction request is provided to the transaction processing unit 22 and the transaction processing is started. The transaction processing unit 22 is the transaction management unit 21.
The request message 101 is first taken out from each transaction request reception queue of h by the corresponding means, then the required journal information and history information are acquired and the database is updated, and the response message is returned to the transaction management unit 21h and the end processing do. Also, for example, the system software Encina (Transarc)
The OLTP server computer to which the (made by the same company) or Tuxedo (made by Novell) is also adopting the queue type transaction processing method similarly to the above.

The above-mentioned conventional OLTP server computer adopts a method (sequential transaction processing method) of sequentially taking out transaction requests accumulated in a queue and performing transaction processing.

[0004]

The conventional O as described above.
Since the LTP server computer employs a method of sequentially taking out transaction requests accumulated in the queue, transaction processing can be performed only in the order in which the requests are generated, which causes the following problems. (1) The post-processing-good transaction request is pre-processed, and the processing of the necessary transaction request is immediately delayed. (2) In order to perform transaction processing in the priority order of requests, it is necessary to sequentially search transaction requests in a queue with a high priority. (3) For some reason, a transaction request that should be processed promptly but is delayed and has exceeded the processing deadline is also taken out, and it is necessary to perform the error processing. (4) It is necessary to take out sequentially from the queue when transmitting to the server in addition to the request for receiving transaction. (5) When the business application takes out the process from the queue, the transaction request disappears from the queue. Therefore, it is necessary to individually send a plurality of transaction requests to the plurality of business applications from the client. (6) When a plurality of transaction requests can be processed for the first time, it is necessary to monitor the status. (7) When a transaction request including a large amount of information is transmitted from the client, it takes a long time for transmission and the data in the transmitted transaction request cannot be changed. (8) Store / maintain transaction request in queue,
In order to handle it as a kind of database such as obtaining statistical information, it is necessary to describe the process by the access interface for operating data in queue. (9) There is no means for knowing the processing status (whether received by the server, processed from the queue, etc.) on the client side that makes a transaction request.

The problem to be solved by the present invention is to
To ensure the scalability and flexibility of the TP server computer, we provide a method (selection transaction processing method) that increases the degree of freedom of the transaction request data type stored in the queue and the transaction request access stored in the queue To do.

[0006]

In an OLTP server computer according to the present invention, a transaction management unit receives / transmits a transaction request / response from / to a client computer via a communication line, and scheduling and activation management of the transaction process. In order to solve the above problems, the transaction processing unit retrieves the request from the transaction request reception queue of the transaction management unit, acquires the required information, updates the database, and returns the response to end processing. And adopting a selected transaction processing method.

The transaction manager invalidates the transaction requests in the reception queue, or invalidates the processing deadline transaction requests in the reception queue, and rearranges only the valid transaction requests in the ascending order of the processing deadlines, or the queue concerned. There is no data entity when fetching multiple times for one transaction request in the queue, fetching a transaction request in the receive queue under the condition determined by the existence of another transaction request, or fetching for the transaction request in the queue 1st, 2nd which transfers the data referred by the designated pointer or notifies the client side of the event by the designated attribute, and manages the activation of the transaction processing concerned.
3, 4, 5 or 6 means are provided. Alternatively, a queue access unit is provided, a dedicated language for accessing the transaction request in the reception queue is provided, and an interface with a queue access processing unit that operates various separately provided information is provided. Alternatively, a queue for relaying the transaction request group in the reception queue to the other server side is provided.

The transaction processing unit is provided with means for inputting the transaction request group itself as one transaction request to the other server side via the relay queue provided in the transaction management unit.

[0009]

BEST MODE FOR CARRYING OUT THE INVENTION O showing an embodiment of the present invention
As shown in FIG. 1, the LTP server computer is a server computer 2 that receives / transmits transaction request / response messages 101/102 from / to the client computer 1 via a communication line.
Receives / transmits response messages 101/102, schedules the transaction processing, and
The request message 101 including the designated processing time limit information requested by the client computer 1 by the first transaction processing start management means is first analyzed and extracted, and according to the processing time limit information (when there is no designated processing time limit, Handled as indefinite) and rearranged so as to maintain the ascending order of the processing deadlines and inserted at appropriate positions in the queue (above, the alignment steps S11 to S13 in FIG. 2). Next, the transaction processing unit 22 is activated from the first transaction request message 101 of the queue to activate the transaction processing (activation procedure S14 in FIG. 2). The transaction processing unit 22 operates in the same manner as that of the conventional example shown in FIG. It is possible to perform extraction processing in the order of processing deadlines, not limited to the order of arrival of transaction requests.

In order to ensure expandability and flexibility, the OLTP server computer of the above-described embodiment performs transaction processing by increasing the data type of the transaction request stored in the queue and the degree of freedom of the transaction request access stored in the queue. The method (selected transaction processing method) is adopted.

The first transaction processing start management means in the transaction management unit 21 is, for example, as shown in FIG.
As described above, for the new transaction request message 101 received including the designated processing time limit information of 10:10 from the client computer 1, the queue having the stored transaction request message 101 receives 10:00 and 1
It is inserted in a position that keeps the ascending order of the processing deadlines of 0:15 and 10:30. As shown in FIG. 3B, transaction request queues with and without a processing deadline are prepared, and normally, the processing deadline of the first transaction request message 101 starts from the head position of the transaction request queue with a processing deadline. When there is a certain time or more in the transaction request message 1 from the head position of the transaction request queue with no processing deadline,
01 may be provided.

In the embodiment of the invention shown in FIG. 1, the transaction management unit 21 replaces the first transaction process activation management means provided from the first transaction request message 101 of the post-sort queue with sorting as shown in FIG. A second transaction process activation management unit provided from the valid transaction request message 101 in the post queue may be provided and configured as the transaction management unit 21a. Only valid transaction requests can be processed without fetching invalid transaction requests whose processing deadline has passed. As shown in FIG. 4, the second transaction processing activation management means first inserts the request message 101 including the designated processing time limit information into an appropriate position in the queue, as in the sorting steps S11 to S13 of FIG. Next, the transaction processing unit 22 is provided with the transaction request message 101 of the queue whose processing time limit has not expired at that time to start the transaction processing. Further, the transaction request message 10 of the queue whose processing deadline has passed at that time
1 is invalidated and deleted, and an error is returned to the client computer 1 (starting steps S14a to S14c in FIG. 4). For example, as shown in FIG. 5, when there is a retrieval request from the transaction processing unit 22 at 10: 1, the processing deadline is changed from the queue having the stored transaction request message 101 of 10:00, 10:15, and 10:30. Transaction request message 1 with processing deadline of 10:00
01 is invalidated and deleted, the response of the transaction failure is returned to the client computer 1, and the transaction request message 101 at 10:15 is provided to the transaction processing unit 22.

In addition, in the embodiment of the invention shown in FIG. 1, the transaction management unit 21 is replaced with a plurality of transaction processing activation management means using a single transaction request queue for business application, as shown in FIG. A third transaction process activation management unit that uses the transaction request queue for business application may be provided and configured as the transaction management unit 21b. 1 for multiple business applications, not multiple
Only one transaction request can be provided. As shown in FIG. 6, the third transaction process activation management means first receives the request message 101 from the client computer 1 in a transaction request queue shared by a plurality of business applications and stores it (step S21). Next, the head of the queue is searched for the transaction request message 101 to be provided, and the transaction request message 101 is provided to the business application transaction processing unit 22.
At the same time, the provided mark is added for the business application (above steps S22 to S24). Further, when the provision for all business applications is completed, the transaction request message 101 is deleted from the queue (the above steps S25 and S26). For example, as shown in Figure 7,
When a retrieval request is issued from the transaction processing unit 22 for the business application A and then for the B, the queue for the target business application C and the transaction request messages 102 for the target business applications A and B are first transferred to the target business application A. Then, the transaction request message 101 for B is provided and then deleted.

Further, in the embodiment of the invention shown in FIG. 1, the transaction management unit 21 replaces the first transaction process activation management means which uses the transaction request queue with no retrieval condition, instead of the retrieval condition as shown in FIG. A fourth transaction process activation management unit using the attached transaction request queue may be provided and configured as the transaction management unit 21c. It can process a large number of transaction requests by dividing it into business applications or providing them little by little when the data is prepared.
As shown in FIG. 8, the fourth transaction process activation management means first receives the request message 101 from the client computer 1 and stores it in a transaction request queue that specifies another transaction request type as a retrieval condition (step S31). Next, it is checked from the head of the queue whether or not the extraction condition is specified in the transaction request message 101 for business application (step S32). When there is a designation, the search is performed until the other transaction message 101 arrives (the above steps S33 and S34). When there is no designation or when the other transaction message 101 has arrived, it is deleted from the post-provision queue as the business application transaction request message 101 (step S3).
5). For example, assume that there is a queue for storing the transaction request type A message 101 from the client computer 1 as shown in FIG. The relevant request type A message 101 for the order for the first half of the month of the item A is the transaction request type B for the order for the second half of the item A as the extraction condition.
It cannot be retrieved unless the message 101 arrives. At this point, even if there is a retrieval request from the transaction processing unit 22 for the business application, the transaction request type A message 101 is not provided, and is provided only when the transaction request type B message 101 arrives from the client computer 1. The transaction request types A and B messages 101 may be integrated and provided as a new transaction request message 101.

In the embodiment of the invention shown in FIG. 1, the transaction management unit 21 is replaced with a reference pointer as shown in FIG. 10 instead of the first transaction process activation management means using a transaction request queue without a reference pointer. A fifth transaction process activation management unit using the attached transaction request queue may be provided and configured as the transaction management unit 21d. The latest data at the time of transaction processing can be used instead of the transaction request time. As shown in FIG. 10, the fifth transaction process activation management means first receives and stores the request message 101 from the client computer 1 in the transaction request queue designating a reference pointer having no data entity (step S41). Next, it is checked from the head of the queue whether or not the reference pointer is designated in the transaction request message 101 for business application (step S42). If there is a designation, the transfer of the data entity is requested until completion according to the designation method (for example, computer name, file name, etc.) (above step S43).
And S44). When there is no designation or when the data transfer is completed, it is deleted from the post-provision queue as the business application transaction request message 101 in which all the data is complete (step S45). For example, as shown in FIG. 11, it is assumed that there is a queue for storing the transaction request message 101 for registering a new book from the client computer 1 at the head. Request message 101 for new book registration
Does not include the cover image data, and specifies only the reference pointer (file server address P and file name Q).
At this point, if there is a retrieval request from the business application transaction processing unit 22, the address P
Is provided as the transaction request message 101 including the cover image data for transferring the file data of the file name Q from the file server. The data entity is transferred at the time of the fetch request and the request message 101 is not provided at the completion time, and the data transfer is started at the second point of the queue, or the next transaction request message 101 is provided while transferring the data entity. It may be realized by a method.

In addition, in the embodiment of the invention shown in FIG. 1, the transaction management unit 21 replaces the first transaction processing start management means using a transaction request queue without attributes, as shown in FIG. A sixth transaction process activation management unit using a request queue is provided, and the transaction management unit 21
It may be configured as e. The client side can appropriately grasp the transaction request transfer status / retrieval status.
As shown in FIG. 12, the sixth transaction process activation management means first designates an event (for example, "storing in queue", "retrieval from queue") to be notified from the client computer 1 to the client side as an attribute. The request message 101 is received and stored in the request queue (step S51). Next, it is checked from the head of the queue whether or not the attribute of "store in queue" event notification is specified in the transaction request message 101 for the business application, and if specified, the queue storage notification message is sent to the client side. To issue. When there is no designation, if there is a retrieval request from the transaction processing unit 22 for the business application, whether or not the attribute of the “retrieval from queue” event notification is designated in the request message 101 from the head of the queue. Is checked, and if there is a designation, the queue storage notification message is issued to the client side (above steps S52 to S55). If there is no designation or the issue of the queue storage notification message is completed,
The transaction request message 101 for the business application is deleted from the queue after provision (procedure S
56). For example, as shown in FIG. 13, the client computer 1
As an event to be notified from, for example, "store in queue"
Then, it is assumed that there is a queue that stores the transaction request message 101 that specifies “removal from queue” as an attribute. At this point, a "store in queue" notification message is sent to the client side. Subsequently, there is a retrieval request from the transaction processing unit 22 for business application, and at the point of time when the request message 101 is provided, a “retrieval from queue” notification message is transmitted to the client side.

In the embodiment of the invention shown in FIG. 1, the transaction management unit 21 uses, for example, read / search / projection / combination as an information-only access language for the transaction request data in the queue, as shown in FIG. Queue access library provided in the form of a dedicated language such as SQL (Relational Database Query Language) and transaction request data in the queue (for example, train seat request distribution and request date information) are the same as normal database access Access the server computer 2 in the form (remaining without being deleted from the queue even if the transaction request data is taken out).
The transaction management unit 2 is provided with an access-dedicated language interface that provides an interface with the queue access processing unit 23 that operates various information separately provided in a.
It may be configured as 1f. It is possible to develop a queue access processing system for various information operations of information systems that handles queues like a database, in a different dimension from the transaction processing system for core business applications.

In the embodiment of the invention shown in FIG. 1, the server computer 2 has been described as a single server computer. However, when there are, for example, A and B server computers 2 as shown in FIG. The transaction management unit 21g, which separately provides a relay transaction request queue on the side, and the received transaction request message 101 are collectively referred to as the request message 101a via the relay transaction request queue of the transaction management unit 21b.
The transaction processing unit 22a may be configured by separately providing request message inputting means for inputting to the server computer 2 side. It can be transferred as a transaction request for batch submission of the queue itself that already contains multiple transaction requests. The server computers 2 of A and B are shown in FIG.
As shown in 6, transaction management on the B side is performed in batch for the ordering transaction request message 101 of the parts A1, A2, and A3 from the reception queue of the transaction management unit 21g on the A side to the agency A via the relay queue. The transaction processing unit 22 is sequentially provided with the component B1 for the agency B and the components A1, A2, and A3 for the agency A from the reception queue of the unit 21.

[0019]

As described above, the OLTP server computer according to the present invention adopts a method of performing transaction processing by increasing the data type of the transaction request accumulated in the queue and the degree of freedom of access of the transaction request accumulated in the queue. As compared with the method of sequentially fetching the transaction requests accumulated in the queue as described above, the expandability and flexibility can be ensured, and the following effects are obtained for each invention. (1) The extraction processing can be performed in the order of the processing deadline without being limited to the order of arrival of the transaction requests. (2) Only valid transaction requests can be processed without taking out invalidated transaction requests after the processing deadline has passed. (3) 1 for multiple business applications, not multiple
Only one transaction request can be processed. (4) A large number of transaction requests can be processed by dividing the business application and providing it little by little when the data is prepared. (5) The latest data at the time of transaction processing can be used instead of the time of requesting a transaction. (6) The client side can appropriately grasp the transaction request transfer status / retrieval status. (7) It is possible to develop a queue access processing system for various information operations of an information system that handles a queue like a database, in a different dimension from the transaction processing system for core business applications. (8) It can be transferred as a transaction request for batch injection of the queue itself that already includes a plurality of transaction requests.

[Brief description of drawings]

FIG. 1 is a system configuration diagram of an online transaction processing server computer showing an embodiment of the present invention.

FIG. 2 is a flowchart for explaining the function of a first transaction process activation management means in the transaction management unit shown in FIG.

FIG. 3 is a diagram illustrating the function shown in FIG.

FIG. 4 is a flowchart for explaining the function of a second transaction process activation management means in a transaction management unit showing another embodiment of the present invention.

FIG. 5 is a diagram illustrating the function shown in FIG.

FIG. 6 is a flowchart for explaining the function of a third transaction process activation management means in a transaction management unit showing another embodiment of the present invention.

FIG. 7 is a diagram illustrating the function shown in FIG. 6.

FIG. 8 is a flowchart for explaining the function of a fourth transaction process activation management means in the transaction management unit showing another embodiment of the present invention.

9 is a diagram illustrating the function shown in FIG. 8. FIG.

FIG. 10 is a flowchart for explaining the function of the fifth transaction process activation management means in the transaction management unit showing another embodiment of the present invention.

11 is a diagram illustrating the function shown in FIG.

FIG. 12 is a flowchart illustrating the function of sixth transaction process activation management means in the transaction management unit according to another embodiment of the present invention.

FIG. 13 is a diagram illustrating the function shown in FIG. 12.

FIG. 14 is a system configuration diagram showing another embodiment of the present invention.

FIG. 15 is a system configuration diagram showing another embodiment of the present invention.

16 is a diagram for explaining the interrelationship of the server computers shown in FIG.

FIG. 17 is a system configuration diagram of an online transaction processing server computer showing a conventional technique.

[Explanation of symbols]

1 client computer, 2, 2a server computer, 2
1, 21a, 21b, 21c, 21d, 21e, 21
f, 21g Transaction management part, 22, 22a
Transaction processing unit, 23 Queue access processing unit, 101 Transaction request message, 101
a batch submission transaction request message, 102
Transaction response message. In the drawings, the same reference numerals indicate the same or corresponding parts.

Claims (8)

[Claims] 1. A transaction management unit that receives / transmits transaction requests / responses from / to a client computer via a communication line to perform scheduling and activation management of the transaction processing, and a transaction request reception queue of the transaction management unit. In an online transaction processing (OLTP) server computer including a transaction processing unit that retrieves the request, acquires required information, updates the database, and returns the response, and ends the transaction, the transaction management unit requests the transaction in the reception queue. The OLTP is characterized in that the first means for rearranging the transaction processing in the ascending order of the deadline and managing the activation of the transaction processing is provided.
Server calculator. 2. A second means is provided in the transaction management unit for invalidating the processing deadline expired transaction requests in the reception queue, rearranging only valid transaction requests in the order of shorter processing deadline, and managing activation of the transaction processing. O according to claim 1, characterized in that
LTP server computer. 3. The O according to claim 1 or 2, wherein the transaction management unit is provided with a third means for taking out a plurality of transaction requests in the reception queue a plurality of times and managing activation of the transaction processing.
LTP server computer. 4. The transaction management unit is provided with a fourth means for taking out a transaction request in the reception queue under conditions determined by the existence of another transaction request and managing activation of the transaction process. The OLTP server computer described in 1, 2, or 3. 5. The transaction management unit is provided with fifth means for transferring data referred to by a designated pointer having no data entity when fetching a transaction request in the reception queue and controlling activation of the transaction processing. The O according to claim 1, 2, 3 or 4.
LTP server computer. 6. The transaction management unit is provided with a sixth means for notifying an event to the client side with a designated attribute when extracting a transaction request in the reception queue and for controlling the activation of the transaction processing. The OLTP computer according to item 1, 2, 3, 4 or 5. 7. A queue access means for providing a dedicated language for accessing a transaction request in the reception queue in the transaction management unit and providing an interface with a queue access processing unit for manipulating various kinds of separately provided information is provided. Claims 1 and 2, characterized in that
The OLTP server computer described in 3, 4, 5 or 6. 8. The transaction management unit provides a queue for relaying the transaction request group in the reception queue to another server side, and the transaction processing unit uses the transaction request group itself as one transaction request via the queue. 7. A means for inputting to the server side is provided, wherein the means is provided.
Alternatively, the OLTP server computer described in 7.