JPH04219838A - Data base retrieval processing system - Google Patents

Abstract

PURPOSE:To perform a routine process efficiently although it is an instantaneous execution type by registering a procedure, generated on an interactive basis, in a procedure file and executing it when it is necessary. CONSTITUTION:In a procedure storage process 6, the executed procedure is stored in the procedure file 1 with an indication. When a definition execution type retrieval process is performed, the procedure stored in the procedure file 1 is selected with an indication and executed to retrieve the data in a data base file 2, obtaining a process result output 5. Thus, while the procedure is corrected by an instantaneous execution type retrieval process, the re-execution is repeated until a proper retrieval result is obtained and the procedure once determined is stored in the procedure file 1. Then the same procedure is read out of the procedure file 1 by the definition execution type retrieval process every time a process is performed to complete the routine process.

Description

[Detailed description of the invention]

0001

[Industrial Application Field] The present invention is an instant execution type database search processing system suitable for non-routine processing operations, which enables the repeated use of created search processing procedures, thereby making it possible to perform routine processing operations as well. Regarding a database search processing system.

0002

[Prior Art] Conventional database search processing systems are of an immediate execution type, in which a procedure that defines search conditions is created and executed immediately, and a defined execution type, in which a procedure defined in advance and stored in a file is executed. It can be broadly divided into FIGS. 3(a) and 3(b) are simplified illustrations of these conventional examples. FIG. 3(a) shows the search process of the instant execution type system, and 2 is a database file in which file data of a database having a table structure is stored. 3 is a procedure creation process in which the user reads out the file list of the database and the item information in the table of each file on the screen of the display device, and displays the target file, search items, output items, logical relationships between items, and item values. Interactively create a procedure definition that specifies search conditions such as the range of .

4 is the execution of the created procedure, and by instructing execution of the created procedure on the screen, for example by operating an execution key, a search process according to the procedure is executed. 5 is a processing result output, in which data obtained as a result of search processing by procedure execution is displayed on a display or output from a printer. The user looks at the processing result output 5 and ends the process if he or she is satisfied with the result, but if the desired data is not obtained, the user recreates the procedure and repeats the search until a satisfactory result is obtained. This instant execution type system is suitable for atypical processing in which searches are performed using different search conditions each time, and requires a relatively high level of skill from the user.

[0004] Next, FIG. 3(b) shows a search process of a definition-execution type system, in which a procedure file indicated by 1 for storing predefined procedures is provided. In the case of this definition execution type system, the procedure creation process 3 and the procedure execution 4 are performed completely independently. That is, in the procedure creation process 3, the user creates a procedure based on the predefined procedure that is immediately stored in the procedure file 1, or creates a new procedure, and uses the procedure storage process shown in 6 to create the procedure file 1. Store in. When the user needs to search the database, the user refers to the contents of procedure file 1, selects an appropriate procedure, executes procedure 4, searches the data in database file 2, and outputs the processing results. Do step 5. This definition-execution type system is suitable for routine processing.

[0005]

[Problem to be solved by the invention] In the search processing of conventional instant execution type systems, a procedure is created for each search processing.
Since the procedure is deleted when the search process is completed, it is necessary to create the procedure every time even when performing a routine search, which is a problem in that it is a waste of time and effort. On the other hand, in the case of a definition-execution system, the created procedure cannot be executed unless it is registered in the procedure file.
If it is not possible to check the search results based on the created procedure at the creation stage, and for example it is necessary to change the search conditions little by little and then redo the search, the operation of storing and reading the procedure file will be performed each time, which can be extremely inconvenient. It became efficient. An object of the present invention is to realize a database search processing system that can execute routine processing efficiently while being of an immediate execution type.

[0006]

[Means for Solving the Problems] The present invention provides a procedure file that can store procedures in an immediate execution type system,
This problem was solved by making it possible to store and reuse procedures at any time. FIG. 1 is a diagram explaining the principle of the present invention, in which (a) shows the operation of immediate execution type search processing, and (b) shows the operation of definition execution type search processing. In FIG. 1(a), 1 is a procedure file in which defined procedures are stored. 2 is a database file in which a database is stored. 3 is a procedure creation process that creates a definition of a search process procedure in an interactive manner. For creation, predefined procedures stored in procedure file 1 can be used. 4 is procedure execution, in which the procedure created in procedure creation process 3 is executed according to the instructions and the database file 2 is created.
data is searched.

5 is a processing result output, and procedure execution 4
The data resulting from the search is displayed on the screen or printed out. 6 is a procedure storage process, in which the executed procedure is stored in the procedure file 1 according to instructions. Next, Figure 1(b)
When performing definition execution type search processing, a procedure stored in procedure file 1 is selected and executed according to an instruction, data in database file 2 is searched, and processing result output 5 is obtained.

[0008]

[Operation] According to the principle of the present invention shown in FIG. 1, efficiency can be improved by selectively using immediate execution type search processing, which is advantageous for non-routine processing, and definition execution type processing, which is advantageous for routine processing, depending on the situation. A search is performed. For example, until an appropriate search result is obtained, the procedure is repeatedly modified and re-executed using the instant execution search process shown in Figure 1(a), and when the procedure is finalized, it is stored in procedure file 1, and then The definition execution type search processing shown in FIG. 1(b) makes it possible to read the same procedure from the procedure file 1 and perform routine processing every time a processing is requested.

[0009]

Embodiment A processing mechanism according to an embodiment of the present invention will be explained with reference to FIG. In FIG. 2, 1 is a procedure file, 2 is a database file, 7 is a file information/item information reading processing unit, 8 is a search processing procedure creation unit, 9 is a search processing unit that performs non-routine processing, and 10 is a non-routine processing A search result output unit that displays search results, 9' is a search processing unit that performs standard processing, which is actually the same as search processing unit 9, and 10' is a search result output unit that displays search results based on standard processing. is the same as the search result output unit 10. Each processing unit is realized using software. To explain the operation, when performing immediate execution type non-routine processing, the file information/item information reading processing unit 7 is activated, the file list of the database file 2, item information of each file, etc. are loaded on the screen, The search processing procedure creation unit 8 interactively selects search target files and items, sets search conditions, and defines search processing procedures.

[0010] When the procedure creation is completed, an execution instruction is given, the search processing unit 9 executes the procedure, and the search result output unit 10
Output and display the search results. If the user looks at the search results and determines that it is necessary to change the search conditions and perform the search again, the user returns to the screen of the search processing procedure creation unit 8, redefines the procedure, and re-executes the procedure. This process is repeated until a result that is satisfactory to the user is obtained. When a satisfactory result is obtained, the user instructs to store the procedure, starts the procedure storage processing section 11, and stores the executed procedure in the procedure file 1. In this way, each procedure created by performing the immediate execution type search process is managed as a library by being stored in the procedure file 1. Procedure file 1
The contents of can be read out by the procedure reading processing section 12 at any time, and can be referred to when creating a procedure in the search processing procedure creation section 8, modified and used,
Alternatively, it may be executed as is in the search processing unit 9' as a routine processing procedure.

[0011]

Effects of the Invention According to the present invention, the ease of routine processing of a definition execution type system is added to the ease of researching by modifying procedures of an immediate execution type system, and as a result, the usability of the system is improved. Processing efficiency can be improved.

[Brief explanation of the drawing]

FIG. 1 is a diagram explaining the principle of the present invention.

FIG. 2 is an explanatory diagram of a processing mechanism according to an embodiment of the present invention.

FIG. 3 is an explanatory diagram of a conventional example.

[Explanation of symbols]

1 Procedure file 2 Database file 3 Procedure creation process 4　Procedure execution 5 Processing result output 6 Procedure storage processing

Claims (1)

[Claims] [Claim 1] A database search processing system in which a procedure for database search processing can be created in an interactive format and the procedure can be immediately executed, a procedure file for registering the procedure is provided, and the procedure created in the above interactive format is instructed. A database search processing system characterized in that the above procedure is registered in the procedure file and read out and executed as necessary.