JPH05120347A - File retrieving system - Google Patents

Abstract

PURPOSE:To enable a use retrie data only with logical contents. CONSTITUTION:The real file name, file class and record layout information of a file to be retrieved are obtained from a file definition table and record layout information (file definition retrieval step 1 and layout definition retrieval step 2) and based on these kinds of information, a key record is read (key record reading step 3). It is checked whether the read key record is a desired record to be retrieved or not (retrieval condition judging step 4), and when it is the relevant record, the remaining records of the real file are read (remaining record reading step 5). Items are operated between one and another and rearranged so as to transform the read key record into an output record form (record developing step 6). The steps from the key record reading step 3 to the record developing step 6 are executed concerning all the desired key records to be retrieved (record end judging step 7).

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a file search method when a computer user makes a decision.

[0002]

2. Description of the Related Art In the field of decision support system (DSS), how to retrieve business data in a timely and easy manner is very important.

[0003] Typical uses include a search method using an RDB search tool and a method of creating an application program and searching.

These methods will be described. I. Method of Searching Using RDB (Relational Database) Search Tool Any data registered in the database can be easily searched using the search tool. Recently, it is possible to search different tables as if they were one table by using the SQL language, and it is possible to execute various processes at the time of search. II. Method of creating and searching for application programs This is a method of creating and searching application programs based on the user's environment. With this method, it is possible to retrieve whatever data the user has.

[0005]

In the above-mentioned "method for searching using the RDB search tool", the data storage destination is limited to the RDB, and therefore the index sequential files and files widely used in business are used. There is a drawback that it is very difficult to retrieve the latest information because the sequential files cannot be retrieved directly and the business data must be re-registered in the RDB.

The "method for creating and searching for an application program" requires a considerable amount of man-hours for creating an application program, and the user cannot perform trial and error processing (searching from a different viewpoint). If you try to do this, you will have to create the application program again), and it is difficult to support decision making.

An object of the present invention is to provide a file search method that allows a user to search data only with logical contents.

[0008]

In order to achieve the above object, the file search method of the present invention uses a file definition table containing various information such as the actual file name and file type of each file and the record layout of each file. A file layout definition table that includes a record layout definition table containing information, and a file definition search step that searches the file definition table for the actual file name of the specified file and recognizes the file type; From the layout definition search step, the key record reading step that reads the key record from the file, and whether the read key record is the record that you want to search. Return to the search condition determination step, and if the read key record is the record that you want to search, perform the remaining record reading step that reads the record of the other file linked to the key record, the operation of item comrades and the rearrangement of items. Go to the record expansion step to convert the read key record into the output record format, and determine whether all the key records have been processed. If not, return to the key record reading step and finish. For example, there is an end judgment step for ending the search processing.

[0009]

[Operation] If you specify the file you want to search, you can get the actual file name and file type from the file definition table.
The record layout information of the file is obtained from the record layout definition table. After that, the key record is read from the file, the items of the key record to be searched and the record of the other file are calculated and rearranged to be converted into the output record format.

[0010]

Embodiments of the present invention will now be described with reference to the drawings.

FIG. 1 is a process flow chart of an embodiment of the file search method of the present invention, FIG. 2 is a relationship diagram of a virtual file VAR1 and a real file, FIG. 3 is an expanded view to an output layout, and FIG. 4 is this embodiment. 5 is a diagram showing a file definition table used in FIG. 5, FIG. 5 is a diagram showing a file layout definition table used in this embodiment, and FIG. 6 is a diagram showing a virtual file definition table used in this embodiment.

In this embodiment, the sequential organization file DSS @ S
An example of searching the virtual file VAR1 composed of the EQ1 and the RDB table DSS @ TBL1 will be shown.

In this embodiment, as shown in FIG.
~ 7.

In step 1, the actual file name and file type of the file designated at the time of retrieval are recognized from the file definition table (FIG. 4). In this embodiment, V
Recognize that AR1 is a virtual file.

In step 2, the record layout of the real file searched from the file layout definition table (FIG. 5) and the virtual file layout definition table (FIG. 6) is recognized, and the record layout of the virtual file actually output is also recognized. To do. As shown in FIG. 2, the virtual file VAR1 is a sequential file DSS @ SEQ1.
"Product number", "A store sales", "B store sales", R
DB table DSS @ TBL1 "Product Name", "Total Sales"
It can be seen that it is composed of (Sales of A store of DSS @ SEQ1 + Sales of B store).

In step 3, the actual file is accessed to read the record. In this case, first, the data of the sequential organization file DSS @ SEQ1 is read.

At step 4, it is judged whether or not the read key record satisfies the search condition.

By repeating steps 3 and 4, one corresponding key record is obtained.

In step 5, the value of the "commodity number" of the read key record is set to the sequential file DSS @ TBL.
RDB table DSS @ TB as the key value of "Product No. 1"
The record of L1 is read.

In step 6, the output layout is rearranged as shown in FIG. 3 and the "total sales" is calculated.

In step 7, the sequential file DSS @
It is checked whether all the records of SEQ1 have been read.

By repeating steps 3 to 7, the search for the virtual file VAR1 requested by the user is completed.

The contents of steps 1 to 7 have been briefly described above, and each table will be described in detail. File definition table (FIG. 4) A table used in step 1 to know what the name specified at the time of retrieval corresponds to in the actual file.

Description of field No .: Management number of the file definition table.

File name: A name recognized by the user on the DSS system.

Real file name: This is the actual file name (it has no meaning in a virtual file).

Device name: This is the device name that stores the actual file (it has no meaning in the virtual file).

Type: The type of actual file.

Layout number: the number of the layout definition table (it has no meaning for items having table definition information such as the RDB table).

Reference file number: virtual file →
Referenced real file number In the case of a real file → Referenced virtual file number Link information: When a virtual file refers to multiple real files, it indicates the relationship between the files. File layout definition table (FIG. 5) This is the table used in step 2 and stores the record layout information of the actual file.

Description of field No .: Item number.

Item name: A logical name of a field.

Attribute: The attribute of the field.

Start Position: The physical start position of the field.

* If the start position is omitted during registration, it is automatically assigned from 1. Virtual file layout definition table (FIG. 6) This table is used in step 2 and stores the record layout information of the virtual file.

Description of field Number: Item number.

Item name: A logical name of a field.

Attribute: The attribute of the field.

Calculation formula: Shows where the field corresponds to the actual file (a calculation formula can be written).

* If item names and attributes are omitted during registration,
The information of the actual file is inherited (for example, if the item name of I5 is omitted, the item name becomes “sales sales of A store + sales sales of B store”).

[0041]

As described above, according to the present invention, the system administrator first registers the file information and the record layout information in the file definition table and the record layout definition table. Since it is possible to easily obtain desired information without paying attention to names, attributes, etc., it is effective in the field of decision making in which trial and error are carried out.

[Brief description of drawings]

FIG. 1 is a flow chart of processing of an embodiment of a file search method of the present invention.

FIG. 2 is a relationship diagram between a virtual file VAR1 and a real file.

FIG. 3 is a development view of an output layout.

FIG. 4 is a diagram showing a file definition table.

FIG. 5 is a diagram showing a file layout definition table.

FIG. 6 is a diagram showing a virtual file layout definition table.

[Explanation of symbols]

 1 to 7 steps

Claims (1)

[Claims] 1. A real file name of a specified file, comprising a file definition table containing various information such as the real file name of each file and file type, and a record layout definition table containing record layout information of each file. A file definition search step for searching the file definition table for recognizing the file type, a layout definition search step for searching the file layout definition table for the record layout information of the file, and a key for reading a key record from the file The record read step and the read key record are judged to be the record to be searched. If it is not the record to be searched, the process returns to the key record read step. The search condition judgment step and the read key record are detected. If the record you want to,
The remaining record reading step of reading the record of the other file linked to the key record, and the record expanding step of converting the read key record into the output record format by performing the calculation of items and rearranging items, A file search method having a termination determination step of determining whether or not the processing has been completed for the key record, and returning to the key record reading step if not completed, and ending the search processing if completed.