JP2641399B2 - File management device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a file management apparatus, and more particularly to a file management apparatus for performing exclusive control of file operations for each item constituting a record when one file is used by a plurality of jobs simultaneously.

[0002]

2. Description of the Related Art In a conventional file management apparatus, data input / output processing from a physical file to a program is performed in units of records defined by the program. The entire data was to be passed.

The exclusive control in the physical file update process is also performed on a record basis as described in Japanese Patent Application Laid-Open No. 1-241639.

[0004] However, in the transfer in units of records, item data that is not necessary for processing is also to be transferred every time an input / output instruction is issued, and there is a problem that computer resources are wasted.

[0005] Therefore, in the description of Japanese Patent Application Laid-Open No. 64-64044 and the like, a virtual file composed of records obtained by extracting data of required data items from data items constituting each record from a physical file is described. A file is defined as a logical file, and a method is described in which a user can access the logical file as well as the entity. Further, Japanese Patent Application Laid-Open No. 4-17884
In the technology described in Japanese Patent Application Publication No. 7-107, an exclusive control technology for each item constituting a record is disclosed.

According to the file management apparatus described in Japanese Patent Application Laid-Open No. 4-178847, a storage area of exclusive control information corresponding to each record or each item in the record is automatically generated at the time of new registration of a record, and this area is created. Writing and referencing the information for exclusive control are performed, and based on the information, control of accepting a data update request is performed.

[0007]

The conventional file management apparatus described above automatically generates a storage area for exclusive control information corresponding to each record or each item in the record when a record is newly registered. There is a problem that the storage capacity required for control increases.

As the exclusive control information corresponding to a record or an item in a record, an identifier of a subject of an update request such as a program, a process, or a user updating the record or an item in the record is used. Since there is no information on the subject of the reference request that makes an access that does not require exclusion for the purpose, it is necessary for the action to be taken when there is an update request for the same item in the same record as the item of the record for which the reference access is being made. There is a problem of lack of information.

[0009] An object of the present invention is to create and use a table for storing the identifier of the entity performing reference access or update access, the purpose of the access, the record identifier of the access target, and the item identifier in the record according to the access operation. Accordingly, an object of the present invention is to provide a file management apparatus that can perform efficient exclusive control for each item of a record, improve file use efficiency, and significantly reduce the storage capacity required for exclusive control.

[0010]

According to the present invention, there is provided a file management apparatus, comprising: a file identifier, a record identifier, an item identifier, and a processing type indicating whether an access purpose is a reference request or an update request, based on an external access request; And generating an access exclusion information including a job identifier which is a subject performing the processing, and issuing an exclusion request for each item, generating the access exclusion information in response to an external job processing completion notification from the outside, and generating an access exclusion information for each item. An access exclusion requesting unit that issues an exclusion release request, an item exclusion information storage unit that stores access exclusion information of the item being accessed for each item, and an access exclusion request unit that responds to the exclusion request from the access exclusion requesting unit. Accession of the item if the first is a new item item corresponding to the exclusive request is not stored in the item exclusion information storing means Said scan exclusion information item exclusion information storing means to start the access operation after storing the second item is a said item exclusion information storing an item that is already stored in the unit during the update access corresponding to that lock requests its End waiting notifies, process type reference corresponding to a already and reference access an item stored in the item said item exclusion information storing means corresponding to the exclusive request to that lock requests in the case of In the third case, which is a request, the job identifier corresponding to the exclusive request is additionally stored in the corresponding access exclusive information already stored in the item exclusive information storage means, and the item corresponding to the exclusive request is the item An item that is already stored in the exclusive information storage means, is being accessed for reference, the processing type corresponding to the exclusive request is an update request, and another job is If not being accessed the fourth starts the access operation after changing to the update request from the reference request to process type corresponding access exclusive information already stored in the item exclusion information storing means,
The item corresponding to the exclusion request is an item already stored in the item exclusion information storage means, is being accessed for reference, the processing type corresponding to the exclusion request is an update request, and another job is accessing. In a fifth case, the end wait is notified , and in response to the exclusion release request from the access exclusion requesting unit, the corresponding job identifier of the item corresponding to the exclusion release request is stored in the item exclusion information storage unit.
Items that have been deleted and all jobs being accessed are
Is configured to include a item exclusive control means for deleting said item.

[0011]

[0012]

Next, embodiments of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of a file management apparatus according to the present invention.

As shown in FIG. 1, the file management apparatus 1 of the present embodiment generates access exclusion information based on an external access request to the file 3 and issues an exclusion request for each item. The access exclusion request unit 11 generates the access exclusion request information in response to the job processing completion notification and issues an exclusion release request for each item, and stores the access exclusion information of the item that receives the exclusion request. When an access exclusion request is made for a new item by referring to the item exclusion table storage unit 13 and the item exclusion table storage unit 13 in response to a request from the access exclusion request unit 11, this access exclusion information is registered in the item exclusion table storage unit 13. After that, when the access operation is activated and an access exclusion request is made for the registered item, it is compared with the registered access exclusion information. Performing exclusive control for each item is configured to include a item exclusive control unit 12.

The access exclusion information generated by the access exclusion request unit 11 based on an external access request to the file 3 and the access exclusion release request information generated by the access exclusion request unit 11 in response to a job processing completion notification. Is the file identifier of access target (file name, file management number, etc.), record identifier (record relative number by key item, etc.), item identifier (item name, item relative number in record, etc.) and access purpose is reference request or update The information includes a processing type indicating whether the processing is a request and an identifier (job number or the like) of a job that performs the processing. These pieces of information are included in an external access request or a job processing end notification.

FIG. 2 shows the contents stored in the item exclusion table storage unit 13. The item exclusion table storage unit 13 stores the item exclusion table 1 of the item for which the exclusion request is received.
3-1 to 13-n are stored.

Each item exclusion table is created at the time of a new exclusion request for the item. The contents include a file identifier a, a record identifier b, an item identifier c, and a processing type d indicating whether the access purpose is a reference request or an update request. And job information e of the job that is the subject that performs the processing. This job information column is an area for storing an identifier of a job which is performing processing by accessing this item. When a plurality of jobs access this item, the second and subsequent jobs are excluded from the existing item. It is only necessary to add the job identifier to the job information column of the table.

When the processing of the job being accessed and processed is completed, the identifier of the job is deleted from the item exclusion table, but the job identifier stored in the job information column e has become zero. Sometimes it means that no job has made an exclusion request for that item, so the item exclusion table itself corresponding to this item is deleted.

FIG. 3 is a flowchart showing the exclusion processing operation of the item exclusion control unit 12. The exclusion processing operation of the item exclusion control unit 12 will be described with reference to FIGS.

When the item exclusion controller 12 receives the access exclusion request information as an access request from the access exclusion request unit 11 (step 31), the item exclusion request information includes a file identifier, a record identifier, and an item corresponding to the item identifier in the access exclusion request information. Exclusive table is item exclusive table storage unit 1
3 to see if it has already been stored (step 3
2).

When the corresponding item exclusion table has not been stored in the item exclusion table storage unit 13 (N branch of step 32), a new item exclusion table is created for the item for which the access exclusion request has been made based on the access exclusion request information. Is created and stored in the item exclusion table storage unit 13 (step 35), and then the file writing / reading unit 2 is activated to access required item information in the file 3 (step 36). This is the first case.

When the corresponding item exclusion table is already stored in the item exclusion table storage unit 13 (Y branch in step 32), the processing type of the item exclusion table is checked (step 33), and the update request is issued. When it indicates (Y branch of step 33), the item is being updated and other access is being exclusive, so that the update process ends and the exclusive control is released, and this is notified to the request source. And the process ends (step 34). This is the second case.

In step 33, the item exclusion table storage unit 1
3 is checked, and if it does not indicate an update request, that is, if it is a reference request (N branch of step 33), the processing type of the job requested this time Varies depending on the application.

If the processing type of the job requested this time is a reference request (Y branch in step 37), the item exclusion table stored in the item exclusion table storage unit 13 and corresponding to the requested item is stored in the item exclusion table. The identifier of the requested job is newly written in the job information column (step 3
8). This is the third case.

The requested item data is already read out of the file 3 by a reference request of another job and stored in a main memory or other buffer. Therefore, the actual access to the item data by the current access request is as follows. When this is used, access to the file 3 is not necessary.

Contrary to the above, when the processing type of the job requested this time is not a reference request but an update request (N branch of step 37), the item exclusion table storage unit 13
In the job information column of the item exclusion table corresponding to the item for which the access request has already been stored, it is checked whether or not the identifiers of the jobs other than the currently requested job are registered (step 39). If it is (Y branch of step 39), the update request cannot be updated because another job is in the process of referring to the item requested to be updated this time, and the process waits until the reference process of those jobs is completed. Is notified to the requestor and the processing ends (step 4
2). This is the fifth case.

Unlike the above, the identifiers of the jobs other than the job requested this time are registered in the job information column of the item exclusion table corresponding to the item for which the access request has already been stored in the item exclusion table storage unit 13. If not, that is, if only the identifier of the job requested this time is registered (N branch of step 39), it corresponds to the item for which the access request is already stored in the item exclusion table storage unit 13. Change the process type column of the item exclusion table from the reference process to the update process (step 4
0) After that, the file writing / reading unit 2 is activated to perform the updating process (step 41). This is the fourth case.

In response to the supply of the access exclusion request information generated by the access exclusion request unit 11 in response to the end of the job reference or update process, the item exclusion control unit 12 performs an exclusion release operation for each item.

FIG. 4 is a flowchart showing the exclusion release operation of the item exclusion control unit 12. The exclusion release operation of the item exclusion control unit 12 will be described with reference to FIGS. 1, 2, and 4.

When the item exclusion control unit 12 receives the access exclusion release request information generated in the access exclusion request unit 11 in response to the job reference or update process end notification (step 51), it is stored in the item exclusion table storage unit 13. It is checked whether the identifier of the job other than the job that has requested the release is stored in the job information column of the released item exclusion table (step 52). If the identifier is stored (step 52). (Y branch) Delete only the identifier of the job that has made the release request (step 53), and if it is not stored (N branch of step 52), delete the item exclusion table itself to be released (step 5).
4).

As described above, in the file management apparatus according to the present embodiment, the access exclusion including the identifier of the entity performing the reference access or the update access, the purpose of the access, the record identifier of the access target, and the item identifier in the record. By creating an item exclusion table for storing information according to the access operation and using it for exclusion processing, efficient exclusion control can be performed for each item of the record, and an item in the record is updated. Even if there is a file, the item whose record has not been updated can be referenced and accessed, which has the effect of greatly improving the file use efficiency.

Further, since the item exclusion table is created according to the access operation and deleted at the end of the access processing, the storage capacity required for the exclusion control can be significantly reduced as compared with the related art.

[0033]

As described above, the file management apparatus of the present invention includes the identifier of the entity performing the reference access or the update access, the purpose of the access, the record identifier of the access target, and the item identifier in the record. By creating an item exclusion table that stores access exclusion information according to the access operation and using it for exclusion processing,
Efficient exclusion control can be performed for each item of the record, and even if an item in the record is being updated, items that have not been updated can be referenced and accessed. This has the effect of greatly improving the efficiency of use.

Further, since the item exclusion table is created according to the access operation and deleted at the end of the access processing, the storage capacity required for the exclusion control can be significantly reduced as compared with the related art. .

[Brief description of the drawings]

FIG. 1 is a block diagram showing one embodiment of a file management device of the present invention.

FIG. 2 is a table storage diagram showing storage contents of an item exclusion table storage unit of the file management device of the embodiment.

FIG. 3 is a flowchart illustrating an exclusive control operation for each item of an item exclusive control unit of the file management apparatus according to the embodiment.

FIG. 4 is a flowchart illustrating an exclusion release operation for each item of an item exclusion control unit of the file management apparatus according to the present embodiment.

[Explanation of symbols]

 REFERENCE SIGNS LIST 1 file management device 2 file writing / reading unit 3 file 11 access exclusion control unit 12 item exclusion control unit 13 item exclusion table storage unit 13-1 to 13-n item exclusion table 31 to 42, 51 to 54

Continuation of the front page (56) References JP-A-63-307553 (JP, A) JP-A-63-191248 (JP, A) Makoto Takizawa, "Introduction to Database System Technology" (1991-3-1), Software Research Center, Inc., pp. 185-188, "8.2.1 Lock Calculation"

Claims (1)

(57) [Claims] 1. A file identifier, a record identifier, an item identifier, a processing type indicating whether an access purpose is a reference request or an update request, and a job identifier which is a subject that performs the processing based on an external access request. Access exclusion request means for generating exclusion request for each item by generating access exclusion information including the exclusion request for each item and generating the access exclusion information in response to an external job completion notification from the outside; Item exclusion information storage means for storing, for each item, access exclusion information of an item for which the item is subjected to the exclusion request, and an item corresponding to the exclusion request in response to an exclusion request from the access exclusion request means stores the item exclusion information. The first item that is a new item not stored in the means
There the case of the item item start an access operation after storing an access exclusive information for this item to the item exclusion information storing means, corresponding to the exclusive request is already stored in the item exclusion information storing means in the second case is being updated access notifies the end wait, the lock requests already be active items and is referenced access stored in item the item exclusion information storing means corresponding to the exclusive request In the third case where the processing type corresponding to the request is a reference request, the job identifier corresponding to the exclusive request is additionally stored in the corresponding access exclusive information already stored in the item exclusive information storage means, and the exclusive request is stored. Is an item that is already stored in the item exclusion information storage means, is being accessed for reference, and the processing type corresponding to the exclusion request is updated In the fourth case, where no other job is being accessed, the access operation is performed after the processing type of the corresponding access exclusive information already stored in the item exclusive information storage unit is changed from a reference request to an update request. Activated , the item corresponding to the exclusion request is an item already stored in the item exclusion information storage means, is being accessed for reference, the processing type corresponding to the exclusion request is an update request, and another job is In the fifth case in which the access is in progress, the end exclusion wait is notified, and the item exclusion information storage means responds to the exclusion release request from the access exclusion request means.
From the corresponding job of the item corresponding to the exclusion release request
Deleted identifiers and all jobs being accessed are gone
The file management apparatus, wherein the item includes an item exclusive control unit for deleting the item.