JPH11203288A - Database reference device - Google Patents

Abstract

(57) [Summary] [PROBLEMS] To find the minimum search time before executing a search in a database reference device including a computer (server) having a plurality of data tables and a search / display computer (client). And improve operational efficiency. SOLUTION: A search condition is input from an input / output display unit 1,
The data transfer unit 2 issues a command to the database computer (server) 4 to search for the number of data items corresponding to the search condition, and receives information on the number of data items. Then, the search time estimating unit 3 estimates the minimum search time based on the data amount and number of data in one data table to be searched, displays the time on the input / output display unit 1, and thereafter receives the data. , To display the search data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a database reference device in a client / server system.

[0002]

2. Description of the Related Art Conventionally, when searching a database in a database reference device comprising a database computer (server) having a plurality of data tables and a data search / display computer (client), search conditions are first input. When this search condition is input, the search starts, and when the search ends, the data of the search result is displayed.

[0003]

However, in the above-described conventional database reference apparatus, since it is not known how long the search will take, the user must wait until the search is completed and the data is displayed. For example, there has been a problem that the user cannot leave the place to do another job and work efficiency is reduced.

[0004] The present invention has been made in view of the above-mentioned problems, and it is possible to know a search time after inputting a search condition, and to leave the place and perform another job during execution of the search. It is an object of the present invention to provide a database reference device with improved operational efficiency.

[0005]

A database reference device according to the present invention is a database reference device comprising a database processing device having a plurality of data tables and a data search / display processing device. An input / output unit for inputting and outputting data, a data transfer unit, and a search time estimating unit for estimating a search time from the input search conditions, and when searching an arbitrary data table, the search time estimating unit , The data is displayed after the predicted search time is displayed.

The search time estimating section has a chart of an expected search time corresponding to the data amount and the number of data, and displays the minimum search time obtained from the chart.

Further, there is provided a measuring means for measuring a search time, and a storage means for storing a previous search time, and a search time estimating section determines a minimum search time based on the search time stored in the storage means. It is as expected.

[0008]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The details of the present invention will be described below with reference to the drawings.

(Embodiment) FIG. 1 is a block diagram showing an entire configuration of an embodiment of the present invention. In the figure, 1 is an input / output display unit for inputting data search conditions and outputting search data, 2 is a data transfer unit for issuing search conditions, searching the number of cases, and receiving search data, and 3 is an expected search time. A search time estimating unit for estimating a search time based on a data amount and the number of data in one table having a chart of 4; a computer for a database (server) for storing search data;
Reference numeral 5 denotes a network, and reference numeral 6 denotes a data search / display computer (client).

[0010] The system having the above-mentioned configuration is a database computer (processing device) 4 having a plurality of data tables.
And a computer (processing device) 6 for searching and displaying data. This system is used to input / output the minimum search time predicted by the search time prediction unit 3 when searching an arbitrary data table. After the data is displayed by the section 1, a search is executed to display (output) the data.

FIG. 2 is a flowchart showing an entire search / display processing procedure including an outline of a search time estimation method in the present embodiment.

First, in step 101, search conditions are input from the display screen of the input / output display unit 1 shown in FIG.

Next, in step 102, the data transfer section 2 of FIG. 1 receives the search condition and issues a command to the database computer (server) 4 to search for the number of data items satisfying the search condition.

Next, in step 103, the data transfer unit 2
Receives the above number information.

Next, at step 104, the data transfer unit 2
Sends the data amount and number of one data table to be searched to the search time estimating unit 3.

Next, in step 105, the search time estimating unit 3 estimates the search time from the data amount and the number of data in one table in the table using the estimated search time chart shown in FIG. Let this time be the minimum expected search time.

Next, in step 106, the search time estimating unit 3 sends the estimated search time to the input / output display unit 1.

Next, at step 107, the input / output display unit 1
Displays the expected search time.

Next, at step 108, the data transfer section 2
Issues a search command to the database computer (server) 4 again.

Next, at step 109, the data transfer section 2
Receives data that meets the search conditions.

Next, in step 110, the data transfer unit 2
Sends the retrieved data to the input / output display unit 1.

Finally, in step 111, the input / output display unit 1 displays the searched data.

Next, FIG. 1 which is a main component of this embodiment is shown.
The processing in each of the units 1 to 3 will be specifically described with reference to FIGS.

For example, temperature and pressure data measured for each time of a certain apparatus are stored in a data table in a database computer (server) 4 as shown in FIG. 3, and the measurement time (column a) is used as a key. In the database reference device for searching for the measurement time (column a), temperature (column b), and pressure (column c), the search condition (measurement time) is set to 95/10 from the input / output display screen shown in FIG.
/ 21 12:00:00 to 95/12/21 12:
When 00:00 is input, the data transfer unit 2 issues a search command to the data table of the database computer (server) 4 to obtain the number of records. At this time, it is assumed that there are 1500 data that satisfy the search condition. Further, it is assumed that the data amount of one data table is 25 bytes.

Next, the data transfer unit 2 sends the data amount (25 bytes) and the number of cases (1500) to the search time estimating unit 3. The search time estimating unit 3 estimates the search time based on the data amount and the number of one data table to be searched, using the estimated search time chart shown in FIG.

Here, the chart of the estimated search time of the present embodiment is 1 byte, 10 bytes as one data amount.
e every 100 bytes from e to 100 bytes, the number of cases from 1,10 to 100 every 10 cases, 100 to 1
Every 100 cases up to 000, 1 from 1000 to 10,000
For every 000 items, the search time in each case is measured in advance, and a chart of the estimated search time is made.

When the data amount of one case is 25 bytes and the number of cases is 1500, the search time estimating unit 3 increments the data amount by 30 bytes and increases the number of cases by 200
Assuming that the search time is 0, 600 seconds is obtained as the minimum search time expected from the expected search time chart of FIG.

Next, the search time estimating section 3 sends the estimated search time (600 seconds) obtained above to the input / output display section 1.
As shown in FIG. 4, the input / output display unit 1 includes a search time
Displays the time received from as the lowest expected search time.

Next, the data transfer section 2 issues a search command to the data table in the database computer (server) 4 again. The database computer (server) 4 receives the search condition from the data transfer unit 2, and the measurement time (column a) is 95/1 from the data table in the database computer (server) 4 shown in FIG.
0/21 12:00: 00 to 95/12/21 1
The data up to 2: 00: 0 is searched.

Next, the database computer (server) 4 sends data matching the search condition to the data transfer unit 2. Upon receiving the searched data, the data transfer unit 2 sends the searched data to the input / output display unit 1, and finally, the input / output display unit 1 displays the searched data as shown in FIG.

As described above, since the user can know the minimum expected search time before executing the search,
During the search, the user can leave the place to do another job, thereby improving work efficiency.

(Other Embodiments) In the above-described embodiment, the search time is predicted and displayed based on the data amount of one searched data table and the number of cases that satisfy the search condition. Providing a measuring means for measuring time and a storage means for storing the previous search time, and when a search condition is input, first, the previous search time stored in the storage means is displayed as an expected search time. Is also good.

[0033]

As described above, according to the present invention,
It is possible to know the search time in advance after inputting the search condition, and the user can leave the place and perform another job during the execution of the search, thereby improving the work efficiency.

[Brief description of the drawings]

FIG. 1 is a block diagram showing the overall configuration of an embodiment of the present invention.

FIG. 2 is a flowchart showing the entire search and display processing procedure in the embodiment.

FIG. 3 is a diagram showing a data table in a database computer (server) in the embodiment.

FIG. 4 is a diagram showing an input / output display screen in the embodiment.

FIG. 5 is a diagram showing a chart of expected search time used in the embodiment.

[Explanation of symbols]

 DESCRIPTION OF REFERENCE NUMERALS 1 input / output display unit 2 data transfer unit 3 search time estimation unit 4 database computer (server) 5 network 6 data search / display computer (client)

Claims (3)

[Claims] An input / output unit for inputting search conditions and outputting data, comprising: a database processing device having a plurality of data tables; and a data search / display processing device. It has a sending and receiving unit and a search time estimating unit for estimating a search time from input search conditions, and when searching an arbitrary data table, displays data after displaying the search time estimated by the search time estimating unit. A database reference device, characterized in that: 2. The database according to claim 1, wherein the search time estimating unit has a chart of an expected search time corresponding to the data amount and the number of data, and displays a minimum search time obtained from the chart. Reference device. 3. A search means for measuring a search time, and a storage means for storing a previous search time, wherein a search time estimating unit determines a minimum search time based on the search time stored in the storage means. A database reference device characterized by anticipation.