JPH05334156A - Closing system in data operating instruction - Google Patents

Abstract

PURPOSE:To close a blocked data base during the execution of a data operating instruction. CONSTITUTION:This closing system includes an opening means 108 for a data storing area, a block registering means 103, a block releasing means 104, a block specifying means 102, a block management table 105 storing block information, a block checking means 110 for checking the block of the data storing area by referring to the table 105, and a data operating instruction invalidating means 111 for invalidating a data operating instruction. The system includes also a data base file management file 112 having a bit corresponding to a task in each data storing area and being updated in each starting of the data operating instruction and the means 110, a task checking means 113 for checking whether the blocked data storing area is used for another task or not by referring the table 112, and a closing means 114 for closing the data storing area when the area is used by the other task.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an improvement of a closing method for blocking a data storage area such as a database file.

[0002]

2. Description of the Related Art Data that has a database file, which is an external storage medium, for storing data as data records, divides the database file into a plurality of data storage areas, and searches and updates the database file 2. Description of the Related Art A database processing system that performs search and update processing from a plurality of tasks using operation commands has been conventionally known.

FIG. 5 is a block diagram of a system for implementing a database file closing method according to the prior art. 501 is a terminal for conversation, 502 is a blocking instruction means,
Reference numeral 503 is blockage registration means, 504 is blockage release means, and 505
Is a blockage management table, 506 is a database file,
Reference numeral 507 is a batch application program (hereinafter referred to as a batch AP), 508 is an opening means, 509 is a data operation instruction, 501 is a blockage checking means, 511 is a data operation instruction invalidating means, and 512 is a closing means.

FIG. 2 is a diagram showing an example of the structure of the database file-506, 201 is a data storage area, and 20 is a data storage area.
2 is a data record.

The blockage instructing means-502 is activated by a conversation from the terminal-501. The blockage instructing unit-502 activates the blockage registration unit-503 or the blockage release unit-504 according to the content of the conversation to register or release the blockage in the data storage area-201 of the database file-506. Every time, blockage management table-
505 is updated.

When the batch AP-507 is activated, the data storage area opening means-508 opens the database file-506, and the data operation instruction-509 searches and updates the data storage area-201.

Blocking check means-5 which refers to the blockage management table 505 when the data operation command 509 is executed
It is checked by 10 whether the target data storage area-201 is closed, and if it is closed, the data operation instruction invalidating unit-511 makes this data operation instruction-5
09 is invalidated.

Further, the data operation instruction-509 returns to the batch AP-507 that the data operation was unsuccessful.

At the end of batch AP-507, the closed data storage area-201 is closed and the resources of the data storage area are released.

[0010]

In the above-mentioned conventional technique, when the data storage area forming the database file is closed, all the batch APs of the tasks using the data storage area execute the closing means. Since there is no release of the resource in the data storage area until waiting, the disadvantage is that it takes time from the blockage to the release of the resource.

The present invention has been made in view of the above-mentioned problems, and when the database file is closed, the data operation that enables the execution of the close in the data operation command even during the execution of the batch AP. It is intended to provide an in-command close method.

[0012]

A database file, which is an external storage medium for storing data as a data record, is provided, and the database file is divided into a plurality of data storage areas and search and update processing is performed on the database file. In a database processing system that performs a search and an update process from a plurality of tasks using a data operation instruction to be performed, an open unit that opens a data storage region, and a block registration unit that blocks one data storage region A block release means for releasing the block of the blocked data storage area, a block instruction means for instructing the block registration means or block release means to block the data storage area, and which data storage area is blocked The blocking information indicating whether or not it is stored, and the blocking registration means or blocking release means is activated. At this time, by referring to the blocking management table that is updated each time and the blocking management table, a blocking check unit that checks whether the target data storage area is blocked when the data operation command is executed And a data operation instruction invalidating means for invalidating the data operation instruction for the blocked data storage area,
The task check means for checking whether the blocked data storage area is used by another task using the database file management table, and the data storage area blocked by the task check means is checked by another task. It has a closing means for closing the closed data storage area if it is not used.

Further, each database file has a bit corresponding to a task, and a database file management table that is updated each time the data operation instruction and the blockage checking means are activated, and a value of the bit corresponding to the time when the data operation instruction is executed. True, if the block check means is activated, the bit of the invoking task of the block target database file is set to false, and if all the bits corresponding to the target database file are set to false, it is not used by another task. It has a task check means for judging the above and passing the processing to the closing means.

[0014]

According to the above construction, the database file management table has a bit corresponding to the task for each data storage area of the database file, and is updated each time the data operation instruction and the blockage checking means are activated. The task check unit refers to the database file management table for the data storage area found to be blocked from the block management table reference by the block check unit, and the target data storage area is used by another task. It is determined whether the value of the corresponding bit is true when the data operation instruction is executed. Since the data storage area closing means closes the closed data storage area or if it is not used for another task, the closed data storage area can be closed in the data operation command even during batch AP execution. Becomes

[0015]

An embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram of a closing method within a data operation instruction according to an embodiment of the present invention.

In FIG. 1, database file-1
Opening means-108 for opening 06, and the user registering the block in the database file-106,
Closure instruction means for releasing the terminal-101 and the terminal-101 for instructing whether or not to block the database file-106 to the blocking registration means-103 for blocking or the blocking release means-104 for releasing blocking -102
And the database file 106 stores the blockage information indicating whether the blockage is blocked or not, and the blockage management table updated each time the blockage registration unit 103 or the block release unit 104 is activated. -105
By referring to the blockage management table-105,
When the data operation instruction-109 is executed, a closing check means-110 for checking whether or not the target database file-106 is closed, and a data operation instruction-109 for the closed database file-106. Data operation instruction invalidating means to be invalidated-
111, a database file management table 112 having a bit corresponding to a task for each database file 106 and updated each time the data operation command 109 and the blocking check means 110 are activated, and the blocked database file. -106 is checked by using the database file management table -112 whether it is used in another task, and the value of the corresponding bit at the time of executing the data operation instruction is set to be true, and all the data corresponding to the target database file are checked. Task check means for determining that the bit is false and not used by another task-1
13 and the closed database file-106,
It has a data storage area closing means-114 for closing the closed database file-106 unless it is used by another task.

FIG. 2 shows the structure of the database file 106 used in the present invention. As shown in FIG. 2, the database file 106 has a plurality of data storage areas-2.
The data storage area -201 is composed of a plurality of data records -202.

FIG. 3 shows a batch A in the database processing system using the close method in the data operation instruction of the present invention.
The flowchart of the process example of P-107 is shown. Referring to FIG. 3, when the batch AP-107 is started- (301), the data storage area opening means-108 opens all the data storage areas-201 assigned in task 1- (302), and a data operation command. -By activating 109, the data storage area-201 is searched and updated-
(303).

After the operation of the data operation instruction-109, it is checked whether or not the data operation instruction has an error, and if there is an error, the batch AP-107 ends.
(306).

Further, if there is a data operation command-109 for the data storage area-201- (305), the process returns to the process of 303 again, and the data operation command-109 is issued. If there is no other data operation command, the batch AP-107 ends- (306).

At the end of batch AP-107-306, the closing means-113 is activated for all the data storage areas assigned by batch AP-107- (307), and the resources are released- (308).

FIG. 4 is a flow chart of processing showing the operation -304 of the data operation instruction in FIG. Referring to FIG. 4, at the time of executing the data operation instruction-109, it is checked whether the target data storage area-201 is blocked by the blocking check means-110 that refers to the blocking management table-105- (401)-( 402) If it is blocked, this data operation command-109 is invalidated by the data operation command invalidating unit-111- (403) and an error occurs- (404).

Next, the task check means-112 checks from the database file management table 112 whether there is another task assigned to the blocked data storage area-201- (405)-
(406), if present, data manipulation instruction-109
Ends and returns to the process of 305 in FIG. If it does not exist, specify the blocked data storage area -201,
The closing means-113 is activated to perform the closing- (4
08)-(409).

If not blocked, data storage area-2
Data operation command for 01-109 becomes valid-
(407), the process of 305 of FIG. 3 is performed.

As a result, the database file-10
If there is a closed data storage area-201 in 6, the closed data storage area-201 is conventionally used to close the closed data storage area-201, that is, to release resources. Batch AP-
In the present invention, it is possible to execute the close in the data operation instruction-109 while the batch AP-107 is being executed, instead of having to wait until the end of 107.

[0027]

As described above, according to the present invention, when a blocked database file is detected from a task, the blocked data is stored during execution of the data operation instruction without waiting until the end of the batch AP. Since the area is closed, the time until the resource is released can be shortened.

[Brief description of drawings]

FIG. 1 is a block diagram of a close method within a data operation instruction according to an embodiment of the present invention.

FIG. 2 is a diagram showing a structure of a database file.

FIG. 3 is a flow chart of processing of the embodiment shown in FIG.

FIG. 4 is a flowchart of the processing of the data operation instruction shown in FIG.

FIG. 5 is a configuration diagram of a conventional database file closing method.

[Explanation of symbols]

 101 Terminal 102 Blocking Instructing Unit 103 Blocking Registering Unit 104 Blocking Releasing Unit 105 Blocking Management Table 106 Database File 107 Batch AP 108 Opening Unit 109 Data Manipulation Command 110 Blocking Checking Unit 111 Data Manipulation Command Invalidating Unit 112 Database File Management Table 113 Task Checking Unit 114 Closing means

Claims (2)

[Claims] 1. A data operation command, comprising a database file which is an external storage medium for storing data as a data record, dividing the database file into a plurality of data storage areas, and performing a search / update process for the database file. In a database processing system for performing retrieval and update processing from a plurality of tasks using, an opening means for opening the data storage area, a closure registration means for closing one data storage area, and the closure A block releasing means for releasing the block of the stored data storage area, a block instructing means for instructing the block registering means or the block releasing means whether or not to block the data storage area, and which data storage area is blocked. The blocking information indicating whether or not there is stored, the blocking registration means or the blocking release means. A blocking management table that is updated each time it is activated, and a blocking that checks whether the target data storage area is blocked when a data operation command is executed by referring to the blocking management table Check means, data operation instruction invalidating means for invalidating a data operation instruction for the blocked data storage area, and task check means for checking whether the blocked data storage area is used by another task If the blocked data storage area is not used by another task by the check of the task check means,
And a closing means for closing the closed data storage area. 2. A database file management table that has a bit corresponding to a task for each database file and is updated each time the data operation instruction and the blockage checking means are activated, and a value of the bit corresponding to the execution of the data operation instruction. Is true, when the block check means is activated, the bit of the invoking task of the block target database file is set to false, and when all the bits corresponding to the target database file are set to false, it is used by another task. 2. The data manipulation instruction close method according to claim 1, further comprising task check means for judging that the operation is not performed and passing the processing to the close means.