JPH09319708A - On-line control process substitution system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To increase the transaction processing speed and to attain the effective use of resources by performing no end/restart operation of a transaction control process when a transaction process stays and also using an unused transaction control process. SOLUTION: When a dummy area 3 is clear, the transaction information to be carried out is written together with the information on the working DB (data bases) 6. Thus, even a relevant transaction group 2 can access the DB 6 in the corresponding transaction. As a result, the transaction stayed in the group 2 waiting for its processing can be carried out. The execution request of the transaction stayed in the group 2 is notified to a main process 1 which completes its processing. Then a load monitor means 8 is restarted after a fixed time to monitor the stayed transaction in an on-line operation mode. Thus, an on-line control process substitution processing operation is completed.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an online system, and more particularly to a control method for dynamically changing the processing capacity of the online system when the transaction load of the online system fluctuates to cope with the load fluctuation.

[0002]

2. Description of the Related Art As a conventional online data processing system of this type, for example, Japanese Patent Laid-Open No. 2-3644 discloses a system.
The transaction transaction time is guaranteed by keeping track of the waiting transaction amount for each process and by allocating the CPU preferentially to the process whose transaction amount is a certain value or more. A system that aims to improve the utilization efficiency of is proposed. In this conventional method, C at the time of transaction processing is used to improve the efficiency of processing for a transaction group with a large amount of transactions.
This is handled by increasing or decreasing the PU allocation amount.

[0003]

However, the above-mentioned conventional method has a problem that there is a case where the processing speed cannot be increased only by increasing or decreasing the CPU allocation amount.

The reason for this is that even if the CPU allocation amount is changed according to the above-mentioned conventional method, the execution priority of the process only increases, and the processing is performed serially (sequentially). Therefore, when executing a transaction that occupies the process even while waiting for the conversation with the terminal, C to the processing process
There may be a case where the PU allocation increase has little advantage. In this case, efficiency cannot be improved unless the number of processes is increased and parallel processing is performed.

Although this problem can be dealt with by increasing the number of processes, since the resources for starting the process and the process starting process are involved, the resources are secured and the process is started at that time. There is a problem that it takes time and effort.

Therefore, the present invention has been made in view of the above circumstances, and an object thereof is to perform unused transaction control without terminating / restarting the transaction control process when the transaction processing stays. The purpose of the present invention is to provide a control method for achieving efficient use of resources by performing transaction processing using a process, while achieving high-speed processing.

[0007]

In order to achieve the above object, the present invention groups transactions into a plurality of groups according to their types and / or characteristics, and the groups are in a process for transaction processing. Includes a process that holds a writable dummy area, and also stores and holds management information in group units and transaction units in a table, and the group in which transactions are retained during operation and the transaction input amount are small. When a group including an empty process is detected at the same time, the information of the staying transaction is transferred from the table to the dummy area of the empty process, and the transaction is executed on behalf of the process. Providing an online control process proxy method characterized by controlling That.

The present invention preferably comprises main means for managing the entire online system and a plurality of transaction groups divided according to the characteristics of the transactions, wherein the transaction groups are grouped into a specific processing unit and the corresponding transaction is grouped. It includes a transaction control process group that holds a dummy area for processing transactions other than the group, a process waiting queue that accepts transaction requests to the relevant transaction group and saves until execution, and a database group used in the transaction. In addition, the transaction group information held by the online system and the transaction name, execution format, and transaction input amount information and usage of all transactions operating under it A transaction information table that also has DB information, a load monitoring unit that manages the load status of all transaction groups in fixed time units, the load monitoring unit retains transactions in the transaction processing wait queue, and waits for a transaction And a transaction group having a certain transaction group at the same time, the transaction transfer means for transferring the information of the staying transaction from the transaction information table to the dummy area of the empty process and notifying the main means of the transaction execution request,
In addition, the existing transaction control process is used to execute the staying transaction without terminating / restarting the transaction control process.

The outline of the present invention will be described below. In a large-scale online system, transactions are managed by dividing them into multiple processing units according to the type and characteristics of transactions and the usage environment of a database, etc. Transaction processing is performed by one or more control processes in each group. There is. At that time, in the conventional method, each control process can execute only the transactions of its own group, and unless a proper number of control processes are allocated to the transaction group according to the transaction input amount, the transactions cannot be processed and the retention occurs. Or, since there is almost no transaction input, an excessive control process is allocated, resulting in a decrease in processing efficiency. On the other hand, according to the present invention, when the load monitoring unit simultaneously detects the retention of transactions in the transaction processing waiting queue and the transaction group having an empty process in the transaction input waiting state, the dummy area of the empty process is set. To effectively use resources by transferring the information of the transaction that is staying, submitting the transaction, and using the existing unused transaction control process to execute the transaction that is staying It is the one.

[0010]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below in detail with reference to the drawings.

FIG. 1 is a diagram for explaining the overall configuration of a system according to an embodiment of the present invention.

Referring to FIG. 1, an online system according to an embodiment of the present invention holds main means 1 for managing the entire system, a plurality of transaction groups 2 divided by transaction characteristics, and an online system. Transaction group information and transaction information table 7 that holds transaction name, execution format, transaction input amount information, and used database information of all transactions that operate under it, and the load of all transaction groups in fixed time units The load monitoring unit 8 that manages the situation and the load monitoring unit 8 simultaneously execute the transaction stay in the transaction processing waiting queue 5 and the transaction group in which there is an empty process waiting for the input of a transaction. When detected, the transaction transfer means 9 transfers the information of the staying transaction from the transaction information table 7 to the dummy area 3 of the empty process and notifies the main means 1 of the transaction execution request. It

Each transaction group 2 receives a transaction control process group 4 which holds a dummy area 3 for processing transactions other than the relevant transaction group and which is grouped into a specific processing unit, and a transaction request to the relevant transaction group, It has a process queue 5 for storing until execution and a database (DB) group 6 used for transactions.

That is, transaction group 2
Is a transaction control process group 4 divided into transaction units having common points such as processing relations in terms of management, and the process processes 4 assigned to the transaction group 2 are executed in the corresponding transaction group 2. It has information on possible transaction execution formats, and a writable dummy area 3 even during online operation.

In the online transaction processing system, the main means 1 distributes a transaction processing request input from a terminal to a corresponding transaction group 2 according to the transaction type, and a process waiting queue 5 of the transaction group 2 of the distribution destination.
By queuing to the queue, functional means for performing transaction processing is provided, and while online processing is being executed, the functional means for activating the load monitoring means 8 at fixed time intervals and the functional means for reading and writing each table are combined.

Further, the dummy area 3 is an area allocated to each transaction control process 4, and is allocated a size corresponding to the maximum required size of the transaction operating in the online system according to this embodiment. Although the normal transaction control process 4 area cannot be written, only the dummy area 3 is processed by the transaction transfer means 9 in the transaction information table 7.
Can transfer an executable transaction program from. After writing to the dummy area 3, this area is treated like any other transaction execution format, a transaction can be input using this area, and the information is retained until it is overwritten next.

FIG. 2 shows the transaction information table 7.
FIG. 3 is a diagram showing an example of the configuration of FIG.

The transaction information table 7 stores (1) TX group storage area as information of all transaction groups 2 of the relevant online system.
Transaction group name, (2) Processing queue T
The number of transactions waiting to be processed in the X number storage area, (3) the current transaction input amount that is updated each time a transaction is input to the transaction group in the current TX input amount storage area, and (4) the load in the previous TX input amount storage area. It is provided with each information of the previous transaction input amount that is updated each time the monitoring means 8 is activated and is used for comparison with the current transaction input amount.

Further, all transactions that can be executed under the transaction group 2 are performed for each transaction (for example, TXA1 to TXA1 for TX group A).
For each TXAn), (1) transaction name in the TX name storage area, (2) information in the TX execution format storage area, which is of the same type as the execution format allocated by linking to the transaction control process 4, (3) database used Information of a required database (DB) 6 is also held in the information storage area.

Further, the processing retention upper limit storage area is provided with processing retention upper limit information for judging transaction retention, and also has an activation interval time of the load load monitoring means 8.

The load monitoring means 8 is
It always operates at fixed time intervals (can be set by the system administrator) and monitors the retention of transactions in each transaction group 2. When the transaction group 2 in which the transaction retention amount is equal to or more than the upper limit value set in the transaction information table 7 and the transaction group in which no transaction has been executed since the last time the load monitoring unit 8 was started are detected at the same time. , The transaction transfer means 9 is started.

The transaction transfer means 9 is activated by the load monitoring means 8 and receives from the transaction information table 7 the information on the execution format of the transaction that is staying in the processing queue 5, and the transaction transaction means 9 is an empty transaction of the transaction group 2 that is not processed. Control process 4
The required database (DB)
6 access to the main means 1,
By notifying the transaction execution request, the transaction can be executed and the transaction processing is performed.

FIG. 3 is a flow chart for explaining the processing operation of the load monitoring means 8. FIG.
7 is a flowchart for explaining the processing operation of the transaction transfer means 9.

Next, the operation of the embodiment of the present invention will be described.

When creating the transaction execution format,
The execution format image is registered in the transaction information table 7, and the maximum size information of the transaction execution format is registered.

When building an online system, a transaction is linked to the transaction control process 4.
At this time, the dummy area 3 is added to each transaction group 2 in the size of the maximum value of the transaction execution format registered in the transaction information table 7, for example. Further, the activation cycle time of the load monitoring means 8 of the transaction information table 7 and the retained transaction upper limit value of the transaction processing waiting queue 5 used for determining that the transaction is retained are set. This completes the construction of the online system.

Next, the online system is started up. This is no different from starting an ordinary online system.

After the start-up process is completed, the main means 1 initializes (clears) the dummy areas 3 of all the transaction groups 2, activates the load monitoring means 8, and starts the online service. After that, the load monitoring unit 8 is activated at regular time intervals until the online service ends.

The load monitoring means 8 uses the information in the transaction information table 7 at regular time intervals set by the system administrator, for example, to determine the status of transaction input to all transaction groups 2 in the online system, and the waiting queue 5 for processing. Monitor the stay status.

Referring to the flow chart of FIG. 3, first, the number of transactions accumulated in the transaction processing waiting queue 5 (the number of transactions accumulated in the processing waiting queue 5) is
It is checked whether or not there is a transaction group 2 having a preset upper limit value (set by the system administrator) or more (step 3-1).

If there is no transaction group in which the transaction retention number in the processing queue 5 exceeds the upper limit value (that is, NO branch in step 3-1 and there is no next transaction group in step 3-2), all transaction groups 2 are processed. The current transaction input amount in the transaction information table 7 is transferred to the previous transaction input amount table, and the load monitoring means 8 finishes the current processing (step 3-7).

On the other hand, when the transaction processing waiting queue 5 exceeds the upper limit value in step 3-1 and there is a transaction group 2 in which processing is retained, the transaction information table 7 is checked (step 3-3),
The transaction processing waiting queue 5 is empty, and the previous transaction input amount and the current transaction input amount are the same (previous TX input amount = current TX input amount) in the transaction group 2 (that is, the previous load monitoring unit 8).
From the check point of (1), there is no transaction input all the time, and it is checked whether there is an unused transaction control process 4) (step 3-4).

If there is no corresponding transaction group 2, the processing of step 3-7 is executed, and the current transaction input amount (current TX) in the transaction information table 7 of all transaction groups 2 is executed.
The contents of the input amount storage area) are transferred to the previous transaction input amount storage area, and the load monitoring means 8 finishes the processing of this time.

In the processing of steps 3-3 and 3-4, when the staying transaction group 2 and the transaction group 2'having no transaction to be executed are detected at the same time (YE of step 3-4).
S), The transaction transfer means 9 is started and a process is requested (step 3-6).

Then, returning to step 3-2, if there is still a transaction group whose transaction should be checked in the transaction information table 7, the next transaction group 2
As for the above, the number of stays in the processing queue in step 3-1 is checked again. Transaction information table 7
After the completion of checking all the transaction groups 2 of the above, the processing of step 3-9 is performed, the current transaction input amount of the transaction information table 7 of all the transaction groups 2 is transferred to the previous transaction input amount table, and the load monitoring means 8 is executed. Ends this process.

When the transaction transfer means 9 is activated, first, the first transaction is fetched from the corresponding process waiting queue 5 (step 4-1), and information on the fetched transaction is searched from the transaction information table 7 (step 4-). 2).

Next, it is checked whether or not the retrieved transaction information is already written in the dummy area 3 of the transaction control process 4 of the transaction group 2 waiting for processing (step 4-3). (See YES branch of step 4-3)
Proceeding to step 4-9, the transaction processing is performed as it is.

In step 4-3, if the corresponding transaction information has not been written (step 4)
-3 NO branch), it is checked whether another transaction information is written (step 4-4), and if another transaction processing information is written,
The previously written transaction information is cleared, the used database 6 information is released, and the dummy area 3 is cleared (steps 4-5 and 4-6).

If the dummy area 3 is in the clear state, the transaction information to be executed and the information in the usage DB 6 are written (step 4-7). The usage DB 6 of the transaction is made accessible from the transaction group 2 (step 4-8).

With this, it becomes possible to execute the transaction staying in the transaction group 2 which has been in the process waiting state, the execution request of the transaction staying in the transaction group is notified to the main process 1, and the process ends. (Step 4-9).

Then, the load monitoring means 8 is restarted after a fixed time, and the staying transaction can be monitored during the online operation. This completes the operation of the online control process proxy processing.

[0042]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below with reference to the drawings in order to explain the embodiment of the present invention described above based on a more specific example. As an embodiment of the present invention, an online transaction system that manages ordering / stocking of merchandise and personnel in a trading company will be described as an example.

Referring to FIG. 8, in this embodiment, the online system has three parts: order management, merchandise management and personnel management.
Each of the transactions has two components: inventory collation for order management, order processing, goods management, warehousing report, replenishment request, and personnel management for employee search and employee registration.

FIG. 5 shows an example of the transaction information table 7 immediately after the system configuration (before starting).

With reference to FIG. 5, the required size of the transaction link of each execution form of inventory inquiry, order processing, warehousing report, replenishment request, employee search, and employee registration is 200, 300, 500, 400, 350, respectively. Since it is 450, the size of the dummy area 3 of each transaction group 2 is 500, which is the maximum value.

Further, the activation interval of the load monitoring means 8 is designated as 60 seconds. The pending queue 5 has a setting of 10 accumulated transaction upper limit values.
The load monitoring means 8 is activated every 60 seconds until the online service ends, and monitors the transaction input status and the retention status of the processing queue 5.

The transaction information table 7 is shown in FIG.
When the load monitoring means 8 is activated at the timing of the state (in operation 1) as shown in, waiting for processing of order management, product management, and personnel management is 1, 9 and 5 respectively, and 10 or more processing waits. No, so step 3 in the flow chart of FIG.
When the determination is 2, the process branches to step 3-7, the current transaction input amount of all the transaction information tables 7 is transferred to the previous transaction input amount table, and the load monitoring unit 8 finishes the current process.

At the next activation of the load monitoring means 8, if the state of the transaction information table 7 is as shown in FIG. 7,
Since there are 10 transactions waiting for product management, the process branches to step 3-3 in the determination of step 3-1 in the flowchart of FIG.

In order management, the value is different in the comparison between the previous transaction input amount and the current transaction input amount in step 3-4, so the transaction transfer means 9
Does not start.

The waiting queue for personnel management is step 3-
3. At step 3-4, the process branches to step 3-6, and the transaction transfer means 9 is activated to request processing. After that, the load monitoring means 8 once finishes the process by operating in the order of step 3-2 and step 3-7.

With the above, the processing of the load monitoring means 8 which is the operation of the first embodiment of the present invention is completed.

Next, the transaction transfer means 9 is shown in FIG.
This will be described with reference to the flowchart of FIG. First, the leading transaction is taken out from the corresponding processing queue 5, and the information is retrieved from the transaction information table 7 (herein, a receipt report).

It is checked whether the found receipt report information has already been written in the dummy area 3 of the transaction control process 4 of the personnel management transaction group 2.

At first, since the dummy area 3 is initialized, by the judgment processing of steps 4-3 and 4-4,
In steps 4-7 and 4-8, transfer of the receipt report transaction and allocation of the receipt DB are performed. In step 4-9, the main means 1 is requested to perform transaction processing, and the receipt report transaction, which should originally operate only for product management, operates in the personnel management transaction group. An overall view at this time is shown in FIG.

As described above, the transaction transfer means 9
Processing is completed.

During the online operation, a normal transaction is input again, and the next load monitoring means 8 performs a check to enable efficient process allocation.

[0057]

As described above, according to the present invention,
Even if the increase / decrease of the CPU allocation amount cannot increase the processing speed, the processing speed can be increased.

The reason for this is that in the conventional control method of the CPU allocation amount, even if the CPU allocation efficiency is changed, the execution priority of the process is only increased and the processing is serially executed. Although there is no advantage in executing a transaction that occupies a process even while waiting for the conversation response, the method of the present invention can increase the number of processes and perform parallel processing.

Further, in this case, in the present invention, since the resources already secured are used, there is an effect that new resources are secured and the process startup is not required, and the system performance is improved.

[Brief description of drawings]

FIG. 1 is a diagram showing an overall configuration of an embodiment of the present invention.

FIG. 2 is a diagram showing a structure of a transaction information table 7 according to the embodiment of the present invention.

FIG. 3 is a flowchart for explaining the operation of the load monitoring means 8 in the embodiment of the present invention.

FIG. 4 is a flowchart for explaining the operation of the transaction transfer means 9 in the embodiment of the present invention.

FIG. 5 is a diagram for explaining the embodiment of the present invention and is a diagram showing an example when the transaction information table 7 is started up.

FIG. 6 is a diagram for explaining the embodiment of the present invention, and is a diagram showing an example of the transaction information table 7 in operation.

FIG. 7 is a diagram for explaining the embodiment of the present invention and is a diagram showing a second example of the transaction information table 7 in operation.

FIG. 8 is a diagram for explaining the embodiment of the present invention and is a diagram showing an operation example during operation of the entire online system.

FIG. 9 is a diagram for explaining the embodiment of the present invention and is a diagram showing an operation example during operation of the entire online system.

[Explanation of symbols]

 1 Main Means 2 Transaction Group 3 Dummy Area 4 Control Process Group 5 Processing Queue 6 Used DB Group 7 Transaction Information Table 8 Load Monitoring Means 9 Transaction Transfer Means

Claims (2)

[Claims] 1. A transaction is grouped into a plurality of groups according to its type and / or characteristic, and the group includes a process for processing a transaction and holding a writable dummy area, When the management information for each group and each transaction is stored and retained in the table, and the group in which transactions are retained and the group that contains a small amount of transactions and includes an empty process are detected at the same time during operation, An online control process proxy method characterized in that information on a staying transaction is transferred from the table to a dummy area of an empty process, and the process is controlled so that the transaction is executed on behalf of the process. 2. A main means for managing the entire online system, and a plurality of transaction groups divided according to transaction characteristics, wherein the transaction groups are grouped into a specific processing unit, and transactions other than the transaction group. Transaction control process group that holds a dummy area for processing, transaction waiting queue that accepts transaction requests to the relevant transaction group and saves until execution, and database group that is used in the transaction. Furthermore, online system Information of the transaction group held by and the transaction name, execution format, transaction input amount information and used database information of all transactions operating under it. There is a transaction information table that also has information, a load monitoring unit that manages the load status of all transaction groups in fixed time units, the load monitoring unit retains transactions in the transaction processing waiting queue, and there are free processes waiting for transaction input. And a transaction transfer means for transferring the information of the staying transaction from the transaction information table to the dummy area of the empty process and notifying the main means of the transaction execution request when the transaction group and the transaction group are detected at the same time. , The transaction control process is terminated / restarted, and the existing unused transaction control process is used to execute the staying transaction. Online control process substitution method.