JP2843748B2 - Exclusive control method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention performs exclusive control in the case where a plurality of programs simultaneously search / update a data record in a data file (for example, a database file) in units of blocks, which are a set of data records. Related to the exclusive control method.

[0002]

2. Description of the Related Art Conventionally, in this kind of exclusive control system, FIG.
The following exclusive control has been performed by the components shown in FIG.

[0003] Data record search / update means 32 in a certain program (such as a business application program)
Is a data file (database) to be subjected to exclusive control based on user-specified information 31 (information including information specifying a data record to be processed and information indicating processing content ("search" or "update")). A search / update process (search process or update process) is performed on the data records in the file 35).

Here, when such a search / update process is performed, the data record search / update unit 32 calls the exclusive control unit 33 under the control of the operating system.

[0005] The exclusive control means 33 includes the exclusive information storage means 3
4 includes a data record to be processed (hereinafter referred to as a “processing target block”) based on the exclusion information for each block (such as information indicating the exclusion status of the block (whether or not locked) or the like). ) Is locked by another program (a program other than the program having the data record search / update means 32) (whether or not it is in an exclusive state).

When the exclusive control unit 33 determines that "the block to be processed is not locked by another program", the exclusive control unit 33 causes the data record search / update unit 32 to perform a search / update process.

If the exclusive control means 33 determines that the block to be processed is locked by another program, the exclusive control means 33 searches the data record search / update means 32 after unlocking the other program. / Update processing is performed.

[0008]

In the above-described conventional exclusive control system, when the search / update processing of the data record for the same block by a plurality of programs conflicts, the data record in the block is accessed first. Since the processing relating to the program is performed with priority, even if the processing relating to the following program has urgency (should be given priority), the processing of the preceding program is started after the processing relating to the preceding program is started. However, there is a drawback that the processing related to the subsequent program is kept waiting until the lock is released. That is, there is a disadvantage that the performance of the urgent program is deteriorated.

In view of the above, it is an object of the present invention to determine the priority of each of a plurality of programs for searching / updating data records in the same block (priority of processing related to exclusive control), and to determine the priority. Even if a high-level program (a program with urgency) is a succeeding program, an exclusive control method is provided that realizes exclusive control without deteriorating the performance of the urgent program by giving priority to processing of the program. Is to do.

As a prior art relating to exclusive control on scheduling of competing resources, Japanese Patent Laid-Open Publication No.
No. 288235 (exclusive control method for computer resources). However, this prior art is an exclusive control relating to scheduling of a conflicting resource between a program or a task in a waiting state, and a program in which processing is already started (preceding program) and a program in a waiting state (successive program). The present invention, which is a technique relating to exclusive control between the present invention and the present invention, is different from the present invention in its configuration, viewpoint, and the like.

[0011]

An exclusive control method according to the present invention is an exclusive control method in an information processing system in which a data record stored in a data file is searched / updated by a plurality of programs. Priority storage means for storing the priority of each program reflecting the priority update information; exclusive information storage means for storing exclusive information for each block in the data file; and data in the data file based on user-specified information. Data record search / update means for performing record search / update processing and storing the pre-update record image in the journal file when the data record update processing is performed, and data indicated by the judgment point information in the user specification information When processing for the number of records is completed, And an exclusive release wait determining means for determining whether or not there is a release waiting program.If the exclusive release waiting determining means determines that a release waiting program exists, the exclusive release waiting program and the control target program Priority determination means for determining which one should be given priority based on the priority stored in the priority storage means, and the priority determination means has determined that "priority should be given to the release waiting program". In the case, the transaction backout means for returning the pre-update record image of the data record updated by the control target program from the journal file to the data file, and the data record retrieval / update means are called by the exclusive information storage means. Remembered Using the determination result of the exclusive information and said priority determining means and an exclusive control means for performing exclusive control of the data file in blocks.

[0012]

Next, the present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of an embodiment of an exclusive control system according to the present invention.

The exclusive control method according to the present embodiment includes a user specification information 1, a data record search / update means 2, a priority storage means 3, an exclusive control means 4, an exclusive information storage means 5, an exclusive release wait state, Determination means 6, priority determination means 7, transaction backout means 8
, Journal file 9 and database file 1
0 (data file subject to exclusive control). Here, the data record search / update means 2 is a means present in each of a plurality of programs for performing search / update processing on the database file 10. Means indicated by reference numerals 3 to 9 are means under the control of the operating system of the information processing system regarding the database file 10. In addition,
The user designation information 1 is information designated by a user of the program or the like.

FIG. 2 is a flowchart showing the processing of the exclusive control system according to the present embodiment. This processing includes a user designation information input step 201 and a priority update step 202
An exclusive state inquiry step 203, an exclusive state determination step 204, a data record search / update processing step 205, a determination time hit / fail determination step 206,
It includes a release waiting program presence / absence determination step 207, a priority comparison step 208, a pre-update record image write back step 209, a release waiting program lock step 210, and a control target program lock step 211.

Next, the operation of the exclusive control system of the present embodiment configured as described above will be described.

In the course of processing a program having the data record search / update means 2 (hereinafter referred to as a control target program), when a search / update process of a data record in the database file 10 becomes necessary, a user of the control target program is required. The user designation information 1 is designated by such as (the user designation information 1 is inputted by the data record search / update means 2, the priority storage means 3, and the exclusion release wait determination means 6) (step 201).

The user specification information 1 includes information for specifying a data record to be processed, information indicating the processing content ("search" or "update"), priority update information,
And judgment point information. This embodiment corresponds to the second aspect of the present invention, and the user-designated information 1
It is assumed that the judgment time information in the middle is the number of data records (when the processing for the number of data records is completed, the judgment is made by the exclusion release wait judgment means 6). Incidentally, the determination time information in the invention described in claim 1 may be information other than the number of data records such as elapsed time.

The priority storage means 3 stores in advance the priority of each program (priority of processing relating to exclusive control), but updates the priority of the program to be controlled based on the priority update information in the user designation information 1. (Step 202). In addition,
If the priority update information indicates “update unnecessary”, the process of step 202 is not performed.

The data record search / update means 2 searches / updates a plurality of data records in a certain block in the database file 10 based on the user designation information 1 (one data record at a time). Repeat the process). At this time, the data record searching / updating unit 2 calls the exclusive control unit 4 and executes a block including a data record group to be processed (hereinafter, “block to be processed”).
Is inquired of the exclusive control means 4 as to whether or not the program is locked by another program (a program other than the program to be controlled) (step 20).
3).

The exclusion control means 4 controls the exclusion information for each block stored in the exclusion information storage means 5 ("information indicating the exclusion state of the block" and "waiting for the lock on the block to be released". It is determined whether or not the processing target block is locked by another program on the basis of information having "information specifying a program" (step 204).

If the exclusive control means 4 determines in step 204 that the block to be processed is locked by another program, it waits until the lock on the block to be processed is released (at a fixed time interval). The determination in step 204 is repeated).

Further, the exclusive control means 4 executes step 204
If it is determined that "the lock is not locked by another program", the control to lock the processing target block for the control target program is performed, and the data record search /
The updating means 2 performs a search / update process of one data record (step 205). Note that the data record search / update means 2 stores the pre-update record image (contents of the data record to be processed before the update) in the journal file 9 when the data record is updated.

When the search / update processing of one data record by the data record search / update means 2 is completed, the exclusion release wait judging means 6 counts the number of data records designated by the judgment time information in the user designation information 1. It is determined whether or not the minute processing has been completed (whether or not it is time to make the determination in step 207) (step 206).

The exclusion release wait determination means 6 determines in step 20
If it is determined in step 6 that "the processing for the specified number of data records has not been completed", it is recognized that the point in time at which the determination in step 207 has not been reached is reached, and step 20
5 (the data record search / update means 2 performs search / update processing of the next one data record).

The exclusion release wait determination means 6 determines in step 20
If it is determined in step 6 that "the processing for the specified number of data records has been completed", the other programs (in the waiting state for the lock on the processing target block based on the exclusive information in the exclusive information storage means 5) are released. Hereafter, it is determined whether or not a “release waiting program” exists (step 207). This determination (determination as to whether or not a release waiting program exists) in the first aspect of the invention is
The determination is performed at a predetermined time according to the content of the determination time information.

The exclusion release wait judging means 6 executes Step 20
If it is determined in step 7 that "there is no release waiting program", the control returns to step 205.

On the other hand, if it is determined in step 207 that "there is a release waiting program", the exclusion release wait determination means 6 passes control to the priority determination means 7.

The priority determination means 7 compares the priority of the release waiting program stored in the priority storage means 3 with the priority of the program to be controlled, and determines which program should be given priority. (Step 208).

The priority judging means 7 determines in step 2
If it is determined in 08 that “the priority of the control target program is higher than the priority of the release waiting program (the control target program should be given priority)”, the control is returned to step 205.

The priority judging means 7 determines in step 2
If it is determined in step 08 that the priority of the release waiting program is higher than the priority of the control target program (the release waiting program should be given priority), the transaction backout means 8 and the exclusive control means 4 give.

The transaction backout means 8
The pre-update record image output to the journal file 9 by the data record search / update means 2 is written back to the database file 10 (step 20).
9). In addition, the exclusive control unit 4 releases the waiting state of the processing target block of the release waiting program and performs control to lock the processing target block for the release waiting program (step 210). As a result, the processing related to the urgent release waiting program can be prioritized over the processing related to the control target program.

When the exclusive control means 4 completes the processing for the processing target block by the release waiting program,
Control is performed to lock the processing target block for the control target program (step 211), and the data record searching / updating means 2 performs the search / update processing of the data record in the processing target block again (step 20).
5).

Although not shown in FIG. 2, when all the "data record search / update processing" to be performed is completed, the data record search / update means 2 ends the processing shown in FIG. .

[0035]

As described above, according to the present invention, the exclusive control between the control target program and the release waiting program is performed based on the priority, etc., so that the processing related to the urgent program is preferentially operated. This has the effect that the processing performance of the urgent program is not deteriorated.

Specifically, for example, when an online business application program and a batch job program that access the same database file are running, the priority of the online business application program is set higher than the priority of the batch job program. If this is done, the online business application program runs preferentially, so that there is an effect that the performance of the online business application program does not deteriorate.

[Brief description of the drawings]

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

FIG. 2 is a flowchart showing processing of the exclusive control method shown in FIG.

FIG. 3 is a block diagram showing a configuration of an example of a conventional exclusive control method.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 User specification information 2 Data record search / update means 3 Priority storage means 4 Exclusive control means 5 Exclusive information storage means 6 Exclusion release waiting judgment means 7 Priority judgment means 8 Transaction backout means 9 Journal file 10 Database file

Claims (1)

(57) [Claims] 1. An exclusive control method in an information processing system in which a data record stored in a data file is searched / updated by a plurality of programs, wherein priority of each program is reflected by reflecting priority update information in user-specified information. Priority storing means for storing; exclusive information storing means for storing exclusive information for each block in the data file; searching / updating data records in the data file based on user-specified information; A data record search / update means for storing a pre-update record image in a journal file when an update process is performed, and a release wait when the processing for the number of data records indicated by the judgment time information in the user specification information is completed. Whether the program exists Exclusion release wait determining means for determining whether the elimination wait waiting program or the control target program should be prioritized when the exclusion release wait determining means determines that "there is a release waiting program". The priority determination means for determining based on the priority stored in the priority storage means, and when the priority determination means determines that "the program waiting for release should be given priority", the priority is updated by the program to be controlled. A transaction backout unit for returning a pre-update record image of the data record from the journal file to the data file; an exclusive information and a priority determination which are called from the data record search / update unit and stored in the exclusive information storage unit. An exclusive control means for performing exclusive control on the data file in units of blocks using the determination result of the setting means.