JPH03129570A - Data base retrieving system - Google Patents

Abstract

PURPOSE:To reduce user's labor and user's specification misses by providing the data base retrieving system with a retrieving condition cataloguing means, a rapid retrieval means, a data base processing means, and a retrieved result updating means. CONSTITUTION:The retrieving condition cataloguing means 10 stores the retrieved result of a data base 80 in a retrieved result file 70 and the rapid retrieving means 20 refers a catalogue table 60 and outputs the record of the corresponding retrieved result stored in the file 70 to an I/O device 50. At the time of receiving an updating request from a data base updating request program 90, the data base processing means 30 updates the data base 80, and when a retrieved result updating means 40 satisfies a retrieving condition expression stored in the table 60, updates the contents of the retrieved result file 70 for a retrieved result file name corresponding to the retrieving condition expression. Thus user's labor can be reduced and the generation of misspecification can be prevented.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a database search method, and particularly to a database search method aimed at speeding up search processing.

[Conventional technology]

Conventionally, in this type of database search method, five search condition expressions were specified each time, and the database was searched based on the specified search condition expressions.
In the case of search processing using frequently used search condition expressions,
Even if the search condition expression was long, it had to be specified each time.

Furthermore, even if a search result based on the same search condition expression had been sought just before, there were none left, so the user had to search the database again.

[Invention tries to solve it! ! ! ! Problem] In the conventional database search method described above, even when performing search processing using long search condition expressions that are frequently used, it is necessary to specify a long search condition expression for each search request, which saves the user's effort. There is a drawback that it takes a long time.

In addition, since a long search condition expression is specified many times, there is a possibility that the user may make a mistake in specification.

Furthermore, since the search condition expression is analyzed and the database is searched every time a search request is made, there is a drawback that processing time is required for searching in the case of a large number of database records.

Furthermore, if the same search process is performed repeatedly, there is a drawback that the process is wasted.

In view of the above-mentioned points, an object of the present invention is to catalog frequently used search condition expressions to reduce the trouble of specifying search condition expressions, and to improve the processing speed when searching a database by providing a search result file. The purpose of this invention is to provide a database search method based on the following methods.

[Means to solve the problem]

The database search method of the present invention is an interactive system that receives and executes a database search request based on a command, and uses a search condition expression from an input/output device, a name of a search result file for storing search results based on the search condition expression, and a search condition. Accepts the conditional expression short name that corresponds one-to-one with the expression, stores the conditional expression short name, search condition expression, and search result file name in a catalog table, and searches the database based on the search condition expression. A search condition cataloging means to be accumulated in a result file and a condition expression short name received from an input/output device refer to the catalog table, recognize the search result file name containing the search result, and convert it into the corresponding search result file. A high-speed search means that outputs stored search result records to an input/output device, and a search result update means that receives an update request from a database update request program, updates the database, and sends images of records before and after the update to the search result update means. A database processing means to be passed, and a search result file corresponding to the search condition expression when the database processing means accepts images of records before update and records after update, and the record satisfies the search condition expression in the catalog table. and the search result updating means for updating the contents of the search result file of the name.

[Effect]

In the database search method of the present invention, the search condition cataloging means receives the search condition expression from the input/output device, the name of the search result file for inputting the search result based on the search condition expression, and the condition that corresponds one-to-one with the search condition expression. It accepts the expression abbreviation, stores the condition expression abbreviation, search condition expression, and search result file name in a catalog table, and stores the results of searching the database based on the search condition expression in the search result file, thereby providing a high-speed search method. receives the conditional expression short name from the input/output device, refers to the catalog table, recognizes the name of the search result file that contains the search results, and transfers the search result record stored in the corresponding search result file to the input/output device. The database processing means receives an update request from the database update request program, updates the database, passes the images of the record before update and the record after update to the search result update means, and the search result update means updates the database from the database processing means. Images of the previous record and the updated record are received, and if the record satisfies the search condition expression in the catalog table, the content of the search result file with the search result file name corresponding to the search condition expression is updated.

〔Example〕

Next, the present invention will be explained in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of a database search method according to an embodiment of the present invention. means 30, search result update means 40, input/output device 50, catalog table 60, search result file 70, database 80
and a database update request program 90.

Referring to FIG. 2, the catalog table 60 consists of a plurality of columns in which conditional formula short names, search conditional formulas, and search result file names are stored.

The input/output device 50 is used in an interactive system that receives and executes a database search request based on a command, for receiving a search condition expression etc. from a user and notifying the user of search results according to the search condition expression etc. It will be done.

The search condition cataloging means 10 outputs a search condition expression from the input/output device 50, a name of a search result file 70 for storing search results based on the search condition expression, and a one-to-one correspondence with the search condition expression.
Accepts the conditional expression abbreviation corresponding to the conditional expression abbreviated name, associates the conditional expression abbreviated name, search conditional expression, and search result file name in the catalog table 60, and searches the results of searching the database 80 based on the search conditional expression. The results are accumulated in the result file 70.

Referring to FIG. 3, the process of the search condition cataloging means 10 is to accept the search condition expression, search result file name, and condition expression abbreviation in step 301, to assign the initial position of the catalog table in step 302, and to determine the position. Empty judgment step 3
03, and step 304 for catalog table next stage positioning.
, a step 305 for storing the conditional expression abbreviated name, search conditional expression, and search result file name, and a step 30 for analyzing the search conditional expression.
6, a database search step 307, and a search result file accumulation step 308.

The high-speed search means 20 receives the conditional expression abbreviation, recognizes the search result file name containing the search results from the catalog table 60, and outputs the records stored in the search result file 70 to the input/output device 50. do.

Referring to FIG. 4, the processing of the high-speed search means 2o includes step 401 for accepting the short name of the conditional expression, step 402 for assigning the first position of the catalog table, step 403 for determining whether the short name of the conditional expression matches, and step 403 for determining the next position of the catalog table. Attachment consists of a step 404, a positioning step 405 for determining whether a column is empty, a conditional expression□abbreviation specification error step 406, and a search result output step 407.

The database processing means 30 receives an update request from the database update request program 90, updates the database 80, and transfers the images of the pre-update record and the post-update record and the update type flag to the next search result update means 4.
Pass to 0.

Referring to FIG. 5, the processing of the database processing means 30 includes step 501 for receiving an update request, step 502 for updating the database, and step 50 for delivering the pre-update record, post-update record image, and update type flag.
It consists of 3.

The search result update means 40 receives the images of the pre-update record and the post-update record and the update type flag from the database processing means 30, and updates the search result expression with the search condition expression when the record satisfies the search condition expression in the catalog table 60. The contents of the search result file 70 of the corresponding search result file name are updated.

Referring to FIG. 6, the processing of the search result updating means 40 is as follows:
Reception of pre-update record, post-update record image, and update type flag is performed at step 7 601, catalog table first stage positioning is performed at step 602, and update t! Similar rough rough determination step 03, updated record search condition expression satisfaction determination step 604, and updated record addition step 60
5, and pre-update record search condition expression satisfaction determination step 60
6, pre-update record deletion step 607, pre-update record search condition expression satisfaction determination step 608, pre-update record deletion step 609, post-update record search condition expression satisfaction determination step 610, and post-update record addition step 611. , catalog table next stage positioning step 612, and positioning step 613 for determining stage chamber.

Next, the operation of the database search method of this embodiment configured as described above will be explained.

When the search condition cataloging means 10 receives the search condition expression, search result file name, and condition expression abbreviation from the input/output device W50 (step 301), the search condition cataloging means 10 stores the catalog table 60.
is positioned at the first stage (step 302), and it is determined whether the positioned stage is empty (step 303). If the positioned column is not empty, search condition cataloging means 1
0 positions the catalog table 60 in the next stage (step 304), returns I+ control to step 303, and if the positioned stage is empty, the conditional expression abbreviation.

The search condition expression and the search result file name are stored in that column (step 305). Next, the search condition cataloging means 10 analyzes the search condition expression (step 306), and searches the database 80 based on the analysis result. Step 3
07), accumulate the search results in the search result file 70 (
Step 308).

When the high-speed search means 20 receives the conditional expression abbreviation from the input/output device 50 (step 401), it positions the catalog table 60 at the first stage (step 402), and uses the conditional expression abbreviation received from the input/output device 50 and the catalog table 6.
A comparison is made to see if they are equal to the conditional expression abbreviation of the column in which 0 is positioned (step 403). If the received conditional expression abbreviation is not equal to the conditional expression abbreviation of the positioned stage of the catalog table 60, the high-speed search means 20 positions the catalog table 60 in the next stage (step 40).
4) Check whether the positioned column is empty (step 405).
), if it is empty, there is no conditional expression abbreviation that matches the accepted conditional expression abbreviation in the catalog table 60, so the process is stopped as an error in specifying the accepted conditional expression abbreviation (step 406). is not empty, the high-speed search means 20 repeats steps 403 and 404, and if an equal conditional expression short name is found, the high-speed search means 20 searches for the target search result file name specified in the positioned column of the catalog table 60. The search result file 70 is read and its contents are output to the input/output device 5θ as a search result (step 407).

Upon receiving an update request from the database update request program 90 (step 501), the database processing means 30 updates the database 80 in step 502.
), images of before-update record and after-update record, and update type flag (flag indicating addition, deletion, or modification)
and is passed to the search result updating means 40 (step 503).

When the search result updating means 40 receives the images of the pre-update record and the post-update record and the update type flag from the database processing means 30 (step 601), it positions the catalog table 60 at the first stage (step 602).
), determine the type of update type flag (step 603
).

If the update type flag indicates addition, the search result update unit 40 determines whether the updated record satisfies the search condition expression of the positioned stage of the catalog table 60 (step 604). The updated record is catalog table 6
If the search condition expression of the positioned column 0 is satisfied, the search result updating means 40 adds the updated record to the search result file 70 having the search result file name of the positioned column (step 605).

If the update type flag indicates deletion, the search result update unit 40 determines whether the pre-update record satisfies the search condition expression of the positioned stage of the catalog table 60 (step 606). The record before update is catalog table 6
If the search condition expression of the positioned column 0 is satisfied, the search result update means 40 deletes the pre-update record from the search result file 70 having the search result file name of the positioned column (step 607).

If the update type flag indicates modification, the search result update unit 40 determines whether the pre-update record satisfies the search condition expression of the positioned stage of the catalog table 60 (step 608). The record before update is catalog table 6
If the search condition expression of the positioned column 0 is satisfied, the search result updating means 40 deletes the pre-update record from the search result file 70 having the search result file name of the positioned column (step 609). Next, search result updating means 4
0, it is determined whether the updated record satisfies the search condition expression of the positioned stage of the catalog table 60 (step 610), and the updated record is the catalog table 6.
If the search condition expression of the positioned column 0 is satisfied, an updated record is added to the search result file 70 having the search result file name of the positioned column (step 611).

When the above addition, deletion, or modification processing is completed, the search result update means 40 updates the catalog table 60.
is located in the next stage (step 612), and it is determined whether the located stage is empty (step 613).If the located stage is not empty, the search result updating means 40 returns control to step 603 to continue processing. Repeatedly, if the positioned stage is empty, the process ends.

〔Effect of the invention〕

As explained above, the present invention provides a search condition cataloging means, a high-speed search means, a database processing means, and a search result updating means, so that frequently used search condition expressions are cataloged. By creating a catalog table that associates search condition expressions and search result file names, it is possible to specify a condition expression abbreviation when specifying a search condition expression, reducing the user's effort and making it easier to use. It has the effect of freezing the space designated by the person.

In addition, search results for frequently used search condition expressions are stored in a search result file, and the contents of the search result file are output to the input/output device instead of searching the database during search processing, thereby speeding up processing time. It has the effect of being able to be transformed into

[Brief explanation of the drawing]

Figure 1 is a block diagram showing the configuration of a database search method according to an embodiment of the present invention, Figure 2 is a diagram showing the contents of the catalog table in Figure 1, and Figure 3 is the search conditions in Figure 1. 4 is a flowchart showing the processing of the high-speed search means in FIG. 1; FIG. 5 is a flowchart showing the processing of the database processing means in FIG. 1; FIG. 6 is a flowchart showing the processing of the database processing means in FIG. 2 is a flowchart showing the processing of the search result updating means in FIG. 1; In the figure, 10... search condition cataloging means, 20... high speed search means, 30... database processing means, 40... search result updating means, 50... input/output device, 60... Catalog table, 70...Search result file, 80...Database, 90...Database update request program. Figure 2 Figure 5 Figure 3 Figure 4 High speed search means 20

Claims (1)

[Claims] In an interactive system that receives and executes a database search request using a command, a search condition expression, the name of a search result file for storing search results based on the search condition expression, and the search condition expression are provided from an input/output device. It accepts conditional expression abbreviations in one-to-one correspondence, stores the conditional expression abbreviation, search conditional expression, and search result file name in a catalog table, and stores the results of searching the database based on the search conditional expression in a search result file. a search condition cataloging means for accumulating the search condition in the input/output device; and a search condition cataloging means that receives a condition expression abbreviation from the input/output device, refers to the catalog table, recognizes the search result file name containing the search result, and stores the search result file name in the corresponding search result file. A high-speed search means that outputs search result records to an input/output device; and a database processing means that receives update requests from a database update request program, updates the database, and delivers images of pre-update records and post-update records to the search result update means. The database processing means accepts images of records before update and records after update, and if the record satisfies the search condition expression in the catalog table, a search result with a search result file name corresponding to the search condition expression is obtained. A database search method comprising: the search result update means for updating the contents of a file.