JPH04230576A - Method for retrieving record - Google Patents

Abstract

PURPOSE:To extract the only required record from a retrieval objective file even when data which is not contained in the record of a retrieval objective file is specified as the retrieval objective. CONSTITUTION:A disk device 16 is provided with a merchandise stock management file containing data being 1:1 for each record of this file as well as a merchandise master file. When a code address (the name of merchandise) is turned to be a retrieval condition and the number of stocks an extraction condition, a record retrieval device 15 retrieves the merchandise master file based on the retrieval condition, and a record retrieval device 19 retrieves the merchandise stock management file based on this retrieval result and the extraction condition. As this result from among each record in the merchandise master file corresponding to the code address, the only record matched with the number of stocks are extracted from the merchandise master file.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a record search method for an office computer, etc., which searches a data file to be searched for a record matching the search condition when a record search condition is specified.

0002

2. Description of the Related Art Conventionally, data files such as product sales files and inventory files are stored in an external storage device such as an office computer, and when a desired file is specified using a keyboard and record search conditions are input, Records matching the search conditions are read from the data file specified as the search target. For example, if you specify "Sales amount is 1,000 yen or more" or "Sold quantity is 10 or more" as record search conditions for a product sales file, the fields corresponding to the sales amount and the number of sold items in a record consisting of multiple fields can be searched. A search is performed, and only records that match the search conditions are read from the product sales file.

0003

[Problem to be Solved by the Invention] However, the ability to specify search conditions is based on the premise that the search target field is included in the record, and inventory data is included in each record that makes up the product sales file. If not, it will not be possible to search for the desired record even if "inventory" is specified as a search condition. In such cases, conventionally, the record format of the product sales file that is designed in the system is changed in advance and a field for inventory data is added to each record, but changing the record format is extremely difficult. Furthermore, if the record format is changed, the processing program must also be changed, which is even more difficult. Therefore, even if data that is not included in the records of the search target file is specified as the search target, if only the desired records can be extracted from the search target file, there is no need to change the record format of the search target file, which is extremely It is clear that it will be effective. An object of the present invention is to enable only desired records to be extracted from the search target file even if data not included in the records of the search target file is specified as the search target.

0004

[Means for Solving the Problems and Their Effects] The means and effects of the present invention are as follows. In a record search device that searches for records that match the search conditions from a data file to be searched when a record search condition is specified, this record search device includes, in addition to the data file, information that corresponds to each record in this data file. An associated file comprising at least data related thereto is provided. For example, a file related to the product master file is a product inventory management file. Now, it is assumed that the data file is a product master file, the related file is a product inventory management file, and record extraction conditions are specified in addition to record search conditions (step A in FIG. 1). Note that record extraction conditions are a form of record search conditions, but record search conditions are a concept for data files, and record extraction conditions are a concept for related files.To distinguish between the two, record search conditions for related files are These are called record extraction conditions. In this way, when record extraction conditions are specified in addition to record search conditions, first, the product master file is searched based on the record search conditions (step B in FIG. 1). Now, if you enter the abbreviation of a product name as a search condition, the product master file will be searched for records that correspond to the abbreviation. Next, the product inventory management file is searched based on this search result and the record extraction conditions (step C in FIG. 1). In this case, the product inventory management file is searched using the product master file search results (target products corresponding to the abbreviations). At this time, if the record extraction condition is to extract only records in which the stock quantity of the target product is "1" or more, then among the records in the product master file that match the record search condition (abbreviation), the record extraction condition (Number of stock
Only the records corresponding to the data (inventory data) in the inventory management file that match ``1'' or higher) are extracted from the product master file. Therefore, even if data that is not included in the records of the search target file is specified as the search target, only the desired records can be extracted from the search target file.

[0005]

[Embodiment] An embodiment will be described below with reference to FIGS. 2 to 5. FIG. 2 is a block diagram of the record search device. In this embodiment, when entering a relatively redundant proper noun such as a product name, in order to simplify the input process, it is possible to enter an abbreviation. , the input abbreviation data is sent to the CPU 12
After being captured in the CRT via the display control device 13,
The data is displayed and output from the display device 14 and is also passed to the record search device 15 .

[0006] The record search device 15 is a disk device 16.
1 record corresponding to the abbreviation from the search target file in
The screen is read and each record is passed to the condition determination device 17. The condition determination device 17 refers to the definition table memory 18 and determines whether the record from the record search device 15 matches a search condition arbitrarily set in the definition table memory 18 at the time of system design or the like. Here, if the search condition specifies that another file should be referred to, an index request is issued to the record index device 19, and the index results are received from the record index device 19 and evaluated. As a result, the condition determination device 17
If the record matches the conditions, the corresponding record is transferred to the record buffer 20, but if a mismatch is detected, the next record is requested from the record search device 15.

The record control device 21 receives an EOF (end of file) when one screen worth of records is transferred into the record buffer 20 or from the disk device 16.
When the information is read out, the contents of the record buffer 20 are given to the display control device 13 via the CPU 12 in response to the information from the condition determination device 17, and the contents are displayed on the CRT display device 14. In this case, the data in the record buffer 20 is displayed and output according to the display format preset in the definition table memory 18. Also,
The record control device 21 controls the selection device 2 via the CPU 12.
Start 2.

The selection device 22 performs processing in accordance with the operation of the enter key, next page key, and previous page key on the keyboard 11, and selects any one of the record groups for one screen displayed as candidates on the CRT screen. When the cursor is placed on a record and the confirmation key is operated, the record is selected as a confirmation record, and this selection information is provided to the importing device 23 via the CPU 12. When selecting such a confirmed record, if the next page key is operated, the contents of the next page (a group of records for one screen) will be switched and displayed on the CRT screen, and if the previous page key is operated. , the contents of the previous page (a group of records for one screen) are switched and displayed.

The importing device 23 converts data (for example, product name) in the confirmed record to be imported from the record buffer 20 into a CP based on the selection information from the selection device 22.
A request is made to the record control device 21 via U12, and when the data taken out from the record buffer 20 is received in response, it is sent to the display control device 13 via the CPU 12, and the data is displayed and output from the CRT display device 14. .

FIG. 3 shows a concrete example of the A table (input definition table) and the W table (window definition table) set in the definition table memory 18. In other words, table A is the record item (product name)
"IW" indicates that the abbreviation should be entered in response to
, table number "1" of the window definition table, indicating that the product name will be imported when an abbreviation is input in the product master file, and defines "product MT (abbreviation, product name)". Further, the W table defines the inserting position of the window screen, the table frame for configuring the window screen, characters, etc. corresponding to the table number "1", and also defines the record extraction conditions. In this case, the record extraction condition defines that a record search should be performed in the product inventory management file based on the code value of the product master file, and only records with the target product inventory quantity of "1" or more should be extracted. .

Next, the operation of this embodiment will be explained. It is now assumed that the product master file and product inventory management file in the disk device 16 are configured as shown in FIG. That is, each record constituting the product master file consists of a code, an abbreviation, and a product name. In this case, the abbreviation is for the product name, and the first part of the product name is the abbreviation. Each record is separated by a record start code “(”, and each field within a record is separated by a word end code. Also, each record that makes up the product inventory management file is separated by each record in the product master file. It corresponds 1:1 to the product master file, and consists of the same codes as the product master file as well as the inventory quantity. Each record is separated by a record start code, and each field within a record is separated by a word end code. It is being

When searching the product master file, it is defined that an abbreviation (product name) should be entered as shown in table A in the definition table memory 18, so the file search process shown in FIG. Start the abbreviation on the keyboard 1
1, the abbreviation input process is executed (step S1), and the input abbreviation data is taken into the CPU 12 and then passed to the record search device 15. Then,
The record search device 15 searches the product master file in the disk device 16 based on the abbreviations, reads one screen worth of corresponding records (six records in this embodiment) from the product master file, and first selects one of the records from the product master file. The record is passed to the condition determination device 17 (step S2). In this case, the condition determination device 17 executes extraction condition processing (step S4) on the condition that the information is not EOF information (step S3).

[0013] In this case, the table number of table A is used as an extraction condition.
In the W table indicated by ``1'', a record search is performed on the product inventory management file using the code value of the product master file (code value in the record passed from the record search device 15), and the number of the target product in stock is determined. Since it is defined that only records of "1" or more should be extracted, the condition determining device 17 determines whether the record matches this record extraction condition (step S5). As a result, if the conditions are not met, the process returns to step S2 to remove this record from the detection target, and a request is made to the record search device 15 for the next record. (Step S6). Then, it is checked whether one screen worth of records has been written into the record buffer 20 (step S7), and the above-mentioned operation is performed until one screen worth of records is written into the record buffer 20 or until EOF information is detected. 1
Repeat record by record.

[0014] Therefore, there is 1 in the record buffer 20.
When a screen worth of records has been written or when EOF information is detected, the record control device 21 provides the contents of the record buffer 20 to the display control device 13 via the CPU 12, and causes the CRT display device 14 to output the contents for display. In this case, the data in the record buffer 20 is displayed and output according to the window format defined in the W table in the definition table memory 18 (step S8
). WD in FIG. 4 shows an example of the window display in this case,
Six records consisting of product names and inventory quantities are displayed within the window screen WD, and a cursor is initially displayed at the first record position (indicated by diagonal lines in the figure).

[0015] In this state, in order to select an arbitrary record, when the cursor is set at the desired record position and the confirmation key is operated (step S10), the selection device 22 selects the record as a confirmation record and selects this record. The selection information is provided to the capture device 23 via the CPU 12. On the other hand, when the next page key is operated (YES in step S11), the selection device 22 erases each record in the window screen (step S12). In this case, only the records within the window screen are erased while the contents of the window screen (table frame, etc.) and the record buffer 20 are retained. Then, the process returns to step S2, and the steps from step S2 to
S7 is repeated. As a result, the contents of the next page are displayed on the window screen (step S8). Further, when the previous page key is operated (NO in step S11), each record in the window screen is erased (step S13) in the same way as the above-mentioned next page key operation. Then, one screen worth of records included in the previous page is read out from the record buffer 20 and displayed on the window screen (step S14). After that, the process returns to step S3.

[0016] When the confirmation key is operated, the importing device 23 retrieves the output target data (A
Buffer 20 for recording (product name defined in the table)
When received from the record control device 21 (step S15), it is sent to the display control device 1 via the CPU 12.
3 and output the display from the CRT display device 14 (step S16). IT in FIG. 4 shows a display example in this case, and is displayed in the product name column of the sales slip. Then, the process proceeds to step S17, where the window screen and the contents of the record buffer 20 are all erased, and the process ends.

[0017] In the above embodiment, only records that match the record extraction conditions are extracted from the product master file by referring to the product inventory management file, but it is not possible to refer to other files. Records that match record extraction conditions may be extracted. In this case, if you store unnecessary records in the product master file in an unnecessary file and refer to this unnecessary file to extract only the necessary records from the product master file, you can remove unnecessary records from the product master file. There is no need to delete it, making it extremely convenient.

[0018]

According to the present invention, even if data not included in the records of the search target file are specified as the search target, only desired records can be extracted from the search target file. This eliminates the need to change the record format or processing program, making it extremely effective. In particular, when a corresponding record is searched by inputting an abbreviation, even if there are many corresponding records, only desired records can be selected efficiently.

[Brief explanation of the drawing]

FIG. 1 is a flowchart showing the processing steps of the present invention.

FIG. 2 is a block configuration diagram of a record search device showing an embodiment of the present invention.

FIG. 3 is a diagram showing the contents of an A table and a W table set in the definition table memory 18 shown in FIG. 2;

FIG. 4 is a diagram showing a file structure and display example of the above embodiment.

FIG. 5 is a flowchart showing the operation of the above embodiment.

[Explanation of symbols]

11 Keyboard 12 CPU 15 Record search device 16 Disk device 17 Condition judgment device 18 Definition table memory 19 Record index device

Claims (1)

[Claims] Claims: 1. A record search device that searches a data file to be searched for a record that matches the search condition when a record search condition is specified; When a related file containing data is provided and record extraction conditions are specified in addition to the record search conditions, the data file is searched based on the record search conditions, and then the search results and the record extraction conditions are specified. By searching the related files based on, among the records in the data file that match the record search conditions, only the records that correspond to the data in the related files that match the record extraction conditions are extracted from the data file. A record search method characterized by extracting records.