JP2523628B2 - Resource management control method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Industrial field of use] The present invention relates to a system for performing exclusive control of resources.

[Prior Art] As described in Japanese Patent Application No. 59-182626, the conventional method is a block in which a database machine transfers data from a data storage medium to a main storage device in accordance with a database arithmetic processing request, and includes records that meet the conditions. And sending information indicating the location (address) of the record that matches the conditions. However, no attention has been paid to the efficient control of the resource lock by using the database machine when the database operation processing is requested. Here, a lock is a means for expressing that a resource is being used and for dedicating or sharing the resource by a plurality of database operation processing units.

[Problems to be solved by the invention]

The above-mentioned prior art does not consider a method for efficiently performing the unlock processing for resources in response to the notification from the database machine in the database operation processing using the database machine.
Since it has to be determined whether or not the data in the resource to be operated has been operated, it has been a problem that the unlock processing of the resource takes time.

The object of the present invention is to set the resource lock setting on the host side, and after the database machine performs the database calculation processing, select the resource (group) that does not satisfy the calculation condition from among the resource (group). By notifying the host side, the resource is unlocked and the processing time is reduced on the host side.

[Means for solving problems]

The purpose of the above is that the database machine receives the database operation request and the locked resource information (more than one) of the operation target from the host computer, and at the time of the database operation, the resource information that does not satisfy the operation condition (locks on the host side). This is achieved by totaling the IDs of existing resources, sending them to the computer on the host side after completing the database processing.

[Action]

The database management system on the host computer locks the resources storing the data to be database-calculated and transfers those resources and the database-calculation request to the database machine. The database machine uses this resource id for accessing the operation target. At the time of database operation, the database machine checks whether there is data that satisfies the operation condition for each resource that is the operation target. If there is no data that satisfies the operation condition, the database machine uses the resource as the unlocking resource.
Remember your ID. When the processing is completed for the resource group of one database operation processing request, the resource ID to be unlocked is transferred to the host side. The database management system on the host computer unlocks the resource based on the resource ID of the unlock that was transferred from the database machine (for the resource that was not unlocked, the transaction of the database operation request ends). Then the database management system unlocks). As a result, the resource ID of the resource to be unlocked is notified from the database machine and unlocked, so there is no need to select the resource to be unlocked on the host computer.

〔Example〕

Hereinafter, one embodiment of the present invention will be described in detail.
The configuration of the embodiment is shown in FIG. 1 is the central processing unit (CP
U), 2 is a main memory, 3 is a database machine, and 4 is an external storage device. Reference numeral 21 in the main memory 2 is a database management system, which uses the database machine 3 to perform database calculations. In the database management system 21, the database calculation management unit 21 that controls the database calculation
1. A lock management unit 212 that performs exclusive control using a logical storage area of data that is the target of database operation as a resource (here, a page that is a logical block is one resource), an operation result transferred from the database machine 3 And the resource id (page number) of the unlock target
A buffer management unit 213 for controlling the input of a lock resource, a lock management block 214 for managing the locked resource, and a buffer unit 215 for receiving the operation result and the resource ID to be unlocked from the database machine 3. The lock management block 214 is, as shown in FIG. 2A, an ID page number of a table to be locked, a lock mode (described in the following sentence), a count unit indicating the number of locked arithmetic processing requests, It has a structure to store IDs (multiple) of database operation processing requests that are waiting for locking.
There are multiple this block.

On the other hand, in the database machine 3, a calculation request receiving unit 31 that receives a database calculation request from the CPU 1, a calculation request information storage block 35 composed of a plurality of blocks for storing the received database calculation request information, and a database calculation request from the host computer side. Based on this, the database operation request information in the operation request information storage block is taken out, and the database operation unit 32 for performing the database operation of the corresponding data in the external storage device 4, the record to be operated in the external storage device 4 (page Access processing control unit 3 for storing the data in the data storage buffer unit 37.
3, a resource ID management block 36 that stores a page number that does not include data that satisfies the calculation condition of the pages accessed as the calculation target, the database calculation result in the database calculation result storage buffer unit 37, and
Data transfer control unit that transfers the page number in the resource id management block (which is to be unlocked) to the main memory 2.
It consists of 34. Database calculation result storage buffer 37
As shown in FIG. 3, it comprises page number storage buffers 371 (plurality) for storing pages from an external storage device and calculation result storage buffers 372 (plurality), and which computation processing request is issued to each buffer. It has a storage area for a calculation request ID that indicates whether or not A table is stored in the database 41 on the external storage device 4, and the table is made up of a plurality of columns and is called a row. This table consists of logical access units called pages, and rows are stored within this page.

Next, an example of the above-mentioned configuration will be described focusing on the processing of the lock management unit 212 of the database management system 21. Before issuing the database operation processing request to the database machine 3, the lock management unit 212 here sets the page group (here, only pages), which is the resource targeted for the operation, to another transaction ( Exclusive control is performed to prevent loss of data consistency by accessing the database and accessing by the logical execution unit that performs arithmetic processing. First, in the database management system 21, a processing request for performing a database operation on a certain table occurs. The database operation management unit 211 passes control to the lock management unit 212 before sending the database operation processing request to the database machine 3. In the table accessed by the transaction, the lock management unit 212 firstly sets the page number and table ID of the page group to be operated by the database machine 3 and the lock mode (the page can be accessed in common with other database operation processing requests. Or not, for example, to show these modes, set "1" for shared access enabled, "2" for shared access disabled),
The arithmetic processing request ID of the lock request source is received from the database arithmetic management unit 211, and the locking processing of all pages is performed in page units according to the following situations.

1) If there is no lock management block 214 storing the same table ID and page number, an empty lock management block 214
Secure, set the table ID, page number, and lock mode you want to lock to, and set the lock management block 21
Set the value of the count part of 4 to 1. As a result, the page is locked.

2) If a lock management block 214 storing the same table ID and page number already exists, the page set in this lock management block 214 is shared accessible (lock mode = "1") and the lock request source The lock mode is also accessible in common, and if there is no database operation request waiting for the lock request (lock management block 21
No lock request waiting operation processing request ID is set in 4), and 1 is added to the count section of the lock management block 214. As a result, the page is also locked.

In the case other than the above-mentioned conditions, the database operation request is locked on this page. For this reason,
A lock management block that stores the page number of the lock request.
The operation request ID waiting for the lock request is set in 214. If the above lock processing is completed for all pages of this database operation request and there is no lock wait,
The completion of the lock is reported to the database operation management 211. If a lock wait occurs even for one page, it does not return to the database operation management unit 211 until the lock is completed. The database operation management unit 211 passes the resource information such as the page number to the lock management unit 212, and if the database operation request to the database machine is permitted by the execution of the lock processing described above, the database operation is sent to the database machine 3.
Issue a database operation request.

The database machine 3 performs the following processing. From the database management system 21 side, the calculation request receiving unit 31 determines the calculation condition, the resource information (table) ID page number (plurality) to be calculated, and the storage address on the external storage device 4 in which the resource exists. It is received and stored in the empty operation request information storage block 35. The database operation unit 32 retrieves the storage address of the resource to be operated on the external storage device 4 from the operation request information storage block 35, passes it to the access processing control unit 33, and requests it to input the page of the table. . Access processing control unit
33 indicates, from the external storage device 4, based on the storage address on the external storage device 4 received from the database calculation unit 32,
The page to be calculated is taken out and stored in an empty page storage buffer 371 in the data storage buffer 37. After this, the page number of the database operation unit 32 and the buffer ID of the buffer storing the page are passed, and the completion of page input is reported. Based on the page number and buffer id from the access processing control unit 33, the database operation unit 32 determines the conditions of the database operation concerned by the operation request information storage block.
It is extracted from 35 and it is determined whether or not there is data satisfying the operation condition for the page in the page storage buffer 371 of the corresponding buffer ID in the data storage buffer unit 37. If there is data that satisfies the conditions, the data is calculated and stored in the calculation result storage buffer 372 of the data storage buffer unit 37 corresponding to the calculation processing request ID.
If there is no operation result storage buffer 372 corresponding to this operation processing request ID that can be stored, an empty operation result storage buffer 372 is secured and the operation result is stored there. If there is no data that satisfies the conditions on the page,
The page number and the table ID are stored in the resource ID management block 36 corresponding to the database operation request ID.
If there is no resource ID management block that can store the page number, secure an empty resource ID and set the page number. At this time, in order to identify the block, the arithmetic processing request ID is stored in the secured resource ID management block 36. All the resources (all pages) in the calculation request information storage block 35 are input by inputting the page to be calculated on the external storage device 4 and calculating the data in the page.
After the division, the control is transferred to the data transfer control unit 34, and the corresponding operation result storage buffer 372 in the data storage buffer unit 37 is stored.
Data and all resources corresponding to the corresponding processing request id
The page number and table ID in the ID management block are stored in the buffer section 215 of the database management system 21 on the host computer side.
Transfer to After the transfer is completed, the database operation unit 32 displays the operation request information storage block 35 for the operation request ID, the resource ID management block 36 group, and the operation request id
The page number storage buffer 371 and the operation result storage buffer 372 of the corresponding data storage buffer unit 37 are made empty. After that, the database operation unit 32 checks the operation request information storage block 35, and if there is other operation processing request information, moves to that processing.

On the other hand, the buffer management unit of the database management system 21 receives the calculation result and the page numbers (plurality) and table IDs that are not the calculation target from the database machine in the database calculation request buffer, and then performs the database calculation management. Notify part 211. The database operation management unit 211 unlocks the page of the table locked for the database operation,
The page number (plural) and table ID corresponding to this database calculation are acquired from the buffer unit 215, and the lock management unit 2
Request to unlock by passing to 12. The lock management unit 212 takes in the passed table ID and page number (plural), and has the same information as the lock management block 21.
4 is obtained, and the lock release process is performed for all pages.
The lock is released page by page, and individual processing is performed according to the following conditions.

1) When only the database operation request to be unlocked is locked on this page (count section of lock management block 214 = 1), there is an operation request waiting for lock on this page. If not (no lock waiting operation request id is set in the lock management block 214), the lock management block 214 is made empty. This means that the lock on this page has been released.

2) A plurality of arithmetic processing requests are locking this page (the value of the count part of the lock management block 214 is 2).
In the above case, 1 is subtracted from the counting section. This allows
This means that the lock on this page has been released.

3) If only the database operation request to be unlocked is locked on this page (the value of the count section is 1), and if there is a lock wait database operation request on this page (in the lock management block 214, Releases the lock wait of the database operation request that was first in the lock wait (the lock wait operation request is in the lock management block).
clear the id).

By the above lock release processing, if there is a database operation request for which there are no more pages waiting to be locked, the database operation management unit 211 is notified and a database operation request for release of lock wait is issued to the database machine together with the report of the lock release completion. I will also report permission for that.

The embodiment has been described above in which the locking and unlocking of the page group of the table to be operated for one database operation processing request is performed using the database machine. In this embodiment, the resource for setting and releasing the lock is described as a page.
For rows, the same procedure as above can be used.

〔The invention's effect〕

According to the present invention, at the time of releasing a locked resource, the resource information to be unlocked may be received from the database machine, and the resource indicated by the resource information may be unlocked by the database management system on the host side. For this reason, there is no need for the host to detect the resource to be unlocked, and there is an effect that the efficiency of unlocking processing can be improved and the CPU usage time can be reduced.

[Brief description of drawings]

FIG. 1 is a diagram showing a schematic configuration of an embodiment of the present invention. FIG. 2 is a detailed explanatory diagram of the lock management block 214, and FIG. 3 is a detailed explanatory diagram of the data storage buffer unit 37. 3 ... Database machine, 21 ... Database management system, 32 ... Database operation unit, 36 ... Resource id
Management block, 212 ... Lock management section, 214 ... Lock management block.

Claims (3)

(57) [Claims] 1. A database machine which is connected between a central processing unit and an external storage unit for storing a database and which performs a database operation for data in the external storage unit in accordance with an instruction from the central processing unit. In a resource management control method for a computer system, the central processing unit locks a resource that is a target of a database operation and instructs the database machine to perform the database operation, and the database machine responds to data in the resource according to the instruction. Information for performing an operation, determining a resource that does not include data that satisfies the operation condition, and unlocking the resource that does not include the data that satisfies the operation condition from the database machine based on the result of the determination. To the central processing unit and lock the Based on the information for releasing, resource management control system by the central processing unit, characterized in that to unlock the resource that does not contain the data that satisfies the operation. 2. The resource management control system according to claim 1, wherein the resource is a logical or physical storage area of data constituting the database. 3. The resource according to claim 1, wherein the information for releasing the lock includes a resource ID for identifying a resource that does not include data that satisfies the condition of the operation. Management control method.