JP2713669B2 - Terminals used in database search systems - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention, support is connected by a communication channel
Data that issues a database search request to the
For terminals used in database search systems,
Eliminates the time-consuming output of database search results
Can be used in database search systems
Terminal.

One form of a database system includes a plurality of clients that issue a search request to a database and a server that executes a database search process in response to the search request. In such a database system, when the number of search data greatly exceeds expectations, communication between the server and the client and inconvenience that the third CPU is occupied by a specific client for a long time occur. From now on, when constructing such a database system, it is necessary to take measures to eliminate the process of outputting the database search result which takes a long time.

[0003]

2. Description of the Related Art In a database system including a plurality of clients that issue a search request to a database and a server that executes a search process of the database in response to the search request, conventionally, the search data of the server is The client uses the configuration in which the judgment value of the number of search items for judging whether or not to output is set to an extremely large fixed value, and when the number of search cases of the search data searched by the server is smaller than the set judgment value. In addition, the search data is received from the server and output to the display screen, and when the search data is large, an error message is output to the display screen to request the designation of a new search method.

[0004]

However, if the method of setting the judgment value of the search data output process to a very large fixed value is adopted, the probability of outputting an error message is low. However, because the search condition is not properly specified, the error message is not output even when the number of search cases of the server indicates an extremely large value close to the above determination value. from now on,
In such a case, since the amount of search data transferred from the server to the client is extremely large, there is a problem that communication between the server and the client and the CPU of the server are occupied by a specific client for a long time. Will occur. In addition, there is a problem that the user who operates the client receives a large amount of search data that is unexpected and has little meaning.

[0005] The present invention has been made in view of such circumstances, and requires a server connected via a communication path to store data.
When adopting a configuration that issues a base search request,
Eliminates the time-consuming output of database search results
A new database search system that allows you to use
The purpose is to provide terminals that can be used.

[0006]

FIG. 1 shows the principle configuration of the present invention. In the figure, 1 is a database, 2 is a plurality of clients, which issue a search request to the database 1, and 3 is a server, which is a database 1
, And executes a search process of the database 1 in response to a search request of the client 2, a man-machine interface 4 connected to the client 2, and a connection 5 between the client 2 and the server 3. It is a communication channel.

Each client 2 sets a search request issuing unit 20 for issuing a search request to the database 1, a setting unit 21 for setting a maximum value of the number of searches to be searched and output, and a setting unit 21. and comparison means 22 for comparing the magnitude of the retrieved Search number of search data for up to search queries and server 3, and an output means 23 for outputting the retrieved data retrieved for servers 3 in the man-machine interface 4,
The maximum number of search cases set by the setting means 21
When determining that the number of search cases is larger, the server 3
Whether to issue a search data transfer request to
Deciding means 24 for deciding, and determining means 24
Termination means 25 for terminating the process when deciding to issue
Server than the maximum search number set by the setting means 21
When judging that the search number of 3 is smaller,
Issues a transfer request for all search data to server 3 and determines
When the means 24 decides to issue the transfer request, the server 3
Against the maximum number of searches set by the setting means 21
Issuing means 26 for issuing a search request for search data.
You.

On the other hand, the server 3 includes a search execution unit 30 for executing a search process of the database 1 and a search execution unit 30.
And a search result notifying unit 31 for notifying the client 2 of the searched search data and the number of searched cases.

[0009]

According to the present invention, the setting means 21 of the client 2
Sets the maximum value of the number of searches to be searched and output by interacting with the man-machine interface 4 before issuing the search request, for example. Then, the search request issuing means 20 determines a search condition by interacting with the man-machine interface 4 and issues a search request for the database 1 to the server 3 by specifying the determined search condition.

[0010] Upon receiving this search request, the search execution means 30 of the server 3 searches the database 1 to extract search data that satisfies the specified search condition and expands the search data in the work area (prior to this expansion). The previous search data developed in the work area is cleared), and upon completion of this search processing, the search result notifying means 31
First, the comparison unit 22 of the client 2 is notified of the search number of search data expanded in the work area.

When receiving the notification of the number of searches, the comparing means 22 of the client 2 compares the notified number of searches with the maximum number of searches set by the setting means 21, and receives the comparison result . The deciding means 24 is a setting means
Number of searches on server 3 over the maximum number of searches set in 21
When it is determined that
Requests the server 3 to transfer the search data.
Decide whether to issue. The decision of this decision means 24
Upon receiving the result, the termination means 25 of the client 2 determines
When the means 24 decides not to issue the transfer request,
Terminate. On the other hand, the issuing means 26 of the client 2
The maximum number of search cases set by the setting means 21
If it is determined that the number of searches is smaller,
Issues a transfer request for all search data to
When the deciding means 24 decides to issue the transfer request.
Is the maximum detection set by the setting means 21 with respect to the server 3.
A search data transfer request for the number of search cases is issued.

In response to the issuing process of the issuing unit 26,
The search result notifying means 31 of the server 3 transfers all search data.
When the request is issued, the search data expanded to the work area
Take out all of the data, transfer it to client 2 and set
Transfer of search data for the maximum number of searches set by means 21
When the request is issued, the search data expanded to the work area
From the data, retrieve the search data for the maximum number of searches.
And transfer it to client 2. And the transfer request
If not issued, do not perform search data transfer processing
Then, the process ends.

When receiving this search data, the output means 23 of the client 2 outputs the transferred search data to the man-machine interface 4 and ends the processing.

As described above, in the present invention, the judgment value of the number of search cases for judging whether or not to output search data is not treated as a fixed value as in the prior art, but is set according to the setting process of the setting means 21. Since the configuration in which the setting is variably set is adopted, the communication path 5 and the CPU of the server are not occupied by the specific client 2 for a long time due to the transfer of a large amount of search data. The user does not receive a huge amount of search data that is not meaningful.

[0015] Conventionally, when the number of search data is larger than the above-mentioned judgment value, processing is performed so as not to output search data at all.
In the present invention, since it is possible to adopt a method of outputting within that range, it becomes possible to execute an efficient database 1 search process.

[0016]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described below in detail with reference to embodiments. As described with reference to FIG. 1, the client 2 implementing the present invention does not fixedly set the value of the maximum number of searches to determine whether to output the search data of the server 3, but rather the user's request. In this case, a value is set freely. In the setting process of the maximum search number, for example, a setting screen of the operating environment as shown in FIG. In addition to setting whether or not to perform it by interacting with the user, and if there is an instruction to set the maximum number of search cases,
This is executed by interacting with the user and setting the “maximum number of search items” desired by the user in accordance with the area of the setting screen.

The process of displaying the operating environment setting screen is performed, for example, on a display screen as shown in FIG.
When an initial menu for selecting “query of search conditions” or “auxiliary processing” is displayed, and the user selects “auxiliary processing” from the initial menu, the operation proceeds to “setting of operating environment”. Display a display screen that allows the user to select “execute” and, if the user selects “Set operating environment” from this display screen, adopt a method of displaying the setting screen for operating environment. It can be realized with. Also, for example, a pull-down menu for selecting execution of “setting of operating environment” is displayed on a search condition setting screen as shown in FIG. 4A displayed by selecting “query of search condition” in the initial menu. When the user selects “operating environment setting (* part in the figure)” from this pull-down menu, the configuration shown in FIG.
This can also be realized by adopting a method of displaying the setting screen of the operating environment as shown in FIG.

FIGS. 5 and 6 show an embodiment of a processing flow executed by the client 2, and FIG. 7 shows an embodiment of a processing flow executed by the server 3. Next, the database search output processing according to the present invention will be described in detail according to these processing flows.

When the client 2 executes the processing for setting the maximum number of retrievals, as shown in the processing flow of FIG. 5, first, in step 1, the operation of FIG. 2 is displayed on the display screen of the man-machine interface 4. Display the environment setting screen. Next, in step 2, it is determined whether or not the user instructs to perform “setting of the maximum search number (area in FIG. 2)” on the setting screen of the operating environment. If it is determined in step 2 that “setting of maximum search number” is to be performed, in step 3 that follows, the user sets “maximum search number (area in FIG. 2)” on the setting screen of this operating environment. Execute the reception process of the value of the maximum number of search items input via the.

Then, in step 4, a process of accepting another parameter displayed on the setting screen of the operating environment is executed, and in step 5, the process proceeds to the bottom of the setting screen of the operating environment. It is determined whether the “execute” column or the “cancel” column provided is designated. If the “execute” column is designated, the process proceeds to step 6 and the new received A new operating environment is set by setting and registering the value, and when the “cancel” field is indicated, the process proceeds to step 7 and the received operating value is canceled to restore the original operating environment. I will keep it.

As described above, the client 2 uses the setting screen of the operating environment to execute the processing of setting the maximum number of searches desired by the user. On the other hand, server 3
When executing a search process of the database 1 in response to a search request from the client 2, as shown in the processing flow of FIG. By searching “1”, search data that satisfies the search condition is extracted. Next, in step 11, a work table of the search data is created by expanding the extracted search data in a work area. In step 12, when it is determined that the creation of the work table is completed, in step 13, The created work table is opened, and the search number is notified to the client 2.

Subsequently, in step 14, it is determined whether or not there is a request for transfer of the search data from the client 2 in response to the notification of the number of searches, and when it is determined that there is a transfer request, the subsequent step 15 is performed. Then, it is determined whether or not this transfer request specifies a transfer request for search data for the maximum number of search cases. If there is no designation as a result of the determination in step 15, the process proceeds to step 16 where all search data expanded in the work table is transferred to the client 2. If there is designation, the process proceeds to step 17. ,
The search data corresponding to the maximum number of search cases is selected from the search data developed in the work table and transferred to the client 2, and the process is terminated.

In this way, the server 3 retrieves the search data by searching the database 1 in response to the request from the client 2 and transfers the requested number of search data to the client 2 It is something to process.

On the other hand, the client 2 has a database 1
When the search process is executed, as shown in the process flow of FIG. 7, first, in step 20, a search request is issued to the server 3 by specifying search conditions. This search condition information is obtained by interacting with the user via the search condition setting screen shown in FIG. 4A displayed when “query of search condition” is selected in the above-described initial menu. . Next, in step 21, the process waits for a notification of the number of search results of the search result from the server 3 to be notified in response to the search request. When this notification is received, in step 22, the notification is made. The number of searches and the set value of the maximum number of searches are compared to determine which is greater.

If it is determined in step 23 that the notified number of searches does not exceed the maximum number of searches, the process proceeds to step 24 and issues a request for transferring all search data to the server 3. On the other hand, when it is determined that the notified number of searches exceeds the maximum number of searches, the process proceeds to step 25, where an error message as shown in FIG. It is determined whether the "continue" column or the "discontinuation" column provided at the bottom of the message is designated. If the "discontinuation" column is designated, the process is terminated as it is. The processing is performed so that the output processing of the search data is not executed, and if the “continue” column is indicated, the process proceeds to step 27,
The transfer request of the search data for the maximum search number is issued to the server 3. When the search data is transferred from the server 3 in response to the issuance processing in steps 24 and 27, in step 28, the transferred search data is output on the display screen of the man-machine interface 4. To end the processing.

In this manner, the client 2 outputs all the search data when the number of searches searched by the server 3 is smaller than the set maximum number of searches, otherwise, the client 2 outputs the desired search data. Accordingly, the search data corresponding to the maximum number of search cases is output, or processing is performed such that search data is not output at all. In accordance with the search data output process, the user can determine whether to specify new search conditions and search the database 1 efficiently.

[0027]

As described above, according to the present invention,
In a database system including a plurality of clients that issue a search request to a database and a server that executes a database search process in response to the search request, it is determined whether to output search data. Instead of treating the judgment value of the number of searches as a fixed value as in the past, it adopts a configuration in which it is set variably according to the user. Communication between the server and the CPU of the server is not occupied by a specific client for a long time, and the user does not receive a huge amount of search data that is not so significant.

In the prior art, when the number of search data items is larger than the above-mentioned judgment value, the search data is not output at all. Since it is possible to adopt a method of outputting within a database, it becomes possible to execute an efficient database search process.

[Brief description of the drawings]

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

FIG. 2 is an explanatory diagram of a setting process of a maximum search number.

FIG. 3 is an explanatory diagram of a setting process of a maximum search number.

FIG. 4 is an explanatory diagram of a setting process of a maximum search number.

FIG. 5 is an example of a processing flow executed by a client.

FIG. 6 is an example of a processing flow executed by a server.

FIG. 7 is an example of a processing flow executed by a client.

FIG. 8 is an explanatory diagram of an error message.

[Explanation of symbols]

 Reference Signs List 1 database 2 client 3 server 4 man-machine interface 5 communication path 20 search request issuing means 21 setting means 22 comparing means 23 output means 30 search executing means 31 search result notifying means

Claims (1)

(57) [Claims] (1) A server connected via a communication path receives data from a server.
Database search system that issues database search requests
Setting method to set the maximum value of the number of searches to be searched and output on the terminal used in the system
And the search items notified by the server in response to the search request issuance
And the maximum number of searches set by the setting means
The comparison means to be compared, and the comparison means means that the number of server search results is greater than the maximum number of search results.
When determining that the number is greater,
To determine whether to issue a search data transfer request
Determining means for determining whether or not to issue a transfer request;
Terminating means for terminating the process, and the comparing means is configured to search the server more than the maximum number of search results.
When determining that the number is smaller,
Issue a transfer request for all search data, and
When deciding to issue a transfer request,
Issue a request to transfer the search data for the maximum number of searches
From the server in response to the transfer request issued by the issuing means.
Output means for obtaining and outputting the sent search data;
A terminal used in a database search system.
End.