JPH02224152A - File exclusive control device - Google Patents

Abstract

PURPOSE:To execute retrieving processing without sharply decreasing the through-put of a data base whose updating processing is being executed by making it possible to execute retrieval without exclusively waiting except the period of updating processing even when updating processing is being executed. CONSTITUTION:At the time of defining an area in a data base file 24, the availability of retrieval of an exclusively updated storage unit is defined. When a retrieval request 103 is generated from a retrieving program means 12 accessed from a retrieval control means 14, retrieval can be executed without exclusively waiting except the period of updating processing even when an updating program means 11 accessed from an updating control means 13 is executing the updating processing. Consequently, the retrieving processing can be executed without sharply decreasing the through-put of the data base whose updating processing is being executed.

Description

DETAILED DESCRIPTION OF THE INVENTION [Industrial Field of Application] The present invention is applied to a file exclusive control device for a database file of an electronic computer system.

〔overview〕

In the file exclusive control device of the present invention, the second exclusive identification information is used separately from the first exclusive identification information, and the update control means is canceled if the second exclusive identification information is already update exclusive or search exclusive. If the second exclusive identification information is not already updated, the search control means makes the search exclusive until the end of the search process. This makes it possible to perform search processing on a database that is undergoing update processing without causing a significant drop in throughput.

[Conventional technology]

Conventionally, when a storage unit is to be excluded, a file exclusion control device has performed both update exclusion and search exclusion based on one exclusion identification information.

[Problem that the invention seeks to solve]

However, with such conventional file exclusive control devices,
Exclusive control is performed using one exclusive identification information, but in order to avoid conflicts when updates are made from multiple programs at the same time, the storage units that are updated and searched need to be exclusive until the end of the program. Search programs also have the disadvantage of waiting for exclusion when searching for a storage unit that is update-exclusive.

The present invention solves the above-mentioned drawbacks, and aims to provide a file exclusive control device that can perform search processing without significantly reducing throughput for a database that is undergoing update processing. .

[Means for solving problems]

The present invention includes a database file divided into a plurality of data storage areas, an exclusive state storage means storing first exclusive identification information indicating an exclusive state corresponding to the plurality of data storage areas, and an update program means. an update control means for controlling an update process or a search process using the first exclusive identification information based on an update request or a search request; and a search control means for controlling a search process based on a search request from the search program means. In the file exclusive control device equipped with
The exclusive state storage means includes means for storing second exclusive identification information indicating an exclusive state in correspondence with the plurality of data storage areas, separately from the first exclusive identification information, and the second exclusive identification information is Temporary update exclusion means that waits until update exclusion or search exclusion is already applied until it is canceled, and if update exclusion is not performed until update processing is completed; the update control means executes the temporary update exclusion means based on the update request. The search control means includes means for activating the temporary search exclusive means based on the search request.

[Effect]

The exclusive state storage means stores second exclusive identification information in addition to first exclusive identification information indicating exclusive states for the plurality of data storage areas. If the second exclusion identification information is already update-exclusive or search-exclusive, the temporary update exclusion means waits until the second exclusion identification information is released; if the second exclusion identification information is not exclusive, it is update-exclusive until the end of the update process. If the temporary search exclusion means has already been updated, it waits until it is released, and if it has not been updated, the temporary search exclusion means performs the search exclusion until the end of the search process. The update control means activates the temporary update exclusion means based on the update request.

The search control means activates the temporary search exclusion means based on the search request. Through the above operations, even if an update process is being performed, a search can be performed without waiting for exclusive use, except during the update process, and the search process can be performed without causing a significant drop in throughput for the database where the update process is being performed. Can be done.

〔Example〕

Embodiments of the present invention will be described with reference to the drawings. 1st
The figure is a block diagram of a file exclusive control device according to an embodiment of the present invention. In FIG. 1, the file exclusive control device includes a database file 24 divided into a plurality of data storage areas, and exclusive state storage means in which first exclusive identification information 22 indicating an exclusive state is stored corresponding to the data storage areas. 2
1, an update exclusive means 15 that waits until the first exclusion identification information 22 is already update exclusive or search exclusive, waits until it is released, and updates and excludes the first exclusive identification information 22 up to a stationary point if it is not exclusive; If the identification information 22 has already been subjected to update exclusion, it waits until it is released, and if it is not excluded, it searches and excludes the identification information 22 up to a stationary point. A database update means 19 performs an update process on the database file 24. , a database search means 20 that performs a search process for the database file 24, and first exclusive identification information 22 corresponding to the data storage area that activates the update exclusive means 15 based on the update request 101 of the update program means 11 and updates up to a static point. The database update means 19 is activated by updating and exclusive, and the search exclusive means 17 is activated based on the search request 102 of the update program means 11 to search and exclude the first exclusive identification information corresponding to the data storage area to be searched up to the rest point. the update control means 13 which starts the database search means 20, and the search request 1 of the search program means 12;
03.

Here, the feature of the present invention is that, in addition to the first exclusive identification information, the exclusive state storage means 21 stores second exclusive identification information 23 indicating exclusive states corresponding to the plurality of data storage areas. If the second exclusion identification information 23 is already update-exclusive or search-exclusive, it waits until it is released, and if it is not exclusive, it updates and excludes it until the end of the update process. and a temporary search exclusion means 18 that waits until the second exclusion identification information 23 is already updated and excluded, and performs search exclusion until the end of the search process if the second exclusion identification information 23 is not updated,
The update control means 13 includes means for activating the temporary update exclusion means 16 based on the update request 101, and the search control means 14
The present invention includes means for activating the temporary search exclusion means 18 based on the search request 103.

The operation of the file exclusive control device having such a configuration will be explained. FIG. 2 is a diagram showing the contents of a database file of the file exclusive control device of the present invention. FIG. 3 is an explanatory diagram of the operation of the file exclusive device of the present invention.

FIG. 2 shows an example of the structure of the database file 24. As shown in FIG. 2, the database file 24 is composed of a plurality of data storage areas 201, 202, . It is composed of storage units 203, 204, and 205.

In Figures 1 to 3, first the database file 24
When defining an area, it is defined that a storage unit that is update-exclusive can be searched.

Update control means 1 for this database file 24
When an update request 101 is made from the update program means 11 accessed in step 3, the update control means 13 activates the update exclusive means 15 and the temporary update exclusive means 16 to perform update processing, and when a search request 102 is made, the update control means 13 starts the update exclusive means 15 and temporary update exclusive means 16 to perform the update process. The exclusive means 17 is activated to perform search processing.

Further, when a search request 103 is issued from the search program means 12 accessed by the search control means 14, the temporary search exclusion means 18 is activated to perform search processing.

Therefore, as shown in FIG.
If step 03 is performed, even if an update process is being performed from the update program unit 11 accessed by the update control unit 13, the search can be performed without waiting for exclusive use except when the update process is in progress.

〔Effect of the invention〕

As described above, the present invention has an excellent effect in that search processing can be performed without causing a large drop in throughput for a database that is being updated.

[Brief explanation of the drawing]

FIG. 1 is a block diagram of a file exclusive control device according to an embodiment of the present invention. FIG. 2 is a diagram showing the contents of a database file of the file exclusive control device of the present invention. FIG. 3 is an explanatory diagram of the operation of the file exclusive control device of the present invention. DESCRIPTION OF SYMBOLS 11... Update program means, 12... Search program means, 13... Update control means, 14... Search control means, 15... Update exclusive means, 16... Temporary update exclusive means, 17 ...Search exclusive means, 18... Temporary search exclusive means, 19... Database update means, 20.
. . . Database search means, 21 . . . Exclusive status storage means, 22 . . . First exclusive identification information, 23 .
...Update request, 102.103...Search request, 201
．． 202...Data storage area, 203-205...
Storage unit, R...search processing, U...update processing.

Claims (1)

[Claims] 1. A database file divided into a plurality of data storage areas, and exclusive state storage means storing first exclusive identification information indicating an exclusive state corresponding to the plurality of data storage areas; update control means for controlling the update process or search process based on the update request or search request from the update program means using the first exclusive identification information; and search for controlling the search process based on the search request from the search program means. In the file exclusive control device, the exclusive state storage means stores second exclusive identification information indicating exclusive states corresponding to the plurality of data storage areas, separately from the first exclusive identification information. If the second exclusive identification information is already update-exclusive or search-exclusive, it waits until it is released, and if it is not exclusive, it is update-exclusive until the end of the update process; , temporary search exclusive means waits until the second exclusive identification information is already update-exclusive until it is released, and if the second exclusive identification information is not exclusive, performs search exclusion until the end of the search process, the update control means , a file exclusive control device comprising means for activating the temporary update exclusive means based on the update request, and wherein the search control means includes means for activating the temporary search exclusive means based on the search request.