JP2740238B2 - File exclusive control unit - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Industrial Application Field] The present invention is used for a file exclusion control device for a database file of a computer system.

〔Overview〕

In the file exclusion control device of the present invention, the second exclusion identification information is used separately from the first exclusion identification information, and the update control means is released when the second exclusion identification information is already update-exclusive or search-exclusive. If the exclusive exclusion is not exclusive, the update exclusion is performed until the update processing is completed. If the second exclusion identification information is not already exclusive, the search exclusion is performed until the search processing is completed. A search process can be performed on a database on which an update process is being performed without causing a large decrease in throughput.

[Conventional technology]

Conventionally, the file exclusion control device performs both update exclusion and search exclusion based on one piece of exclusion identification information when exclusion of a storage unit.

[Problems to be solved by the invention]

However, in such a conventional file exclusion control apparatus, exclusive control is performed using one piece of exclusion identification information. However, in order to prevent inconsistency when updating is performed from a plurality of programs at the same time, the updated and searched storage Since the unit must be mutually exclusive until the end of the program, there is a disadvantage that even if the retrieval program is used, a search for a storage unit that has been updated and exclusive is waiting for exclusion.

SUMMARY OF THE INVENTION An object of the present invention is to solve the above-mentioned drawbacks, and an object of the present invention is to provide a file exclusion control device capable of performing a search process on a database on which an update process is being performed without causing a large decrease in throughput. .

[Means for solving the problem]

A file exclusion control device according to the present invention includes a database file including a data storage area composed of at least one storage unit, an update program unit for requesting an update process and a search process for the storage unit, and a search process for the storage unit. , A database update unit for updating the storage unit, a database search unit for searching the storage unit, and an update process and search by the database update unit and the database search unit for each storage unit First exclusion identification information indicating an exclusive state from the start of the process to the end of the update program unit, and from the start to the end of the update process by the database update unit and from the start of the search process by the database search unit Second exclusive identification information indicating the exclusive state until the end And exclusive state storage means for storing,
When the first exclusion identification information is update-exclusive and search-exclusive, the update exclusion unit waits until it is released, and when it is not update-exclusive and search-exclusive, updates it until the end of the update program unit. If the first exclusion identification information is updated and exclusive, it waits until the first exclusion information is released, and if it is not updated and exclusive, the search exclusion means performs search exclusion until the end of the update program means, and the second exclusion means. If the identification information is update exclusive and search exclusive, wait until it is released, and if the update exclusive and search are not exclusive, update temporary exclusive update means until the end of the update processing by the database update means. ,
A temporary search exclusion unit that waits until the second exclusion identification information is updated if the exclusion is exclusive, and if the update exclusion is not exclusive, searches until the end of the search process by the database search unit; In response to the update request of the storage unit by the update program unit, the update exclusion unit updates and exclusions the first exclusion identification information of the storage unit, and the temporary update exclusion unit updates the second exclusion identification information of the storage unit. The database updating unit performs update exclusion of the storage unit by performing the update exclusion, and in response to a search request of the storage unit by the update program unit, uses the search exclusion unit to change the first exclusion identification information of the storage unit. Update control means for performing search processing of the storage unit by the database search means while performing search exclusion; and Search control means for performing a search exclusion of the second exclusive identification information of the storage unit by the temporary search exclusion means in response to the storage unit search request, and performing a search process of the storage unit by the database search means. Have been.

[Action]

The exclusive state storage means stores second exclusive identification information in addition to the first exclusive identification information indicating the exclusive state for the plurality of data storage areas. The temporary update exclusion means waits until the second exclusion identification information has already been updated exclusion or search exclusion has been released, and if it has not been exclusiond, updates the exclusion until the end of the update process. The temporary search exclusion means waits until it is released when the update exclusion is already performed, and otherwise performs search exclusion until the end of the search processing. The update control unit activates the temporary update exclusive unit based on the update request. The search control means activates the temporary search exclusion means based on the search request. With the above operation, even if the update process is performed, the search can be performed without waiting for exclusion except during the update process, and the search process can be performed on the database on which the update process is being performed without causing a large decrease in throughput. it can.

〔Example〕

Embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram of a file exclusion control device according to an embodiment of the present invention. In FIG. 1, the file exclusion control device includes a database file 24 divided into a plurality of data storage areas, and first exclusion identification information 22 indicating an exclusion state corresponding to the data storage areas. twenty one
If the first exclusion identification information 22 is already update-exclusive or search-exclusive, the update exclusion unit 15 waits until it is released, and if it is not exclusive, updates and exclusions up to the stationary point.
If the first exclusion identification information 22 has already been updated and exclusive, the process waits until the first exclusion information 22 is released, and if it is not exclusive, performs the search exclusion unit 17 for searching and exclusion up to the stationary point, and updates the database file 24. Database update means 19
And a database search unit 20 for performing a search process of the database file 24, and an update request 10 of the update program unit 11.
1, the update exclusion means 15 is activated, the first exclusion identification information 22 corresponding to the data storage area to be updated to the stationary point is updated and exclusive, the database update means 19 is activated, and the search request 102 of the update program means 11 is executed. Search exclusive means 17 based on
Database search means for starting and excluding the first exclusive identification information corresponding to the data storage area to be searched to the stationary point
Update control means 13 for starting 20 and search program means 12
And a search control means 14 for activating the database search means 20 based on the search request 103.

Here, the feature of the present invention is that the exclusive state storage means 21 stores, in addition to the first exclusive identification information, second exclusive identification information indicating an exclusive state corresponding to the plurality of data storage areas.
In the case where 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 it until the update process ends. An update exclusion unit 16 and a temporary search exclusion unit 18 that waits for release when the second exclusion identification information 23 is already update-excluded and cancels the search until the end of the search process when the exclusion is not exclusive. 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 includes means for activating the temporary search exclusion means 18 based on the search request 103.

The operation of the file exclusion control device having such a configuration will be described. 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 exclusion 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,. Multiple storage units 2
03, 204, and 205.

In FIG. 1 to FIG.
Defines that search can be performed for storage units that are updated and exclusive when the area is defined.

Update control means 13 for this database file 24
Update request from update program means 11 accessed by
When 101 is performed, the update control unit 13 activates the update exclusion unit 15 and the temporary update exclusion unit 16 to perform the update process, and when the search request 102 is performed, activates the search exclusion unit 17 to perform the search process.

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

Therefore, as shown in FIG. 3, a search request 103 is sent from the search program unit 12 accessed by the search control unit 14.
Then, even if the update process is being performed by the update program unit 11 being accessed by the update control unit 13, the search can be performed without waiting for exclusion except during the update process.

〔The invention's effect〕

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

[Brief description of the drawings]

FIG. 1 is a block diagram of a file exclusion 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 exclusion control device of the present invention. 11 ... update program means, 12 ... search program means, 13 ... update control means, 14 ... search control means, 15 ...
Update exclusion means, 16 temporary update exclusion means, 17 search exclusion means, 18 temporary search exclusion means, 19 database update means, 20 database search means, 21 exclusion state storage means, 22 ... first exclusive identification information, 23 ... second exclusive identification information, 24 ... database file, 101 ... update request, 102, 103 ... search request, 201, 202 ... data storage area, 203-205 ... ... storage unit, R ... search processing, U ...
Update processing.

Claims (1)

(57) [Claims] 1. A database file including a data storage area composed of at least one storage unit, update program means for requesting update processing and search processing of the storage unit, and search requesting search processing of the storage unit Program means, database update means for updating the storage unit, database search means for searching for the storage unit, at the start of update processing and search processing by the database update means and the database search means for each storage unit From the start to the end of the update process by the database update unit and from the start to the end of the search process by the database search unit. Exclusion that stores the second exclusion identification information indicating the exclusion state If the first exclusion identification information is update-exclusive and search-exclusive, wait until it is released; otherwise, update-exclusive until the end of the update program means. An update exclusion unit that performs update exclusion, and waits until the first exclusion identification information is updated if the exclusion is exclusive, and if the update exclusion is not exclusive, performs a search exclusion until the update program unit ends. If the second exclusion identification information is update-exclusive and search-exclusive, wait until it is released, and if not update-exclusive and search-exclusive, update-exclusive until the end of the update process by the database update unit. A temporary update exclusion unit; if the second exclusion identification information is updated and exclusive, wait until it is released; A temporary search exclusion unit for performing search exclusion until the end of the search processing by the database search unit; and in response to the update request for the storage unit by the update program unit, the update exclusion unit updates the first exclusion identification information of the storage unit. Update exclusion and update exclusion of the second exclusion identification information of the storage unit by the temporary update exclusion unit, update processing of the storage unit by the database update unit, and search request of the storage unit by the update program unit Update control means for performing search exclusion of the storage unit by the database search means by performing search exclusion of the first exclusion identification information of the storage unit by the search exclusion means, and the storage unit by the search program means In response to the search request, the temporary search exclusion means searches and excludes the second exclusive identification information of the storage unit. File exclusive control device, characterized in that it comprises a search control unit that performs a search process of the storage units by said database retrieval means and.