JP2002342269A - Method for optimizing number of resource management table, system conducting the same and processing program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a technology for reducing the estimation man-hours of the upper limit value of resource management table at system designing, and improving memory utilization efficiency without having any adverse influence on the performance of on-line transaction processing. SOLUTION: This method for optimizing the number of resource management table for optimizing the number of entry of the resource management table for managing resources to be used for on-line transaction processing comprises a step for monitoring the entry usage state of the resource management table with a prescribed interval during the on-line transaction processing and for instructing increase in the upper limit value of the resource management table, when the number of entry in use exceeds a prescribed estimated value, and a step for extending the entry of the resource management table, when the increase of the upper limit value of the resource management table is instructed.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an online transaction processing system for managing various resources used in online transaction processing with a resource management table, and more particularly to an online transaction system in which upper limits of various resources used in online transaction processing are specified in advance by parameters. The present invention relates to a technology that is effective when applied to a transaction processing system.

[0002]

2. Description of the Related Art Conventionally, in an online transaction processing system, the maximum values of the maximum number of transactions, the number of user application programs, the number of terminals, and the like during online are estimated at the time of system design, and the estimation result is used as a parameter of the online transaction processing system. Define and create the resource management table according to this parameter at the time of start by securing the specified number of memory. As a result, when executing the online transaction processing, there is no shortage of memory due to the creation of the resource management table, and there is no overhead, so that reliability and performance are ensured.

[0003] Even if the size of the resource management table exceeds the limit determined by the size of the storage device, the area of the management table is secured to the full extent of this limit by automatically reflecting the user's setting value in consideration of the user's set value. Japanese Patent Application Laid-Open No. Hei 9-167115 discloses an efficient resource management table extension method that does not require a lot of time and effort for construction work without waste of storage area.

[0004]

In the above prior art, it is necessary to estimate an upper limit at the time of system design. At that time, the maximum number of transactions online, the number of user application programs, the number of terminals, etc. are uncertain. There are some users, and there is also a user who wants to easily execute without estimating the reliability and performance of the development machine without particular importance. Further, if there is a plan to expand the system scale and the number of users in the future, some users will greatly increase the numerical value, and there is a problem that memory is wasted for the time being.

SUMMARY OF THE INVENTION An object of the present invention is to solve the above problem, reduce the number of steps for estimating the upper limit value of the resource management table at the time of system design, and improve the memory use efficiency without affecting the performance of online transaction processing. It is to provide various technologies.

[0006]

According to the present invention, there is provided an online transaction processing system for optimizing the number of entries in a resource management table for managing resources used in online transaction processing. When the threshold value is exceeded, the entry of the resource management table is extended.

In the online transaction processing system of the present invention, a resource management table is created by setting an upper limit by default at the start of the online transaction processing, and the entry of the resource management table is used at a predetermined interval during the online transaction processing. Monitor the situation.

As a result of the monitoring, if the number of entries in use exceeds a predetermined threshold value, an instruction to increase the upper limit of the resource management table is issued, and the entries of the resource management table are expanded.

If the number of in-use entries does not exceed a predetermined threshold, the number of in-use entries predicted after the next interval is calculated from the number of in-use entries in the previous time and the number of in-use entries this time. A predicted value is calculated, and when the predicted value exceeds the upper limit value of the resource management table, the next interval value is reduced to shorten the monitoring interval.

As described above, according to the online transaction processing system of the present invention, when the number of in-use entries in the resource management table exceeds the discrimination value, the entries in the resource management table are expanded. It is possible to reduce the number of steps for estimating the upper limit value of the table and improve the memory use efficiency without affecting the performance of online transaction processing.

[0011]

DESCRIPTION OF THE PREFERRED EMBODIMENTS An online transaction processing system according to an embodiment for optimizing the number of entries in a resource management table for managing resources used in online transaction processing will be described below.

FIG. 1 is a diagram showing the overall configuration of an online transaction processing system 102 according to this embodiment.
As shown in FIG. 1, the online transaction processing system 102 of the present embodiment includes a transaction processing unit 10
4, a table initial creation processing unit 105, a use status monitoring processing unit 106, and a table reconstruction processing unit 107.

The transaction processing unit 104 is a processing unit that performs transaction processing of a bank online system or the like online. Table initial creation processing unit 105
Is a processing unit that secures an entry of the resource management table 108 that is smaller than the upper limit by default when the online system starts, and initializes the table.

The usage monitoring processor 106 monitors the usage of entries in the resource management table 108 at predetermined intervals during online transaction processing.
This is a processing unit that instructs expansion of the upper limit of the resource management table 108 when the number of entries in use exceeds a predetermined determination value. The table reconfiguration processing unit 107 is a processing unit that expands an entry in the resource management table 108 when an instruction to increase the upper limit value of the resource management table 108 is issued.

A program for causing the online transaction processing system 102 to function as the transaction processing unit 104, the table initial creation processing unit 105, the use status monitoring processing unit 106, and the table reconstruction processing unit 107 is stored in a recording medium such as a CD-ROM. After being recorded and stored on a magnetic disk or the like, it is assumed that the program is loaded into a memory and executed. The recording medium for recording the program may be a recording medium other than the CD-ROM. The program may be installed from the recording medium to the information processing apparatus and used, or the recording medium may be accessed through a network to use the program.

The online transaction processing system 102 according to the present embodiment receives an input of a transaction such as depositing and withdrawing cash from a terminal 101 such as an automatic teller machine of a bank online system, and the transaction processing unit 104 performs transaction processing. Execute and output the result to the terminal 101.

In the transaction processing unit 104, a resource management table 108 for managing resources such as the file of the terminal 101 used in the transaction is required on the memory 103. In the resource management table 108, it is necessary to have entries for the number of concurrently executing transactions, and the number of entries is conventionally estimated by a user at the time of system design, and the estimation result is defined as a parameter and given as an upper limit. .

In this embodiment, first, when the online transaction processing system 102 is started, the resource management table 108 is created in the memory 103 with the default number n of entries (a value smaller than the upper limit) set by the system. It is assumed that the default number of entries can be specified by a user with a parameter so that tuning can be performed according to the system scale of the user.

The resource management table 108 includes a next table address section 109 for setting the address of the next table which is incremented at the time of table reconstruction described later, an entry number section 110 for managing the number of entries in the resource management table 108, and a transaction. Entry part 1 to be managed
12, an in-use entry number section 111 for managing the number of used entry sections 112.

When the start processing of the online transaction processing system 102 is completed and the online state is established,
You will be able to enter transactions. After the online state, the usage status monitoring processing unit 106 controls the resource management table 108 used by the transaction processing unit 104.
Is monitored at a default interval set by the system, for example, at a predetermined time interval such as several tens of seconds. The interval value can be specified by a parameter so that the user can tune to a value such as several seconds or tens of seconds.

The usage status monitoring processing unit 106 performs a process of predicting the usage amount at the next interval from the usage amount at the previous interval and the usage amount at the current interval,
Also, the number-of-entries part 11 of the resource management table 108
The system sets whether the resource management table 108 is newly secured or created when the number of remaining resources becomes 0 (hereinafter referred to as a discrimination value). If the current usage exceeds the discrimination value, the resource A table reconfiguration processing unit 107 that newly allocates and creates a management table 108
Contact It is assumed that the determination value can also be specified by a parameter so that the user can tune to a value such as 130 entries or 190 entries.

The table reconstruction processing unit 107 has a memory 1
03, a new area of the resource management table 108 is secured by the default entry increment number set by the system, this value is set in the entry number section 110, and the next table address section of the resource management table 108 created first. 109 shows the resource management table 10 created this time
8 is set. It should be noted that the number of entry increments can be specified by parameters so that the user can tune the value of 60 entries or the like.

Further, in the present embodiment, if the current usage does not reach the threshold value for performing the entry increment, but the predicted value at the next interval exceeds the upper limit, the next interval value is shortened from this time. In order to improve the monitoring sensitivity. In this way, by increasing the sensitivity of monitoring and increasing the number of entries in advance before reaching the upper limit,
This prevents performance degradation during execution of the transaction processing unit 104. However, when the upper limit is reached at a speed exceeding the prediction, the transaction processing unit 104 directly communicates with the table reconstruction processing unit 107 to perform the entry increment. In this case, the performance is deteriorated only by the processing of the entry increment. By tuning the various default values set in the above-described system according to the characteristics of the user system, the frequency of entry increments at the time of executing transaction processing can be reduced.

FIG. 2 shows a usage status monitoring processor 1 according to this embodiment.
It is a flowchart which shows the processing procedure of 06. First, in step 201, the usage monitoring processing unit 106 reads the value in the used entry number unit 111 of the resource management table 108 and saves the value as the current usage.

In step 202, the interval value is set to t
, The execution of the next process is delayed for t seconds. After t seconds, the process proceeds to step 203, and step 201
Is used as the previous usage amount, and the value in the used entry number section 111 of the resource management table 108 is read and saved as the current usage amount.

In step 204, it is checked whether or not the saved current use amount exceeds a preset judgment value. If it exceeds, the process proceeds to step 205. In step 205, the table reconfiguration processing is called to increase the upper limit value of the resource management table 108.

If it is determined in step 204 that the determination value does not exceed the limit value, or if the expansion of the upper limit value of the resource management table 108 is completed, the process proceeds to step 206, and
Then, a predicted value after t seconds of the in-use entry number section 111 of the resource management table 108 is obtained. This calculation method will be described later.

Next, at step 207, it is checked whether or not the calculated predicted value exceeds the upper limit.
If the predicted value exceeds the upper limit, the process proceeds to step 208, and if not, the process proceeds to step 21.
Go to 0.

In step 208, the next interval value t 'is obtained. This calculation method will be described later. In step 209, after performing the delay for the calculated t 'seconds, the process returns to step 203. On the other hand, in step 210, after performing a delay of t seconds, the process returns to step 203.

FIG. 3 shows a usage monitoring processing unit 1 according to this embodiment.
It is a figure which shows the relationship between a used amount, a predicted value, and a monitoring interval about the case where the present used amount in 06 did not exceed the determination value. In FIG. 3, the horizontal axis represents time, and the vertical axis represents usage. The upper limit is 200, and the final value is 130.
The monitoring interval value set by the system is t seconds.

The usage status monitoring processing unit 106 of the present embodiment
Is the current usage amount 30 seconds after the first interval value t seconds.
Is saved only, and prediction after t seconds is not made (301).
After that, if a delay of t seconds is performed, the next monitoring time is 2
t. In 2t, the used amount 90 is saved as the current used amount.

Here, the usage status monitoring processing unit 106 estimates the usage amount after the next t seconds from the previous current usage amount 30 and the current usage amount 90 from the following equation (1). In the present embodiment, when the usage of the resource management table 108 increases, this equation is used as an increase with the characteristic shown in Expression 1, but another prediction equation may be used.

[0033]

## EQU00001 ## Next use amount = current use amount.times. (Current use amount / previous use amount).

Next, since the calculated predicted value 270 exceeds the upper limit value 200, the usage status monitoring processing unit 106 changes the next interval value. For the next interval value, the elapsed time T1 from the current time to the time when the upper limit value is exceeded is predicted, and set to a half time T2. It is calculated from the following equation.

[0035]

T1 = t × (b / a)

[0036]

T2 = T1 / 2 Therefore, the next monitoring time is 2t + T2 after T2. Here, as shown in FIG. 3, a in Equation 2 is the difference between the predicted value 270 and the current usage 90, and b in Equation 2 is the difference between the upper limit 200 and the current usage 90.

Next, as shown in FIG. 3, assuming that the usage amount is 100 at the time 2t + T2, the usage status monitoring processing unit 106
Predicts the usage amount after the next t seconds from the previous current usage amount of 90 and the current usage amount of 100. Here, since the interval value is shortened from t to T2, the predicted value after the next t seconds is represented by the following Expression 4.

[0038]

## EQU4 ## Next use amount = current use amount × (current use amount / previous use amount) ^{t / T} where T is an interval value from the previous time to the current time. At time 2t + T2, T becomes T2. Here, when t is set to 100, the predicted value is 141 from Equation 4 (303). Since the calculated predicted value 141 is smaller than the upper limit 200, the usage status monitoring processing unit 106 sets the next interval value to t again. Therefore, the next monitoring time is 3t + T2 after t seconds.

As shown in FIG. 3, at 3t + T2, the used amount is 100.
, The predicted value becomes 100 from Equation 1 (304). Since the calculated predicted value 100 falls below the upper limit 200, the usage status monitoring processing unit 106 sets the next interval value to t again. Therefore, the next monitoring time is 4t + T2 after t seconds. Assuming that the usage amount is 50 at 4t + T2 as shown in FIG.
It becomes 5 (305).

FIG. 4 is a diagram showing the usage monitoring processing unit 1 according to the present embodiment.
It is a figure which shows the relationship between a used amount, a predicted value, and a monitoring interval about the case where the current used amount in 06 exceeded the determination value. In FIG. 4, the horizontal axis represents time, and the vertical axis represents usage. The upper limit value is 200, and the determination value is (upper limit value -70), which is 130. The interval value set by the system is t seconds.

In FIG. 4, up to the monitoring time 2t, 302 in FIG.
(401).

As shown in FIG. 4, the amount of use is 115 at 2t + T2.
, The predicted value is 258 from Equation 4 (402). In this case, since the predicted value exceeds the upper limit 200, the usage status monitoring processing unit 106 further changes the next interval value. For the next interval value, the elapsed time T3 from the current time to the time exceeding the upper limit value is predicted, and is set to a half time T4. It is calculated from the following equation.

[0043]

T3 = t × (d / c)

[0044]

T4 = T3 / 2 Therefore, the next monitoring time is 2t + T2 + T4 after T4. Here, as shown in FIG.
8 is the difference between the current usage amount 115, and d in Equation 5 is the difference between the upper limit 200 and the current usage amount 115.

Next, as shown in FIG. 4, if the usage amount is 138 at time 2t + T2 + T4, in this case, the usage amount is 1
Since 38 exceeds the determination value 130, the usage status monitoring processing unit 106 calls the table reconfiguration processing to increase the upper limit value. If the enlargement range of the upper limit is 60, the new upper limit is 260. Accordingly, the determination value is also changed to 190.

Calculating the predicted value according to Equation 4 gives 255
(403). As a result, since the predicted value does not exceed the upper limit value 260, the usage status monitoring processing unit 106 returns the next interval value to t. Therefore, the next monitoring time is t
After 3 seconds, it is 3t + T2 + T4. 3t + T2 as shown in FIG.
Assuming that the used amount is 115 at + T4, the predicted value becomes 95 according to Equation 1 (404).

FIG. 5 is a flowchart showing the processing procedure of the table reconstruction processing unit 107 of this embodiment. As shown in FIG. 5, when the instruction to increase the upper limit of the resource management table 108 is issued from the usage status monitoring processing unit 106, the table reconfiguration processing unit 107
8 is extended.

In step 501 of FIG. 5, the table reconfiguration processing unit 107 reads out the expansion width of the resource management table 108 set in advance as a parameter of the online transaction processing system, and proceeds to step 502.

In step 502, an area of the resource management table having the entry indicated by the read enlarged width is secured, and in step 503, the value of the head address of the secured area is replaced with the value of the original resource management table 108.
Is set in the next table address section 109 of the table. When the transaction processing unit 104 of this embodiment uses up to the last entry n of the resource management table 108, the transaction processing unit 104 reads the value of the next table address unit 109, accesses the reserved area, and executes the extended resource management table. Shall be used.

In step 504, the value of the enlarged width for which the area has been secured is added to the upper limit value of the resource management table 108 to update the upper limit value. Step 505
Then, the value of the enlargement width for which the area has been secured is added to the determination value in the resource management table 108, and the value of the determination value is updated.

As described above, according to the present embodiment, even if the user starts the online transaction processing system without estimating the upper limit, the upper limit is automatically set by default at the start, and the resource is set. A management table is created and its usage is monitored at predetermined intervals set by the system without interlocking with the transaction processing, the upper limit is exceeded, and the number of entries can be increased at an appropriate timing. In the case where there is a plan to expand the system scale or the number of users in the future by reducing the estimation load of the upper limit value at the time of system design according to be able to.

As described above, according to the online transaction processing system of the present embodiment, when the number of in-use entries in the resource management table exceeds the discrimination value, the entries in the resource management table are expanded. It is possible to reduce the man-hour for estimating the upper limit value of the resource management table and improve the memory use efficiency without affecting the performance of online transaction processing.

[0053]

According to the present invention, the number of entries in the resource management table is extended when the number of in-use entries in the resource management table exceeds the discrimination value. It is possible to reduce and improve the memory use efficiency without affecting the performance of online transaction processing.

[Brief description of the drawings]

FIG. 1 is a diagram illustrating an overall configuration of an online transaction processing system according to an embodiment.

FIG. 2 is a flowchart illustrating a processing procedure of a usage status monitoring processing unit 106 according to the embodiment.

FIG. 3 is a diagram illustrating a relationship between a usage amount, a predicted value, and a monitoring interval in a case where a current usage amount does not exceed an evaluation value in a usage status monitoring processing unit 106 according to the present embodiment.

FIG. 4 is a diagram illustrating a relationship between the usage amount, the predicted value, and the monitoring interval in a case where the current usage amount in the usage status monitoring processing unit 106 according to the present embodiment exceeds the determination value.

FIG. 5 is a flowchart illustrating a processing procedure of a table reconstruction processing unit 107 according to the embodiment.

[Explanation of symbols]

Reference numeral 101: terminal, 102: online transaction processing system, 103: memory, 108: resource management table, 109: next table address part, 110: number of entries, 111: number of entries in use, 112: entry part, 104: transaction Processing unit, 105: table initial creation processing unit, 106: use status monitoring processing unit,
107: Table reconstruction processing unit.

Claims (5)

[Claims] 1. A resource management table number optimizing method for optimizing the number of entries in a resource management table for managing resources used in online transaction processing, the method comprising the steps of: A step of monitoring entry usage and instructing an increase in the upper limit of the resource management table when the number of used entries exceeds a predetermined threshold; and an instruction to increase the upper limit of the resource management table is issued. Expanding the entries of the resource management table in a case. 2. The method according to claim 1, wherein when the predicted value of the number of in-use entries predicted after the next interval exceeds the upper limit of the resource management table, the next interval value is reduced. Resource management table number optimization method. 3. The method of optimizing the number of resource management tables according to claim 2, wherein the predicted value is calculated from the number of entries in use last time and the number of entries in use this time. 4. An online transaction processing system for optimizing the number of entries in a resource management table for managing resources used in online transaction processing, wherein the usage status of entries in the resource management table is determined at predetermined intervals during online transaction processing. And a usage status monitoring processing unit that instructs to increase the upper limit value of the resource management table when the number of entries in use exceeds a predetermined determination value, and issues an instruction to increase the upper limit value of the resource management table. An online transaction processing system, comprising: a table reconfiguration processing unit that expands an entry of a resource management table in the event of a failure. 5. A program for causing a computer to function as an online transaction processing system for optimizing the number of entries in a resource management table for managing resources used in online transaction processing. A usage monitoring processor for monitoring the usage of entries in the resource management table, and instructing an increase in the upper limit of the resource management table when the number of used entries exceeds a predetermined threshold value; A program that causes a computer to function as a table reconfiguration processing unit that expands an entry in a resource management table when an instruction to increase the upper limit value is issued.