JPH07287714A - Device and method for retrieving data base - Google Patents

Abstract

PURPOSE:To provide a data base retrieving device capable of shortening operator's waiting time. CONSTITUTION:The data base retrieving device for retrieving data from plural files in a relational data base system and displaying a retrieved result on a display device is provided with storage means 21 to 23 for temporarily storing data respectively retrieved from plural files 11 to 13 and a connection processing distributing means 30 for distributing the connecting processing of retrieved data from respective files 11 to 13 stored in the means 21 to 23 to 1st and 2nd connection processing, immediately executing the 1st connecting processing, displaying the result of the 1st connecting processing on a display device 40, executing the 2nd connecting processing only for the data of the 1st connecting processing result only when an operator's display command is inputted, and displaying the result of the 2nd connecting processing on the device 40.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database search device and a search method in a database system for processing in a relation format.

[0002]

2. Description of the Related Art When performing a search from a database stored in a plurality of files, it is necessary to perform a data search process for each file and a combining process of the data searched for each file. Conventionally, the process of combining the data retrieved for each file has been performed collectively.

[0003]

If the combined processing of the data retrieved for each file is performed collectively, there is a problem that the combined processing time becomes long and the waiting time of the operator becomes long.

It is an object of the present invention to provide a database search device and a search method that can reduce the waiting time of an operator.

[0005]

A database search device according to the present invention searches data from a plurality of files in a relational database system and displays the search results on a display device. A storage unit for temporarily storing data and a process of combining search data for each of a plurality of files stored in the storage unit are distributed to a first combination process and a second combination process, and the first combination process is immediately performed. hand,
The result of the first combining process is displayed on the display device, and the second combining process is performed only on the data of the first combining process result currently displayed when the display command is input by the operator. , And a combination processing distribution means for displaying the second combination processing result on a display device.

The display command issued by the operator includes horizontal scrolling, vertical scrolling, and the like.

The database search method according to the present invention is
In a database search method of searching data from a plurality of files of a relational database system and displaying a search result on a display device, a combining process of data searched from each of the plurality of files is performed by a first combining process and a second combining process.
The first combining process is immediately performed and the result of the first combining process is displayed on the display device, and the second combining process is currently displayed when the display command is input by the operator. It is characterized in that it is performed only on the data of the first combined processing result that has been made and the second combined processing result is displayed on the display device.

[0008]

The combining process of the retrieved data of the plurality of files is distributed to the first combining process and the second combining process. The first combining process is immediately performed, and the result of the first combining process is displayed on the display device. For the second combining process,
When a display command is input by the operator, this is performed only on the currently displayed data of the first combination processing result, and the second combination processing result is displayed on the display device.

[0009]

DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 shows the structure of a database search device.

When the search from the plurality of files 11, 12, and 13 is started, the search is first performed for each file, and the searched data is stored in the memories 21, 22, and 23.

Next, the load balancing processing section 30 performs load balancing processing. That is, the load of the entire combining process is predicted, and based on the predicted load, the combining process is divided into a process A performed at the time of initial batch display and a process B performed based on a display command from the operator at the time of screen display. It Process B
As for, the one with a relatively small load is selected.

The processing A is immediately and collectively performed, and the combined result is displayed on the screen of the display device 50. The process B is performed only on the data currently displayed when the operator's display command is input.

In such a retrieval device, since the result is displayed on the display device 40 after performing the process A, compared with the case where the result is displayed after performing the process A and the process B, the operation is performed. The waiting time for workers is shortened.

FIG. 2 shows a more specific example.

In this example, three files 11, 12,
13 stores an employee table, a department table, and a rating table.

FIG. 3 shows an employee table. The employee table has attributes of "employee code", "name", "department code", and "rating code".

FIG. 4 shows a department table. The department table has attributes “department code”, “department name”, “belonging department code”, and “place name”.

FIG. 5 shows a rating table. The rating table has attributes of "rating code" and "salary class".

As can be seen in FIGS. 3, 4 and 5,
The department table is associated with the employee table by the attribute “department code”. The rating table is associated with the employee table by the attribute "rating code".

Here, the operator has an employee code of 10
It is assumed that a search command is input to search for the employee's full name, department name, and salary class.

First, the employee table of the file 11 is searched for data having an employee code of 10 or more, and the retrieved data is stored in the memory 21.

Next, from the department table of the file 12,
The data of “department code” and “department name”, which are the attributes required for the search, are read out and stored in the memory 22.

Next, the data of "rating code" and "salary class", which are attributes required for retrieval, are read from the rating table of the file 13 and stored in the memory 23.

Next, the load distribution processing unit 30 distributes the combining processing into processing A and processing B. That is, the process of joining the employee table and the department table is determined as process A, and the process of joining the employee table and rating table is determined as process B.

Process A is performed immediately. That is, the “department name” in the memory 22 corresponding to the “department code” in the memory 21 is combined with the data in the memory 21. Then, of these combined result data, the data of “name” and “department name” are displayed on the display device 40 for one screen. In this example, two sets of data are displayed on one screen.

Process B is performed only on the currently displayed set of data when the operator scrolls to the right to see the contents of the "salary class". In other words, the “salary class” corresponding to the currently displayed two sets of “rating codes” is combined with the displayed set of data, and the combined “salary class” data is displayed on the display device 40. To be done.

When the operator scrolls up and down to see the data of a group different from the displayed group,
The data of “name” and “department name” that have already been combined by the process A are displayed on the display device 40 for the display lines (two lines) designated by the vertical scrolling. When the operator scrolls to the right, the process B is performed on the two sets of displayed data. The operator may make a jump to see a different set of data than the displayed set.

In the above embodiment, the retrieved data set is
Although a plurality of sets are displayed side by side in the vertical direction, a plurality of retrieved data sets may be displayed side by side in the horizontal direction. In this case, the process B is performed based on the vertical scroll. Further, in order to see the data of the set different from the currently displayed set, scrolling in the left-right direction is performed.

According to the present invention, the waiting time of the operator at the time of searching can be shortened.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a database search device.

FIG. 2 is a block diagram for specifically explaining processing contents of the database search device.

FIG. 3 is a schematic diagram showing the contents of an employee table.

FIG. 4 is a schematic diagram showing the contents of a department table.

FIG. 5 is a schematic diagram showing the contents of a rating table.

[Explanation of symbols]

 11, 12, 13 files 21, 22, 23 memory 30 load distribution processing unit 40 display device

Claims (2)

[Claims] 1. A database search device for searching data from a plurality of files of a relational database system and displaying a search result on a display device, a storage means for temporarily storing data searched from each of the plurality of files. And combining the search data for each of the plurality of files stored in the storage means into the first combining process and the second combining process, immediately performing the first combining process, and displaying the result of the first combining process on the display device. Then second
Regarding the combining process, when a display command is input by the operator, the combining process is performed only on the currently displayed data of the first combining process result, and the second combining process result is displayed on the display device. A database search device comprising: a distribution unit. 2. A database retrieval method for retrieving data from a plurality of files of a relational database system and displaying the retrieval result on a display device, wherein the combining process of the data retrieved from each of the plurality of files is a first combining process and a first combining process. The second combining process is performed immediately after the first combining process is immediately performed and the result of the first combining process is displayed on the display device. The second combining process is currently performed when a display command is input by the operator. A database search method, which is performed only on the displayed data of the first combination processing result and displays the second combination processing result on a display device.