JPH04310183A - Method for retrieving/outputting relational data base - Google Patents

Abstract

PURPOSE:To shorten the waiting time of a terminal even when the number of retrievals is large by storing only the internal management number in a read file in the case of the retrieval and executing the read and edition processings of real data and the output processing of documents according to another program independent of the retrieval. CONSTITUTION:A main program 2 and a sub program 5 are provided. The main program 2 receives various operation instructions such as the retrieval, display and documents output or the like from a screen 1 of the terminal as commands. When the retrieving instruction is received, the record number of a retrieved record is outputted to a record number file 4 and the sub program 5 is activated. The sub program 5 reads the real data from a relational data base 3, edits the data and outputs a document 6 by using the record number stored in the record number file 4 independently of a main processing. Thus, even when a lot of data are edited/outputted in a complicated form, the waiting time of the terminal can be suppressed at a minimum.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for searching and outputting a relational database.

0002

2. Description of the Related Art Conventionally, when data in a relational database is searched under conditions and the search results are edited and output as a form, processing is generally performed in the following manner. In other words, a set of record numbers of records matching specified search conditions from a relational database is stored in an intermediate file (hereinafter referred to as an intermediate file) managed by the relational database, and then records in the intermediate file are stored. Read records (actual data) from the database one by one using numbers. The actual data obtained in this way is edited and output as a form.

[0003] The above intermediate file is provided by a relational database system, and the intermediate file identification number is unique only within one job. Therefore, since it is not possible to manipulate intermediate files from other jobs, in order to obtain actual data, data must be searched, read, edited, and output in succession within one job.

0004

[Problems to be Solved by the Invention] In the conventional data search and form output method described above, when the number of searches from a relational database is large, the data search and
It took a long time to load. Furthermore, the more complex the editing output format, the longer it takes to edit the output image and output the form.

[0005] During this time, there was a problem in that the screen of the terminal was occupied, making it impossible to input instruction commands, and the work efficiency of the user was significantly reduced.

[0006]

[Means for Solving the Problems] The relational database search/output method of the present invention immediately searches a relational database according to given search conditions, edits the searched data, and outputs a form to an output device. The system is configured so that only the internal management number is read and stored in a user file during a search, and the actual data reading, editing, and form output processing are executed by a separate program independent of the search using the user file as a medium. be done.

[0007]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, the present invention will be explained with reference to the drawings.

FIG. 1 is an explanatory diagram showing one embodiment of the present invention. In the figure, the relational database search/output method is divided into main processing centered on main program 2 and sub-processing centered on subprogram 5, and the main processing and sub-processing are executed independently. In the figure, 1 is a terminal screen, 3 is a relational database, 4 is a record number file, and 6 is a form.

The main program 2 receives various operation instructions such as search, display, and form output from the terminal screen 1 as commands. When a search instruction is received, the record number of the record to be searched is output to the record number file 4, the subprogram 5 is started, and the process is terminated. This part is the main processing. When the subprogram is activated, screen 1 of the terminal becomes available for use.

The subprogram 5 started by the main program 2 reads actual data from the relational database 3 using the record number stored in the record number file 4, edits it, and outputs a form 6. This part is sub-processing.

FIG. 2 is a functional block diagram of main processing. In the figure, 7 is search instruction data, 8 is a search module, 9
1 is an intermediate file, 10 is form output instruction data, 11 is a number reading module, and 12 is a parameter file. Note that the search module 8 and number reading module 11 are part of the main program 2.

Search module 8 and number reading module 1
1 searches the relational database 3 according to the search instruction data 7 and stores a set of record numbers of records matching the search conditions in one of the intermediate files 9.

The number reading module 11 reads the record number stored in the intermediate file in accordance with the form output instruction data and stores it in the record number file 4. The record number file 4 is a standby combined organization file, and when storing the record number, a subfile is created with the terminal name and system time as the subfile name, and the record number of the intermediate file 9 is stored therein. Further, the number reading module 11 creates a parameter file 12 in order to pass processing to the subprogram 5.

FIG. 3 is a functional block diagram of sub-processing. In the figure, 13 is a data reading module, 14 is a data storage file, 15 is an editing output module, and 16 is another file. The data reading module 13 and the editing output module 15 are components of the subprogram 5.

When the data reading module 13 is activated, it refers to the parameter file 13 and obtains the corresponding subfile name. Then, the record number is read from the corresponding subfile in the record number file 4, and using it, actual data is read from the relational database 3 and stored in the data storage file 14. When the above processing is completed, the corresponding subfile in the record number file 4 is deleted.

Note that the data storage file 14 is secured as a temporary file on the auxiliary storage device.

When the processing of the data reading module 13 is completed, the next step is to start the editing output module 15 and read the data storage file 14 and other files 16.
After the data is read in and various editing operations such as column formatting, code conversion, word breaks, etc. are performed, a form 6 is output.

[0018]

[Effects of the Invention] As described above in detail, according to the present invention, when searching for data, processing can be completed by simply reading the record number and storing it in a file, and reading, editing, and outputting the searched actual data into a form. Processing that takes time, such as searching, is performed independently of the above-mentioned search processing by starting another job. Therefore, even when editing and outputting a large amount of data in a complicated format, it is possible to minimize the waiting time at the terminal. For example, when considering only the time required to read data, reading only the record number takes about 1/5 of the time compared to reading the actual data.

[0019] As a result, from the user's perspective, when a command to output a form is input from the screen, that command is immediately executed and the screen becomes available for use, so that the user can print out the form and use the screen at the same time to print out the next command. It is possible to execute instruction commands, increasing work efficiency.

[Brief explanation of the drawing]

FIG. 1 is an explanatory diagram showing one embodiment of the present invention.

FIG. 2 is a functional block diagram of main processing.

FIG. 3 is a functional block diagram of sub-processing.

[Explanation of symbols]

2 Main program 3 Relational database 4 Record number file 5 Subprogram 6 Report

Claims (1)

[Claims] [Claim 1] A system that instantly searches a relational database according to given search conditions, edits the searched data, and outputs a form to an output device, comprising:
A relational system characterized in that during a search, only an internal management number is read and stored in a user file, and reading of actual data, editing processing, and form output processing are executed by a separate program independent of the search using the user file as a medium. How to search and output type database.