JPH0652021A - File sort access system - Google Patents

Abstract

PURPOSE:To decrease the capacity of a secondary storage device, and also, to prevent a user program from being complicated, in the case of accessing a sort object file in order of plural codes. CONSTITUTION:A sort retrieval table file generating means 16 extracts a key value from each record of a sort object file 41, sorts it in accordance with a sequence of a designated code classification and generates sort retrieval table files 51, 52, .... A fort file opening means 11 opens a sort retrieval table file corresponding to the code classification and the sort object file 41, a sort file reading means 12 obtains a record relative position from the sort retrieval table file corresponding to the code classification and reads out a real record from the sort object file 41, and a sort file closing means 13 closes the sort retrieval table file corresponding to the code classification and the sort object file 41.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an ordered file access method, and more particularly to a file sort access for accessing a file to be sorted consisting of a plurality of records in a plurality of code orders using some fields of each record as keys. Regarding the scheme.

[0002]

2. Description of the Related Art Conventionally, when sorting a file, when a character type field is used as a key, it is common to order files in ascending order, descending order, dictionary order, etc. depending on the code used. To access a file with the target code type when the code types used by the user program are different, create a sorted file that is sorted by each code type in advance, or code to the target code type in the user program. Sorting was done after conversion.

Also, in the case of accessing a remote file, the sorted file is created by sorting in advance by each code type, or the sorting process is performed after the code conversion into the desired code type in the user program. .

[0004]

The above-mentioned conventional file sort access method has the following problems.

If there is a sorted file for each code type, a large amount of secondary storage device capacity is required, and when data changes such as record addition and deletion occur, a plurality of code types are supported. There was a problem that a sorted sorted file had to be rebuilt.

Further, when the sorting is performed after the code conversion in the user program, there is a problem that the user program becomes complicated and a large amount of processing is required at the time of execution to deteriorate the performance.

Further, the code types used by a plurality of computers connected on a network instead of one computer and used by a user program of each computer are JIS code, EBCDIC code, EU.
When different such as C code and MS-JIS code, in order to process in code order, the user program must be aware of the difference in code system, which makes development of the user program difficult. At the same time, the files for the code types are needed, and the above-mentioned problems that occur in one computer are greatly increased.

In view of the above points, it is an object of the present invention to provide a file sort access method in which the capacity of the secondary storage device is small and the user program does not become complicated.

Another object of the present invention is that the capacity of the secondary storage device is small, the user program does not become complicated, and the sorted file is reconstructed even if a record change occurs. It is to provide a file sort access method that does not need to be included.

Further, another object of the present invention is to make the user programs aware of the difference in the code system even when the code types used by the user programs of a plurality of computers connected to the network are different. It is not necessary to provide a file sort access method that eliminates the need for files of the code type.

[0011]

The file sort access method of the present invention is a file sort access method in which a sort target file including a plurality of records is accessed in a plurality of code orders by using some fields of each record as keys. A key value extracted from each record of the sort target file based on a designated key value field position and sorted in accordance with a designated code type order, and a key value together with a record relative position in the sort target file A sort search table file creating means for creating a sort search table file sequentially stored in the file, a sort search table file corresponding to a code type specified in response to a file open request from a user program, and the sort target file. Open The sort file opening means and the record relative position are obtained from the next record corresponding part of the sort search table file corresponding to the code type specified in response to the next record read request from the user program, and the record relative position is obtained from the sort target file. It has a sort file reading means for reading out records, a sort search table file corresponding to a code type designated in response to a file close request from the user program, and a sort file closing means for closing the sort target file.

The file sort access method of the present invention is specified in the file sort access method in which a file to be sorted consisting of a plurality of records is accessed in a plurality of code orders by using some fields of each record as keys. The key value is extracted from each record of the sort target file based on the key value field position, and the key value sorted according to the specified code type order is sequentially stored in the record corresponding part together with the record relative position in the sort target file. Sort search table file creating means for creating a sort search table file, a sort search table file corresponding to a code type specified in response to a file open request from a user program, and a sort file for opening the sort target file. File opening means and the record relative position from the next record corresponding part of the sort search table file corresponding to the code type specified in response to the next record read request from the user program, and the actual record from the sort target file is obtained. A sort file reading means for reading out, a sort search table file corresponding to a code type designated in response to a file close request from the user program, and a sort file closing means for closing the sort target file,
In response to a record addition request from the user program, an additional record is added to the sort target file, and the record corresponding parts of the additional record are sorted and registered in all sort search table files created from the sort target file. Sort file record adding means and delete record deletion from the sort target file in response to a record delete request from the user program, and record correspondence of the delete record from all sort search table files created from the sort target file And sort file record deleting means for deleting a copy.

Further, according to the file sort access method of the present invention, in a computer system in which a file location computer having a file to be sorted consisting of a plurality of records and a remote computer are connected by a network, the number of the files to be sorted from each of the files to be sorted is determined. In a file sort access method in which a certain field is used as a key to access in a plurality of code orders, the remote computer requests the file open with the specified key value field position and the code type used by the user program, A remote sort file access means for transferring a next record read request, a file close request, a record addition request and a record deletion request to the file location computer is provided, and the file location computer is The key value is extracted from each record of the sort target file based on the selected key value field position, and the key value sorted according to the order of the specified code type is sequentially transferred to the record corresponding part together with the record relative position in the sort target file. Sort search table file creating means for creating a stored sort search table file, and remote sort file request accepting means for receiving a request from the remote sort file access means and distributing it to various sort file access means and returning the result. A sort search table file corresponding to a code type designated in response to a file open request transferred from the remote sort file access means and a sort file open means for opening the sort target file; and the remote sort file. The sort for reading the actual record from the sort target file by obtaining the record relative position from the next record corresponding part of the sort search table file corresponding to the code type designated in response to the next record read request transferred from the access means. A file read means, a sort search table file corresponding to a code type designated in response to a file close request transferred from the remote sort file access means, and a sort file close means for closing the sort target file; In response to the record addition request transferred from the sort file access means, an additional record is added to the sort target file and the record of the additional record is added to all sort search table files created from the sort target file. Sorting file record adding means for sorting and registering the corresponding portions, and deleting deleted records from the sorting target file in response to a record deletion request transferred from the remote sorting file access means, and creating from the sorting target file. And a sort file record deleting means for deleting the record corresponding part of the deleted record from all the sorted search table files.

[0014]

In the file sort access method of the present invention, the sort search table file creating means extracts the key value from each record of the file to be sorted based on the designated key value field position and sorts according to the designated code type order. Create a sort search table file that sequentially stores the selected key values together with the record relative position in the file to be sorted in the record corresponding part, and the sort file open means is the code specified in response to the file open request from the user program. Opens the sort search table file and sort target file corresponding to the type, and the sort file read means corresponds to the next record of the sort search table file corresponding to the code type specified in response to the next record read request from the user program. From the department The actual record is read from the sort target file by obtaining the code relative position, and the sort file closing means closes the sort search table file and the sort target file corresponding to the code type specified in response to the file close request from the user program. .

Further, in the file sort access method of the present invention, the sort search table file creating means extracts the key value from each record of the file to be sorted based on the designated key value field position, and the order of the designated code type. According to the file open request from the user program, the sort file open method is specified by creating the sort search table file in which the key values sorted according to The sort search table file corresponding to the code type and the sort target file are opened, and the sort file read means selects the next file of the sort search table file corresponding to the code type specified in response to the next record read request from the user program. record The actual record is read from the sort target file by obtaining the record relative position from the response part, and the sort file closing means and sort target table file and sort target file corresponding to the code type specified in response to the file close request from the user program. And the sort file record adding means adds the additional record to the sort target file in response to the record add request from the user program, and supports the record of the added record to all sort search table files created from the sort target file. Sort and register the parts, and the sort file record deletion means deletes the deleted records from the sort target file in response to the record deletion request from the user program, and all sort files created from the sort target file. To delete a record corresponding portion of the deleted records from the search table file.

Further, in the file sort access method of the present invention, the remote sort file access means of the remote computer places a designated key value field and a file open request containing the code type used by the user program, and the next record. A read request, a file close request, a record addition request, and a record deletion request are transferred to the computer in which the file is located, and the sort search table file creation means of the computer in which the file is located selects from each record of the file to be sorted based on the specified key value field position. Create a sort search table file in which key values are extracted and sorted according to the order of the specified code type, and the key values are sequentially stored in the record corresponding part together with the record relative position in the sort target file.
The remote sort file request accepting means receives the request from the remote sort file access means, distributes it to various sort file access means, returns the result, and the sort file open means transfers the file open request transferred from the remote sort file access means. The sort search table file and the sort target file corresponding to the code type specified according to are opened, and the code type specified according to the next record read request transferred from the remote sort file access means by the sort file read means. File that has the relative record position obtained from the next record corresponding part of the sort search table file corresponding to, and reads the actual record from the sort target file, and the sort file closing means has been transferred from the remote sort file access means. Rose The sort search table file and the sort target file corresponding to the code type specified in response to the request are closed, and the sort file record adding means is the sort target file in response to the record addition request transferred from the remote sort file access means. In addition to adding the additional record to, the record corresponding part of the additional record is sorted and registered in all sort search table files created from the sort target file,
The sort file record deletion means deletes the deleted record from the sort target file in response to the record deletion request transferred from the remote sort file access means, and deletes the record of the deleted record from all sort search table files created from the sort target file. Delete the corresponding part.

[0017]

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

FIG. 1 is a block diagram showing the configuration of a computer system to which a file sort access method according to an embodiment of the present invention is applied. In this computer system, a sort file location computer 1 and a remote computer 2 are connected via a network 3, and a sort file location computer 1 is connected to a secondary storage device 4.

The sort file location computer 1 has a sort file opening means 11, a sort file reading means 12, a sort file closing means 13, a sort file record adding means 14, a sort file record deleting means 15, and a sort search table. File creating means 16 and remote sort file request receiving means 1
And 7 are included.

A file 41 to be sorted, a sort search table file corresponding to the code type, that is, a sort search table file 51 of JIS code, a sort search table file 52 of EBCDIC code, ... Are placed on the secondary storage device 4. .

The remote computer 2 comprises a remote sort file access means 21.

User files 18 and 22 exist on the sort file location computer 1 and the remote computer 2, respectively, and sort files (sort target file 41 and sort search table file 51,
52, ... Are collectively referred to. The same applies hereinafter).

Referring to FIG. 2, each sort search table file 51, 52, ...
1, a sort target file name field 202, a header section having information such as a sort type field 203 for each key such as ascending order, descending order, dictionary order, etc., and an unused / unused identification field 2
04, record relative position field 205, and key value fields 206 and 207.

Next, the operation of the file sort access method of the present embodiment thus constructed will be described.

(1) First, the creation of sort search table files 51, 52, ... Will be described.

The user uses the sort search table file creating means 16 in advance to sort the file names to be sorted, an arbitrary field position (hereinafter referred to as a key value field position) to be a key value field of each record, and an ascending order, Sort type such as descending order, dictionary order, JIS code, E
A code type such as a BCDIC code is designated to instruct creation of a sort search table file.

Sort search table file creating means 16
Creates a sort search table file having a file name in which the sort target file name, key value field position, sort type and code type are arranged. Specifically, the sort search table file creating means 16 sorts the sort target file 41 based on the designated key value field position.
Sort search table files 51, 5 in which key values are extracted from the respective records and sorted in the order of the specified code type, and the key values are sequentially stored in the record corresponding part together with the relative positions of the records in the sort target file 41.
Create 2, ...

FIG. 1 shows a state in which a JIS code sort search table file 51, an EBCDIC code sort search table file 52, and the like are created.

(2) Next, the file access operation of the user program 18 in the sort file location computer 1 will be described.

When accessing the sort file, the user program 18 transfers a file open request to the sort file opening means 11 together with the sort target file name, sort type and code type.
Hereinafter, description will be given assuming that the JIS code is specified as the code type.

Upon receiving the file open request, the sort file open means 11 causes the sort search table files 51, 52, ... Stored in the secondary storage device 4, the sort target file name field 202, the sort type field 203 and the code type. By referring to the field 201, it is checked whether or not there is a sort search table file having the corresponding sort target file name, sort type and code type, and if there is not, a file open failure is notified to the user program 18. When there is a sort search table file (hereinafter referred to as a sort search table file 51) having the corresponding sort target file name, sort type and code type, the sort file opening means 11 causes the sort target file 4 to be sorted.
1 and sort search table file 51 are opened,
The user program 18 is notified of the successful opening of the file.

When the user program 18 issues a next record read request after opening the sort target file 41 and the sort search table file 51, the sort file read means 12 causes the sort search table file 5 to be read.
The record corresponding portion of No. 1 is sequentially accessed, and the real record indicated by the record relative position field 205 of each record corresponding portion is read from the sort target file 41, and the code type of the real record and the code type requested by the user are different. For example, the code is converted and returned to the user program 18. However, at this time, if the used / unused identification field 204 of the record corresponding part is unused, the sort file read means 12 skips this record corresponding part and uses the next record corresponding part to determine whether the actual record Read.

When the access to the sort file is stopped, the user program 18 issues a file close request to the sort file closing means 13 by instructing the sort target file name, sort type and code type.

Upon receiving the file close request, the sort file close means 13 causes the sort target file name field 202 and the sort type field 203 of the sort search table file 51 stored in the secondary storage device 4.
And the code type field 201 to check whether or not there is a sort search table file having the corresponding sort target file name, sort type and code type, and if there is not, notify the user program 18 of file close failure. To do. When there is a sort search table file 51 having the corresponding sort target file name, sort type, and code type, the sort file closing means 13 closes the sort target file 41 and the sort search table file 51, and performs the sort search. Forget the relative position of the record corresponding part in the table file 51.

When the user program 18 requests the addition of a record, the sort file record adding means 14
After adding the record to the end of the sort target file 41, the sort search table file creating means 16 is called to add the record corresponding part of the additional record to all sort search table files 51, 52, ... Created from the sort target file 41. Sort and add.

When the user program 18 requests record deletion, the sort file record deletion means 15
The key-value fields 206, 207, ...
Then, the used / unused identification field 204 of the corresponding record corresponding part is set to the unused state. Also, the used / unused identification of the record corresponding parts of all the remaining sorted search table files having the record relative position field 205 having the same value as the record relative position field 205 of the record corresponding part of the unused / used identification field 204 which is made unused The field 204 is set to the unused state.

(3) Next, a file access operation from the user program 22 in the remote computer 2 will be described.

When accessing the sort file, the user program 22 on the remote computer 2 requests a file open request to the remote sort file access means 21 together with the sort target file name, sort type and code type.

The remote sort file access means 21 is
When a normal file open request is received, a communication path is established between the file sort computer 1 and the remote sort file request accepting means 17, and the file open request is sent to the remote sort file together with the sort target file name, sort type and code type. The request is transferred to the request receiving means 17.

Remote sort file request acceptance means 17
Transfers the received file open request to the sort file open means 11.

When the sort file opening means 11 receives the file opening request from the remote sort file request accepting means 17, the sort target file 41 is processed in the same manner as the request from the user program 18 in the own computer 1.
Then, the sort search table file 51 is opened, and the result is returned to the remote sort file request acceptance means 17.

Remote sort file request acceptance means 17
Transfers the returned result to the remote sort file access means 21.

Similarly, a next record read request, a file close request, a record addition request and a record deletion request from the user program 22 are also transferred from the remote sort file access means 21 to the remote sort file request acceptance means 17, and the sort file read is performed. Means 12, sort file closing means 13, sort file record adding means 14, and sort file record deleting means 1
It is distributed to 5 and processed.

The result is transferred to the remote sort file request accepting means 17, returned to the remote sort file access means 21 on the remote computer 2, and notified to the user program 22.

[0045]

As described above, according to the present invention, a sorted search table file having only necessary information such as a key value is created instead of creating a sorted file for each code type. Even if there are many kinds of codes, there is an effect that the sort file can be accessed in the order of a plurality of codes without requiring a large capacity of the secondary storage device. In addition, when a record is added, only the sort search table file is updated without changing the original sort target file, so that there is an effect that it can be processed at high speed. Further, since the sort search table file is not even rebuilt when the record is deleted, there is an effect that high speed processing is possible.

Further, since the sorting process is not performed in the user program, there is an effect that the user program is not complicated and performance is not deteriorated due to a large amount of processing required at the time of execution. is there.

Particularly, in remote file access on the network, the user program does not need to be aware of the difference in the code system between the computers, so that the user program can be easily developed and the code can be easily developed. There is an advantage that files for each type are not needed.

[Brief description of drawings]

FIG. 1 is a block diagram showing the configuration of a computer system to which a file sort access method according to an embodiment of the present invention is applied.

FIG. 2 is a diagram exemplifying the contents of a sort search table file in FIG.

[Explanation of symbols]

 1 Sort File Location Computer 2 Remote Computer 3 Network 4 Secondary Storage Device 11 Sort File Opening Means 12 Sort File Reading Means 13 Sort File Closing Means 14 Sort File Record Adding Means 15 Sort File Record Deleting Means 16 Sort Search Table File Creating Means 17 Remote sort file request acceptance means 18,22 User program 21 Remote sort file access means 41 Sort target file 51,52 Sort search table file 201 Code type field 202 Sort target file name field 203 Sort type field 204 Unused identification field 205 Record relative position field 206, 207 Key value field

Claims (3)

[Claims] 1. In a file sort access method in which a file to be sorted consisting of a plurality of records is accessed in a plurality of code orders by using some fields of each record as keys, the sorting is performed based on a designated key value field position. Create a sort search table file in which key values are extracted from each record of the target file and sorted according to the specified code type order, and the key values are sequentially stored in the record corresponding part together with the record relative position in the sort target file. Sort search table file creating means, sort search table file corresponding to a code type designated in response to a file open request from a user program and sort file opening means for opening the sort target file; and the user program Sort file read means for reading a real record from the sort target file by obtaining a record relative position from the next record corresponding part of the sort search table file corresponding to the code type designated in response to the next record read request from A file sort access method comprising: a sort search table file corresponding to a code type designated in response to a file close request from a user program; and sort file closing means for closing the sort target file. 2. In a file sort access method in which a file to be sorted consisting of a plurality of records is accessed in a plurality of code orders using some fields of each record as keys, the sorting is performed based on a designated key value field position. Create a sort search table file in which key values are extracted from each record of the target file and sorted according to the specified code type order, and the key values are sequentially stored in the record corresponding part together with the record relative position in the sort target file. Sort search table file creating means, sort search table file corresponding to a code type designated in response to a file open request from a user program and sort file opening means for opening the sort target file; and the user program Sort file read means for reading a real record from the sort target file by obtaining a record relative position from the next record corresponding part of the sort search table file corresponding to the code type designated in response to the next record read request from A sort search table file corresponding to a code type specified in response to a file close request from a user program and a sort file closing means for closing the sort target file; and a sort file closing unit in response to a record addition request from the user program. Sort file record adding means for adding an additional record to the sort target file and sorting and registering record corresponding parts of the additional record in all sort search table files created from the sort target file; Sort file record deleting means for deleting the deleted record from the sort target file in response to a record delete request from the RAM and deleting the record corresponding part of the deleted record from all sort search table files created from the sort target file. A file sort access method comprising: 3. A computer system in which a file location computer including a sort target file composed of a plurality of records and a remote computer are connected by a network, and the sort target file is divided into a plurality of fields by using some fields of each record as keys. In the file sort access method for accessing in code order, the remote computer includes a file open request, a next record read request, a file close request, which includes a specified key value field position and a code type used by a user program,
A remote sort file access means for transferring a record addition request and a record deletion request to the file resident computer is provided, and the file resident computer has a key value from each record of the sort target file based on a designated key value field position. A sort search table file creating means for creating a sort search table file in which the key values sorted according to the order of the specified code type are sequentially stored in the record corresponding part together with the record relative position in the sort target file; Remote sort file request accepting means for receiving a request from the remote sort file access means and distributing the result to various sort file access means and returning the result; and a file open request transferred from the remote sort file access means. A sort search table file corresponding to the code type designated in accordance with the sort file opening means for opening the sort target file, and a code designated in response to the next record read request transferred from the remote sort file access means. Sort file read means for reading the actual record from the sort target file by obtaining the record relative position from the next record corresponding part of the sort search table file corresponding to the type, and the file close request transferred from the remote sort file access means A sort search table file corresponding to the code type specified according to the sort type, and a sort file closing means for closing the sort target file; and a record addition request transferred from the remote sort file access means. Sorting file record adding means for adding and registering additional records to the sort target file according to the above, and sorting and registering record corresponding parts of the additional records in all sort search table files created from the sort target files; In response to the record deletion request transferred from the sort file access means, the deleted record is deleted from the sort target file and the record corresponding part of the deleted record is deleted from all sort search table files created from the sort target file. A file sort access method comprising: a sort file record deleting means.