JPH05100875A - Controller for execution order of transaction - Google Patents

Abstract

PURPOSE:To improve the offering characteristic of service and the real time characteristic of service offering by appropriately controlling the execution order of a resource securing transaction and a resource release transaction. CONSTITUTION:The total number of resources which can be used is managed apart from a database which manages the use state of the resources. When the total number of the resources which can be used exceeds a setting reference value, it is judged that the use rate of the resource is comparatively low and the resource can highly possibly be secured, and the resource securing transaction 106 is preferentially executed compared to the resource release transaction 107. Thus, the real time characteristic of service offering is improved without deteriorating the offering characteristic of service. When the total number of the resources which can be used does not exceed the setting reference value, it is judged that the use rate of the resource is comparatively high and the resources cannot highly possibly be secured, and the resource release transaction 107 is preferentially executed compared to the resource securing transaction 106. Thus, the deterioration of the service offering characteristic can be prevented.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention manages the use state of resources required for providing a service by a database, and a resource securing transaction for securing resources in response to a request for a service and a resource release upon termination of the service. The present invention relates to a transaction execution order control device in a system in which resource release transactions for are input at the same time.

[0002]

2. Description of the Related Art In order to provide a service to a user online, the usage state of resources required for the service is managed by a database, and when the service is requested, the service is secured by executing a resource securing transaction. There is a system that performs a database process for securing resources used in the above, and performs a database process for releasing resources used by the service by executing a resource release transaction when the service ends. Such a system is required to have a service providing property that can reliably provide the requested service and a real-time service providing property that can immediately provide the requested service. In order to improve the service provision property, it is necessary to release the resource promptly when the service is terminated, and it is effective to execute the resource release transaction prior to the resource securing transaction. On the other hand, in order to improve real-time service provision, it is necessary to shorten the response time of the resource securing transaction, and it is effective to execute the resource securing transaction with priority over the resource releasing transaction. As described above, the transaction execution order control affects the service provision property and the service provision real-time property.

As a conventional method for determining the execution order of transactions input to the system, there are a method according to the order input to the system and a method according to the order of priorities given to the transactions. Operating System Basics "(Baifukan, 19
78). FIG. 2 shows a configuration example of a system 200 using these methods. In FIG. 2, the transaction 203 input to the system 200 is held in the execution queuing unit 201, and then the transaction execution unit 2
02 to be executed. When executing the transaction, in the former method, the transaction execution unit 2
02 takes out the transactions held in the execution waiting unit 201 in order from the earliest holding start time and executes them. In the latter method, the transaction 203 is given a priority in advance, and the transaction execution unit 202
Executes the transactions held in the execution queuing unit 201 in order of priority.

[0004]

However, in the former method, the use state of the resources necessary for providing the service is managed by the database, and the transaction for securing the resources and the termination of the service are requested when the service is requested. When a transaction for releasing the accompanying resources is applied to a system that is input at the same time, if the holding start time of the resource securing transaction is earlier than the holding start time of the resource releasing transaction even if all the resources to be secured are in use Since the resource securing transaction is always executed first, the service corresponding to the resource securing transaction cannot be provided, and there is a problem in that the service provision capability is deteriorated. On the contrary, even if the resource to be secured is available, if the hold start time of the resource release transaction is earlier than the hold start time of the resource reserve transaction, the resource release transaction is executed first. Time will increase,
There is a problem that the real-time property of service provision is deteriorated.

On the other hand, in the latter method, when a resource reservation transaction is given a higher priority than a resource release transaction in order to improve the real-time property of service provision, even if all the resources to be reserved are in use. Since the securing transaction is executed with priority over the resource releasing transaction, there is a problem that the service corresponding to the resource securing transaction cannot be provided and the service providing ability is deteriorated. Conversely, the service providing ability is enhanced. If a higher priority is given to a resource release transaction than a resource secure transaction, the resource release transaction will be executed with priority over the resource secure transaction even if the resource to be secured is available. Transaction response time will increase, Real-time-bis provided there was a problem of a decrease.

The present invention has been made in view of the above, and an object thereof is to appropriately control the execution order of resource securing transactions and resource releasing transactions.
Another object of the present invention is to provide a transaction execution control device that improves the service provision property and the service provision real-time property.

[0007]

[Means for Solving the Problems] In order to achieve the above object, the use state of resources required for providing a service is managed by a database, and when a service is requested, a resource securing transaction for securing resources is performed. Run and
In a device that executes a resource release transaction for releasing resources when a service ends, the present invention provides a resource number storage that sequentially updates and stores the number of resources that can be used with the execution of a resource securing transaction or a resource releasing transaction. Means for executing the resource securing transaction with priority over the resource releasing transaction when the number of resources stored in the resource number storage means exceeds the set reference value, and when the number of resources does not exceed the set reference value The gist of the present invention is to have an execution order control means for executing the release transaction with priority over the resource securing transaction.

[0008]

In the transaction execution order control device according to the present invention, the total number of available resources is managed separately from the database that manages the usage state of the resources, and the total number of available resources is set as a reference value. When it exceeds the threshold, it is judged that the resource utilization rate is relatively low and there is a high possibility that the resource can be secured, and the resource securing transaction is executed with priority over the resource releasing transaction, thereby providing the service without degrading the service availability. When the total number of available resources does not exceed the set reference value, it is judged that the resource usage rate is relatively high and there is a high possibility that resources cannot be secured, and resource release transactions are given priority over resource securing transactions. It is possible to prevent the deterioration of service provision by executing the program.

[0009]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram of an embodiment of the present invention.
101 is a reservation waiting unit, 102 is a release waiting unit, 103
Is an execution order control unit, 104 is a resource number storage unit, 105 is a transaction execution unit, 106 is a resource securing transaction, and 107 is a resource releasing transaction.

The resource securing transaction 106 is a transaction for requesting the system 100 for resources required for a service. The resource reservation transaction 106 input to the system 100 is registered in the reservation waiting unit 101 in the order of transaction arrival. On the other hand, the resource release transaction 107 is a transaction that notifies the system 100 that the service has ended and the resource has been released. The resource release transaction 107 input to the system 100 is registered in the release waiting unit 102 in the order of transaction arrival.

The transaction executing unit 105, for example, the service A requires three types of resources of type 1, type 2, and type 3, and the corresponding relation between the types of resources required for the service, for example, type 1 There are 5 resources in total, and the relationship between the type of resources and the number of available resources, such as the currently available 3 resources, is managed as a database, which is requested by the execution order control unit 103 and received. The resource securing transaction 106 or the resource releasing transaction 107 is executed while accessing the database. More specifically, when executing the resource securing transaction 106, the type of resources required for the service corresponding to the transaction is obtained, and it is confirmed whether or not there are available resources for all the obtained resource types. If all resources are available, information about the resources to be used is returned to the transaction issuer, and if at least one resource is unavailable, information indicating that the service cannot be provided. Further, when all the resources required for the service are available, the database is updated to make the resources in use, and the resource number storage unit 104 is notified that the total number of available resources has decreased. On the other hand, when executing the resource release transaction 107, the database is updated so that the resources used by the service corresponding to the transaction are made empty, and the fact that the total number of available resources has increased is stored in the resource number storage unit 104. Notify me.

The resource number storage unit 104 manages the total number of resources currently available according to the notification from the transaction execution unit 105. The initial value of the total number is notified from the transaction execution unit 105 when the system is started up. For example, when there are 5 resources for each of 100 types of resources, 500 is set as the initial value.
Then, when the decrease in the number of available resources is notified by the execution of the resource securing transaction 106 in the transaction execution unit 105, the total number is updated to a value obtained by subtracting the notified number of resources from the current value. When the increase in the number of available resources due to the execution of the resource release transaction 107 in the transaction execution unit 105 is notified, the total number is updated to a value obtained by adding the notified number of resources to the current value.

When the transaction execution unit 103 requests a transaction to be executed, the execution order control unit 103 inquires of the resource number storage unit 104 about the total number of currently available resources, and the total number and a preset reference value are set in advance. By comparing with the set critical value, the resource securing transaction 106 or the resource releasing transaction 107 is taken out from the securing waiting unit 101 or the releasing waiting unit 102 and given to the transaction executing unit 105 according to the rule described below. Specifically, when the total number of available resources is larger than the critical value, the resource securing transaction 106 registered in the securing waiting unit 101 is given to the transaction executing unit 105, and conversely, the total number of available resources is When it is below the critical value, the resource release transaction 107 registered in the release waiting section 102 is given to the transaction executing section 105. The transaction execution unit 10 of the resource securing transaction 106
5, when the resource reservation transaction 106 is not registered in the reservation waiting unit 101 and the resource release transaction 107 is registered in the release waiting unit 102, the resource release transaction is sent to the transaction execution unit 105. When transmitting the resource release transaction 107 to the transaction execution unit 105, the resource release transaction 1 is sent to the release waiting unit 102.
If 07 is not registered and the resource reservation transaction 106 is registered in the reservation waiting unit 101,
The resource securing transaction is given to the transaction executing unit 105. Further, when a plurality of transactions are simultaneously registered in the secure queuing unit 101 or the release queuing unit 102, the transaction with the earliest arrival order to the system is prioritized, and the transaction is made to both the secure queuing unit 101 and the release queuing unit 102. If not registered, the transaction execution unit 105 is notified that there is no transaction to be executed. The critical value used in the rules described above is a value that is 0 or more and less than or equal to the total number of resources managed by the system. For example, 30% of the total number of resources managed by the system is set, and the number of resources is stored when the system is started It can be set by calculating from the initial value of the total number of available resources set in the unit 104. In this case, the real-time property of service provision becomes higher as the critical value is closer to 0, and the service provision property becomes higher as the critical value is closer to the total number of resources managed by the system.

Therefore, according to the present embodiment, the total number of available resources is managed separately from the database for managing the resource usage state, and the resource usage state is estimated without accessing the database based on the total number. However, the execution order of the transactions can be determined by dynamically changing the priorities of the resource securing transaction and the resource releasing transaction according to the resource usage state. That is, when the execution order control unit 103 requests the next transaction to be executed from the transaction execution unit 105, it compares the total number of resources available at that time obtained from the resource number storage unit 104 with a predetermined critical value. By doing so, it is determined whether or not there is a high possibility that the resource can be secured when the resource securing transaction is executed at that time. When the total number of available resources is larger than the critical value, it can be determined that the resource utilization rate is relatively low and there is a high possibility of securing resources.
By executing the resource securing transaction with priority over the resource releasing transaction, the real-time property of service provision can be enhanced without degrading the service provision capability. When the total number of available resources is less than the critical value, it can be determined that the resource usage rate is relatively high and there is a high possibility that resources cannot be secured, and the resource release transaction is executed with priority over the resource securing transaction. It is possible to prevent the deterioration of the providing property.

[0016]

As described above, according to the present invention, the total number of available resources is managed separately from the database that manages the usage state of resources, and the total number of available resources exceeds the set reference value. Sometimes it is determined that the resource utilization rate is relatively low and there is a high possibility that resources can be secured, and by executing resource securing transactions with priority over resource releasing transactions, real-time service provision without degrading service availability. When the total number of available resources does not exceed the set standard value, it is judged that the resource usage rate is relatively high and there is a high possibility that resources cannot be secured, and resource release transactions are given priority over resource securing transactions. By executing it, it is possible to prevent deterioration of service provision. Can appropriately control the execution order of-transactions, it is possible to improve the real-time offer and service providing service have.

[Brief description of drawings]

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

FIG. 2 is a diagram showing a configuration of a conventional method.

[Explanation of symbols]

 101 Secure Waiting Unit 102 Release Waiting Unit 103 Execution Order Control Unit 104 Resource Number Storage Unit 105 Transaction Execution Unit 106 Resource Securing Transaction 107 Resource Release Transaction 201 Execution Waiting Unit 202 Transaction Execution Unit 203 Transaction

Claims (1)

[Claims] 1. A database is used to manage the usage status of resources required to provide a service. When a service is requested, a resource securing transaction for securing the resource is executed, and when the service is finished, the resource is released. In a device for executing a resource release transaction for a resource, a resource number storage means for sequentially updating and storing the number of resources available with the execution of a resource securing transaction or a resource release transaction, and a resource number storage means When the number of existing resources exceeds the setting reference value, the resource securing transaction is executed with priority over the resource releasing transaction, and when the number of resources does not exceed the setting reference value, the resource releasing transaction is executed with priority over the resource securing transaction. And an execution order control means. Transaction execution order controller.