JPS63273940A - Control system for resource management - Google Patents

Abstract

PURPOSE:To shorten the processing time for lock release by applying an arithmetic process to the locked resources at the host side via a data base machine and then informing the resources satisfying no arithmetic condition to the host side. CONSTITUTION:A data base managing system 21 of a host computer locks the resources storing the data to undergo the data base arithmetic and transfers the data base arithmetic requests as well as those resources to a data base machine 3. The machine 3 uses a resource ID for access of an arithmetic object and performs the data base arithmetic for the corresponding data stored in an external memory 4 at every resource to undergo an arithmetic operation for check whether some data satisfy the arithmetic conditions or not. If no data satisfies the arithmetic conditions, the resource ID is stored as the resources whose lock is released. When the processing is through with a group of resources, the resource ID to be locked is transferred to the host side. Thus the lock release processing time is shortened.

Description

[Detailed description of the invention] [Industrial application field] The present invention relates to a method for performing exclusive control of resources.

[Conventional technology]

In the conventional method, as described in Japanese Patent Application No. 50-182626, in response to a request for database arithmetic processing, a database machine transfers blocks containing records that meet the conditions and blocks that match the conditions from the data storage medium to the main storage device. It is described that information indicating the location (address) of the record is sent. However, no consideration has been given to efficiently performing lock control on resources using a database machine when a database calculation process is requested. Here, a lock is a means of declaring that a resource is being used and allowing a plurality of database processing units to dedicate or share the resource.

[Problem that the invention seeks to solve]

The above conventional technology does not take into consideration a method for efficiently performing lock release processing for resources upon receiving notification from the database machine in database calculation processing using a database machine. There was a problem in that it took a long time to unlock the resource because it had to be determined whether the data in it had been calculated or not.

An object of the present invention is to select a resource (group) from among the resources (group) that does not satisfy the conditions for the operation after the database machine performs database calculation processing on a resource that has been locked on the host side. By notifying the host side.

The purpose is to unlock resources and reduce processing time on the host side.

[Means for solving problems]

The above purpose is for the database machine to receive a database operation request and locked resource information (multiple items) to be calculated from the host computer, and when performing database calculations, resource information that does not satisfy the operation conditions (locked on the host side). This is achieved by summing up the IDs of the resources in use, and sending them to the host computer after the database arithmetic processing is completed.

[Effect]

A database management system on a host computer locks resources that store data to be subjected to database calculations, and transfers those resources and database calculation requests to the database machine. The database machine uses this resource ID to access the calculation target.

During database calculation, the database machine checks whether there is data that satisfies the calculation conditions for each resource that is the target of the calculation, and if there is no data that satisfies the calculation conditions, it stores the resource ID as a resource to be unlocked. When the processing for the resource group of one database calculation processing request is completed, the resource ID to be unlocked is transferred to the host side. The database management system on the host computer unlocks the resources based on the unlocked resource ID transferred from the database machine. (after which the database management system unlocks it)
, this allows the resource I to be unlocked.
D is notified from the database machine and the lock is released, so there is no need to check the selection of the resource to be unlocked on the host computer.

〔Example〕

EMBODIMENT OF THE INVENTION Below, the present invention will be described in detail with reference to embodiments.

The configuration of the embodiment is shown in FIG. 1, where 1 is a 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, a database calculation management unit 211, which controls database calculations, excludes the logical storage area of data that is the target of database calculations as a resource (here, a page, which is a logical block, is one resource). Lock management unit 21 that performs control
2. Buffer management unit 213 that controls input of calculation results transferred from database machine 3 and resource ID (page number) to be unlocked; lock management block 214 that manages locked resources; database machine 3; The buffer section 215 receives the calculation result and the resource ID to be unlocked. The lock management block 214 is.

As shown in Figure 2 (a), the ID page number of the table to be locked and the lock mode (explained in the following text)
, a count section that indicates the number of locked arithmetic processing requests;
ID of the database operation processing request that was waiting for the lock (
? It has a structure that stores the number (II number), and there are multiple blocks in one block.

On the other hand, inside the database machine 3, there is a calculation request reception unit 31 that receives database calculation requests from the CPUI, a calculation request information storage block 35 consisting of a plurality of blocks for storing received database calculation request information, and a calculation request information storage block 35 that receives database calculation requests from the host computer side. Based on the request, the database calculation unit 32 retrieves the database calculation request information in the calculation request information storage block and performs database calculations on the corresponding data on the external storage device 4, and the record to be calculated on the external storage device 4 ( access processing control unit 33 .corresponding to the page) and stores it in the data storage buffer unit 37 . A resource ID management block 36 that stores page numbers that do not contain data that satisfies the calculation conditions among pages accessed as calculation targets, database calculation results in the database calculation result storage balance section 37, and resource ID It consists of a data transfer control unit 34 that transfers the page number (to be unlocked) in the management block to the main memory 2. As shown in FIG. 3, the database computation result storage buffer section 37 consists of page number storage buffers 371 (plurality) and computation result storage buffers 372 (plurality) for storing pages from an external storage device. has a storage area for an arithmetic processing request ID indicating which arithmetic processing request it corresponds to.

A database 41 on the external storage device 4 stores a table, and a table is made up of a set of rows, each consisting of a plurality of columns called rows. This table consists of logical access units called pages.
Rows are stored within this page.

Next, an embodiment of the above-described configuration will be described, focusing on the processing of the lock management section 212 of the database management system 21. Before issuing a database operation processing request to the database machine 3, the lock management unit 212 transfers a group of pages (in this case, only pages) that are the resources targeted for operation to another transaction (database machine 3). Exclusive control is performed to prevent data from losing its uniqueness due to access by a logical execution unit that performs arithmetic processing.

First, within the database management system 21, a processing request is generated to perform a database operation on a certain table. Before sending the database calculation processing request to the database machine 3, the database calculation management unit 211 passes control to the lock management unit 212. For example, the page number and table ID of the page group on which the calculation is to be performed, and the lock mode (one that indicates whether or not the page can be accessed in common with other database calculation processing requests.

To indicate these modes, shared access is “1”
, set “2” to prohibit shared access).

The arithmetic processing request ID of the lock request source is received from the database arithmetic management unit 211, and all pages are locked on a page-by-page basis according to the following situations.

1) If there is no lock management block 214 that stores the same table ID and page number, secure a free lock management block 214 and select the table 10. to which you want to lock.
The page number and lock mode are set, and the value of the count section of the lock management block 214 is set to 1. This means that 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 this lock request If the original lock mode is also shared access and there is no database calculation request waiting for a lock request (the lock request waiting calculation processing request ID is not set in the lock management block 214), the count section of the lock management block 214 Add 1 to This means that the page is also locked.

In cases other than the conditions shown above, the database calculation request for this page is placed in a lock wait state.

Therefore, the calculation processing request I that is waiting for the lock request is stored in the lock management block 214 that stores the page number of the lock request.
If 6 or more lock processes that set D have been completed for all pages of this database calculation request and there is no lock waiting, the database calculation management 211 indicates that the lock has been completed.
Report to. If a lock wait occurs for even one page, the database calculation management unit 21 does not return to the database calculation management unit 211 until the lock is completed.
1 locks resource information such as page numbers to the lock management unit 212
If the database calculation request to the database machine is permitted by executing the above-described locking process, the database calculation request is issued to the database machine 3.

The database machine 3 performs the following processing.

The calculation request receiving unit 31 receives only the calculation conditions, the resource information (table) ID page number (multiple) to be calculated)
and the storage address on the external storage bag [14 where the resource exists are received from the database management system 21 side, and stored in the empty computation request information storage block 35.

The database calculation unit 32 receives data from the calculation request information storage block 35.

External storage bag for the resource to be calculated ff! 4, and passes it to the access processing control unit 33 to request input of the page of the table. Based on the storage address on the external storage device 14 received from the database calculation section 32, the access processing control section 33 retrieves the page to be subjected to the calculation from the external storage device 14, and stores the page in the data storage buffer 37. It is stored in the empty page storage buffer 371. Thereafter, the page number and the buffer ID of the buffer storing the page are passed to the database calculation unit 32, and the completion of page input is reported.

The database calculation unit 32 retrieves the conditions for the database calculation from the calculation request information storage block 35 based on the page number and buffer ID from the access processing control unit 33, and stores the conditions in the corresponding buffer I in the data storage balance unit 37.
For the page in the page storage buffer 371 of D, it is determined whether there is data that satisfies the calculation conditions.If there is data that satisfies the 0 condition, the calculation is performed on that data, and the corresponding data in the data storage buffer section 37 is The result is stored in the calculation result storage buffer 372 corresponding to the calculation processing request ID. Here, if there is no computation result storage buffer 372 corresponding to the computation processing request ID that can be stored, an empty computation result storage buffer 372 is secured and the computation result is stored therein. If there is no monitor that satisfies the conditions in the page, the page number and 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 capable of storing a page number, a free one is secured and a page number is set. At this time, for block identification, the arithmetic processing request ID is stored in the reserved resource ID management block 36 as described above. After inputting the page to be calculated on the external storage bag [4] and performing calculation processing on the data in the page for all resources (all pages) in the calculation request information storage block 35, the data transfer control unit 34 The control is passed and the data in the corresponding calculation result storage buffer 372 in the data storage buffer section 37, the page numbers and table IDs in all resource ID management blocks corresponding to the corresponding calculation processing request ID are transferred to the database management system on the host computer side. The data is transferred to the buffer section 215 of No. 21. After the transfer is completed, the database calculation unit 32 stores the calculation request information storage block 35. for the calculation processing request ID. In addition to the resource ID management block 36 group, the same calculation processing request i
Page number storage buffer 371 of the data storage buffer unit 37 corresponding to d. The calculation result storage buffer 372 is made empty. Thereafter, the database calculation unit 32 checks the calculation request information storage block 35, and if there is any other calculation processing request information, it moves on to that process.

On the other hand, when the buffer management unit of the database management system 21 receives the calculation results, page numbers (plurality) and table IDs that were not subject to calculation from the database machine into the database calculation processing request buffer, the buffer management unit of the database management system 21 manages the database calculation processing. Department 211 is notified. The database calculation management unit 211 acquires page numbers (plurality) and table ID corresponding to the database calculation from the buffer unit 215 in order to unlock the page of the table locked for the database calculation.

By passing it to the lock management unit 212, a lock release is requested. The lock management unit 212 takes in the passed table ID and page number(s), finds a lock management block 214 having the same information, and performs lock release processing on all pages. Each process is performed in accordance with the following conditions.

l) If only the database calculation request that is the target of unlocking is locking this page (the count part of the lock management block 214 = 1), and the calculation processing request that is waiting for the lock for this page is If not (the lock waiting calculation request ID is 1 in the lock management block 214)
lock management block 21 (not always set)
Leave 4 blank. This means that this page is unlocked.

2) If multiple arithmetic processing requests have locked this page (the value in the count field of the lock management block 214 is 2 or more), subtract 1 from the count field, and this unlocks the page. It turns out.

3) If only the database operation request to be unlocked has locked this page (the value of the count field is 1), and there is a database operation request waiting for this page to be locked, (in the lock management block 214) (the lock-waiting arithmetic processing request ID is set), the database arithmetic processing request that first became lock-waiting is released from lock-waiting (the corresponding lock-waiting arithmetic processing request ID in the lock management block is cleared).

As a result of the above lock release processing, if there is a database calculation request for which there are no more pages waiting to be locked, the database calculation management unit 211 is notified of the completion of lock release, and a database calculation request for which the lock wait has been released is issued to the database machine. Also report permission.

An embodiment has been described above in which a database machine is used to set and release a lock on a page group of a table to be computed in response to one database computation processing request. In this embodiment, the lock setting and release target resources are described as pages, but in addition, there are tables and 10
- can also be performed using the same procedure as above.

〔Effect of the invention〕

According to the present invention, when a locked resource is released.

All you need to do is to receive the resource information to be unlocked from the database machine and use the database management system on the host side to unlock the resource indicated by that resource information.For this reason, the host side detects the resource to be unlocked. Since this is no longer necessary, the lock release process can be made more efficient and the CPU usage time can be reduced.

[Brief explanation of the drawing]

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 calculation unit, 36.
. . . Resource management block, 212 . . . Lock management section, 214 . . . Lock management block.

Claims (1)

[Claims] 1. In a system configuration in which a database management system runs on a computer connected to a database machine,
The database management system on the host computer locks the resources subject to database calculations (logical or physical storage areas that store data and groups of data with logical meaning) in advance, and A resource management control method characterized in that after a database machine performs an operation, a host side is notified of lock release for resources for which there is no data that satisfies the conditions of the operation. (A lock indicates that a resource is being used,
(It is a means for exclusive use and sharing of resources by multiple database processing units).