JPH0997200A - Client-server type database system - Google Patents

Abstract

It is possible to easily and accurately predict the processing performance when a processing request for a database is executed in a client-server type database system. SOLUTION: A log file for storing and registering a specific processing history of a database as log information,
A log information management unit that refers to a log file based on a new processing request from the client computer system and notifies the client computer system of log information related to another processing request similar to the processing request, and a server computer system. Further, a database processing requesting unit for presenting estimation information indicating predicted processing performance when the processing request is realized based on the log information notified from the server computer system in response to the processing request is provided in each of the client computer systems.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a client-server type database system, and more particularly, to a client-server that specifically predicts the estimated processing performance and responds from the server in response to a processing request specified by the client. Type database system.

[0002]

2. Description of the Related Art In the case of a personal computer, distribution software (for example, a well-known spreadsheet software that can execute tabulation, tabulation, recalculation, etc. at a high speed) with much higher operability than a workstation or mainframe is available. Many are provided. On the other hand, in the case of workstations and mainframes, along with the development of relational databases, many well-known database systems capable of collectively managing a large amount of data have been provided.

Therefore, in recent years, a part of data registered in a relational database (DB) constructed by a workstation or a mainframe is taken into a personal computer through a communication line or the like and processed by using the above-mentioned distribution software. There is a growing need for processing and editing. This is because a workstation or mainframe having a DB is a server computer system, and a personal computer that obtains necessary data from the DB by a predetermined processing request (a request to extract / update specified data, etc.) is a client computer system, and the server is the server. 1 is an example of a practical client-server type database system system in which a computer system and a client computer system are connected via a network.

In the above system, when the client side requests the server side to perform some kind of extraction or update processing request for the data in the DB, the user on the client side shows how much work amount ( It is general to estimate in advance whether the amount of work will be required. Conventionally, the server side is provided with means for obtaining estimation information such as the number of data items in the processing request and the total transfer amount to the client. Therefore, the user can obtain such estimation information from the server side to the client side. You can check the contents by displaying it on a display etc. Therefore, the user estimates the processing performance such as the execution time that will be required until the completion of the processing request based on his own experience while referring to the estimation information, and then directly specifies the processing request as it is. It has been determined whether the execution time should be shortened by executing the process again or by narrowing down the data again.

FIG. 8 is a diagram showing an example of the configuration of a conventional client-server type database system.
FIG. 9 is a diagram showing an example of a processing sequence executed by the system of FIG. The processing in the conventional system will be briefly described below with reference to FIGS. 8 and 9.

In FIG. 8 and FIG. 9, when the processing condition acquisition unit 111 in the client computer system 100 first receives a processing request input from the terminal device 101, the SQL creation unit 112 is based on this processing request and the database 206 A request for extraction / update processing described in SQL is issued (sequence 901). In the server computer system 200, the database processing control unit 204 receives the extraction / update processing request transmitted via the communication control unit 201 and the task management unit 202, and confirms whether the processing history information confirmation request is included. After that, a process execution request corresponding to the process request by SQL is issued to the database management unit 206 (sequence 902). Information regarding the corresponding data in the database 206 is sent from the database management unit 205 to the database processing control unit 204.
(Sequence 903), the database processing control unit 204, if it is confirmed in sequence 902 that the confirmation request of the processing history information is included, the database processing control unit 204 receives information such as the number of received data items. To the client computer system 100 (sequence 90
4). In the client computer system 100, the number-of-data cases is extracted from the information received by the number-of-data acquisition section 121, and the number-of-data display section 122 displays the number of data cases based on the information.
A response confirmation message as shown in (1) is displayed on the terminal device 101, and the system waits for a response confirmation. Then, when the user determines that the execution of the process is appropriate based on the content of the response confirmation message and past experience and performs the response confirmation operation of “OK” to the terminal device 101, the response content is stored in the server computer system 200. It is notified (sequence 905). The database processing control unit 204 determines whether the SQ
A request to execute the process by L is issued to the database management unit 205 (sequence 906), and the execution result is notified (sequence 907). The execution result is further notified from the server computer system 200 to the client computer system 100 and passed to the data receiving unit 141 (sequence 908) and then displayed on the terminal device 101 by the data display unit 142, or externally. It is stored in the external device 102 by the device storage unit. Finally, the client computer system 100 notifies the server computer system 200 of the completion of the series of processes (sequence 909), while the server computer system 200 notifies the client computer system 100 of the next process request wait notification. (Sequence 910).

[0007]

In the above prior art, when a client makes a processing request to a server for data registered in a DB managed by the server, the user who specifies the processing request is the server. It was possible to predict the processing performance such as the execution time that would be required until the completion of the processing request based on the estimation information notified from the user and his own experience. However, the predicted value of the processing performance obtained in this way is
It depends heavily on the experience of the user. Further, since the above-mentioned predicted value of the processing performance largely depends on the system environment such as the communication performance of the network in the client server system, the difference in the above-mentioned processing performance depending on the system environment is judged only from the number of processed data and the total transfer amount. It is virtually impossible to do. For this reason, the user can hardly grasp the above processing performance accurately before starting the specified processing, and the estimation of the above execution time etc. fails, and all the processing steps necessary to realize the specified processing request are executed. There is a problem in that it is often necessary to spend dead time in front of the client's terminal until the end.

An object of the present invention is to solve the above-mentioned problems and to complete the specified processing request based on the data showing the processing performance corresponding to various processing requests that have been made so far. Providing a client-server type database system that allows the user to easily and clearly judge whether or not the processing request is possible by estimating and presenting the predicted processing performance such as execution time more accurately and concretely than before. To do.

[0009]

To achieve the above object, a client-server type database system of the present invention comprises a server computer system for managing a database and at least one client for utilizing the database. In a client-server type database system in which a computer system is connected to each other via a network, a log file for storing and registering a specific processing history of the database that has been executed up to now as log information, and the client computer. A log information management unit that refers to the log file based on a new processing request for the database issued from the system and notifies the client computer system of log information related to another processing request similar to the processing request. When Is provided in the server computer system, issues the processing request to the server computer system, and based on the log information notified from the server computer system in response thereto, the predicted processing performance when the processing request is realized is A database processing requesting unit for presenting the estimated information is provided in each of the client computer systems.

Further, a plurality of log files in which the same log information is accumulated and registered are provided in the server computer system, and log information in each log file is optimized and arranged according to different conditions. Alternatively, the server computer system is provided with a log information analysis unit that analyzes the log information accumulated and registered in the log file and estimates the estimate information.

With the above-described configuration, when the client computer system attempts to extract / update the database of the server computer system, the predictive processing performance such as the time required for the processing is predicted. The user of the client computer system can easily obtain accurate information for doing so.

Further, the information representing the time required for the actual processing is accumulated and registered in a plurality of log files as log information, and is automatically optimized and arranged according to different conditions for each log file. By referring to the log files that meet the specified conditions, the abundantly accumulated log information can be searched quickly, and the prediction processing performance can be obtained more quickly and accurately.

Further, the server computer system analyzes the accumulated log information and estimates the prediction processing performance,
Quotation information such as the time required for processing and the optimal transfer method is notified to the client computer system as it is, so the client computer system or its user can easily select the optimal processing time and transfer method. It is possible to execute various processes.

As described above, based on the data indicating the processing performance corresponding to various processing requests that have been performed so far, the predicted processing performance such as the execution time that will be required until the completion of the specified processing request can be estimated. Since it is estimated / presented more accurately and specifically than in the past, it is possible to easily and clearly determine whether or not the processing request designated by the user.

[0015]

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of a client-server type database system of the present invention will be described in detail below with reference to the drawings.

FIG. 1 is a diagram schematically showing the overall configuration of an embodiment of a client-server type database system of the present invention. 100a is a client computer system, 101 is a terminal device, and 110a is a database processing request. Section, 150 is a communication control section (client side), 2
00a is a server computer system, 201 is a communication control unit (server side), 205 is a database management unit, 206 is a database, 210 is a log information management unit, and 220 is a log file (or log file group).

In FIG. 1, the client computer system 100a is provided with a database processing request unit 110a for making a processing request to the database 206 belonging to the server computer system 200a, and the server computer system 200a manages the database 206. A database management unit 205 and a log information management unit 210 that manages the log file group 220 are provided. Then, the communication control unit 150 of the client computer system 100a and the communication control unit 2 of the server computer system 200a.
01 transmits and receives data to and from each other via a network.

FIG. 2 is a diagram showing a detailed internal configuration of the system of FIG. 1, FIG. 3 is a diagram (part 1) showing an example of a processing sequence in the system of FIG. 1, and FIG.
It is a figure (the 1) which shows the display example of the quotation information and response confirmation message which are shown with a client computer system. 1 and 2, the same components as those in FIG. 1 are designated by the same reference numerals. Further, 111 is a processing condition acquisition unit, 112 is an SQL creation unit (client side), 121
a is a log information acquisition unit, 122a is a log information display unit, 13
1 is a terminal response confirmation unit, 132 is a response content transmission unit, 141
Is a data receiving unit, 142 is a data display unit, and 143 is an external device storage unit, which form the above-described database processing request unit 110a. Further, 202 is a task management unit, 203 is an SQL creation unit (server side), 204 is a database processing control unit, 211 is a log information management control unit, 2
Reference numeral 12 is a time monitoring unit, 213 is a log information reference unit, 214 is a log information registration unit, and 215 is a log information analysis unit. Of these, 211 to 215 are the log information management unit 2 described above.
10 is constituted. Hereinafter, an example of processing in the system of FIG. 1 will be described based on FIGS.

2 and 3, first, the processing condition acquisition unit 111 in the client computer system 100a.
When accepts the processing request input from the terminal device 101, the SQL creation unit 112 issues an extraction / update processing request described in SQL to the database 206 based on this processing request (sequence 301). In the server computer system 200a, the database processing control unit 204 receives the extraction / update processing request transmitted via the communication control unit 201 and the task management unit 202, and confirms whether or not the processing history information confirmation request is included. After that, a process execution request corresponding to the process request by SQL is issued to the database management unit 206 (sequence 302). Information regarding the corresponding data in the database 206 is sent from the database management unit 205 to the database processing control unit 20.
4 is responded (sequence 303), the database processing control unit 204 determines in the sequence 302 that the processing history information confirmation request is included in the log information management control unit 211. To confirm the detailed log information by passing the contents of the confirmation request to (sequence 3
04). Upon receiving this, the log information management control unit 211 causes the log information reference unit 213 to execute a plurality of log files 220.
Of the extraction / update processing request, which is similar to the processing execution request from the client computer system 100a, that is, history information, that is, log information is obtained (sequence 305).

The log information obtained in sequence 305 is
The log information acquisition unit 121a of the client computer system 100a is notified via the database processing control unit 204 (sequence 306). In the client computer system 100a, various information related to the prediction processing performance such as the number of data items and the number of bytes is extracted from the log information received by the log information acquisition unit 121a, and the log information display unit 122a displays the information shown in FIG. A response confirmation message including the quotation information as shown in a) is displayed on the terminal device 101, and the device waits for a response confirmation. Here, when the user responds with “log reference”, as shown in FIG. 4B, the time required for processing other processing requests similar to the specified processing request is similar history information. Is displayed, it becomes possible to predict the processing performance such as extraction / update and quickly determine whether or not the processing request is appropriate.
Work efficiency can be improved.

When the user judges that the execution of the process is appropriate based on the presented quotation information and similar history information, and performs an “OK” response confirmation operation on the terminal device 101, the response is the terminal response confirmation unit. After the confirmation in 131, the response content transmission unit 132 notifies the server computer system 200a via the communication control unit 150 (sequence 307). The database processing control unit 204 requests the database management unit 205 to execute the process according to the SQL according to the contents of the notification (sequence 308) and receives the notification of the execution result (sequence 309). The result of this execution is
Furthermore, the server computer system 200a notifies the client computer system 100a of the data reception unit 14
1 (sequence 310) and then the data display unit 1
It is displayed on the terminal device 101 by 42 or is stored in the external device 102 by the external device storage unit 143.

When a response is notified from the terminal device 101 (sequence 307), the server computer system 200
The task management unit 202 of a, according to the response content of the user,
If a scheduling process request that requires a long processing time is issued, the process request is issued to the database process control unit 204 at an arbitrary timing, and if an immediate process request is issued, the process request is issued to the database process control unit 204 immediately. Can be done to efficiently balance the load on the system.

When the display or storage of the execution result notified from the server computer system 200a is completed in sequence 310, the data receiving unit 141 of the client computer system 100a receives the result to the database processing control unit 204 of the server computer system 200a. A completion notification is given (sequence 311). In response to this, when the database processing control unit 204 notifies the log information management control unit 211 of processing completion, the log information management control unit 211
Inquires the processing time required from the start to the end of the processing to the time monitoring unit 212, and instructs the log information registration unit 214 to register the processing content and the processing time obtained above (sequence 312). The log information registration unit 214 registers various information as new log information with each processing time for each log file belonging to the log file group 220, and then notifies the log information management control unit 211 of completion of registration ( Sequence 313).

As a result, the processing history information newly generated in response to the processing request is automatically stored and registered in the log file as log information without the user being aware of the log file at all.

FIG. 5 is a diagram showing an example of log information accumulated and registered in a log file in the server computer system.

Further, the log information registration unit 214 of the server computer system 200a has a function of optimizing the log information of the log files belonging to the log file group 220 so that the log information is accumulated under the predetermined conditions. Therefore, the log information management control unit 211, which has received the registration completion notification in sequence 313, issues a log information optimization request to the log information registration unit 214 according to the state of each log file (sequence 314). The log information registration unit 214 performs optimization processing on each of the log files belonging to the log file group 220 in accordance with various conditions such as the reference frequency of data and the order of contents, and when the optimization processing is completed, the log information management unit 214 A log information optimization process completion notification is sent to the control unit 211 (sequence 31).
5). And finally, the client computer system 10
The next processing request waiting notification is sent to 0a (sequence 3).
16).

As described above, the processing history information is always accumulated and registered in the log file group 220 in an optimized state, and the target history information is efficiently searched for the reference request from the log information reference unit 213. Therefore, the response performance to the inquiry can be significantly improved.

FIG. 6 is a diagram (part 2) showing an example of the processing sequence in the system of FIG. 1, and FIG. 7 is a diagram showing a display example of the quotation information and the response confirmation message presented by the client computer system ( Part 2). Hereinafter, another example of the process in the system of FIG. 1 will be described with reference to FIGS. 2 and 6. It should be noted that the processing by the sequences 601 to 604 in FIG. 6 is the same as the processing by the sequences 301 to 304 in FIG. 3, and the processing by the sequences 607 to 616 in FIG. 6 is the same as the processing by the sequences 307 to 316 in FIG. Since they are the same, description will be omitted.

In FIG. 2 and FIG. 6, when the database management unit 205 responds to the database processing control unit 204 with information about the corresponding data in the database 206 (sequence 603), the database processing control unit 204 causes the log The contents of the confirmation request are passed to the information management control unit 211 to make an inquiry about detailed log information and prediction processing performance (sequence 604). In response to this, the log information management control unit 211 requests the log information analysis unit 215 to calculate / estimate the expected processing time for the corresponding processing request. The log information analysis unit 215 refers to the log information registered in the optimized log file group 220 to perform analysis / estimation processing, calculate an expected processing time for a processing request, and transfer method considered to be optimal. Then, the log information management control unit 211 is notified of the expected processing time, the transfer method, the similar history information, and the like that have been obtained (sequence 605).

These pieces of information are further sent to the client computer system 10 via the database processing control unit 204.
The log information acquisition unit 121a of 0a is notified (sequence 306). In the client computer system 100a, various information such as the number of data and the number of bytes, the expected processing time, the recommended transfer method, and the like are extracted from the information received by the log information acquisition unit 121a, and the log information display unit 122a displays the information based on the extracted information. A response confirmation message including quotation information as shown in FIG. 7 is displayed on the terminal device 101,
Wait for confirmation of response. Here, when the user responds with "log reference", as shown in FIG. 4B, the time required for processing other processing requests similar to the specified processing request is displayed. It is displayed as similar history information.

As described above, in the example of FIG.
Since the server computer system 200a is made to estimate the expected processing time that the user No. 1 has estimated, it is possible to more accurately grasp the expected processing time for the processing request and judge the validity of the processing execution. The efficiency can be further improved.

[0032]

As described in detail above, according to the client-server type database system of the present invention,
When an extraction / update process is performed from the client computer system to the database of the server computer system, accurate information for predicting the predictive processing performance such as the time required for the process will be stored in the client computer system. The effect that the user can easily obtain is obtained.

Information representing the time required for the actual processing is stored and registered in a plurality of log files as log information, and the log files are automatically optimized and arranged according to different conditions. By referring to the log files that meet the specified conditions, the abundantly accumulated log information can be quickly searched, and the prediction processing performance can be obtained more quickly and accurately.

Furthermore, the server computer system analyzes the accumulated log information and estimates the prediction processing performance,
Quotation information such as the time required for processing and the optimal transfer method is notified to the client computer system as it is, so the client computer system or its user can easily select the optimal processing time and transfer method. The effect that various processes can be executed is obtained.

As described above, based on the data showing the processing performance corresponding to various processing requests made so far, the predicted processing performance such as the execution time which will be required until the completion of the specified processing request is estimated. Since the estimation / presentation is more accurate and specific than the conventional one, it is possible to easily and clearly determine whether or not the processing request designated by the user can be performed.

[Brief description of drawings]

FIG. 1 is a diagram schematically showing an overall configuration of an embodiment of a client-server type database system of the present invention.

FIG. 2 is a diagram showing a detailed internal configuration of the system of FIG.

FIG. 3 is a diagram (No. 1) showing an example of the processing sequence in the system of FIG. 1;

FIG. 4 is a diagram (No. 1) showing a display example of quotation information and a response confirmation message presented by the client computer system.

FIG. 5 is a diagram showing an example of log information accumulated and registered in a log file in the server computer system.

FIG. 6 is a diagram (part 2) illustrating an example of the processing sequence in the system of FIG. 1.

FIG. 7 is a diagram (part 2) showing a display example of quotation information and a response confirmation message presented by the client computer system.

FIG. 8 is a diagram showing a configuration example of a conventional client-server type database system.

9 is a diagram showing an example of a processing sequence executed in the system of FIG.

FIG. 10 is a diagram showing an example of a response confirmation message displayed on the client computer system.

[Explanation of symbols]

 100a client computer system 101 terminal device 102 external storage device 110a database processing request unit 111 processing condition acquisition unit 112 SQL creation unit (client side) 121a log information acquisition unit 122a log information display unit 131 terminal response confirmation unit 132 response content transmission unit 141 Data reception unit 142 Data display unit 143 External device storage unit 150 Communication control unit (client side) 200a Server computer system 201 Communication control unit (server side) 202 Task management unit 203 SQL creation unit (server side) 204 Database processing control unit 205 Database management unit 206 Database 210 Log information management unit 211 Log information management control unit 212 Time monitoring unit 213 Log information reference unit 214 Log information registration unit 215 Log information analysis unit 220 log Files or log files

Claims (3)

[Claims] 1. A client-server type database system in which a server computer system for managing a database and at least one or more client computer systems for using the database are mutually connected via a network. Referring to the log file based on a new processing request for the database issued from the client computer system, and a log file for storing and registering a specific processing history of the database as log information, A log information management unit that notifies the client computer system of log information related to another processing request similar to the processing request is provided in the server computer system, and issues the processing request to the server computer system. ,this According to the configuration, a database processing requesting unit that presents estimation information indicating predicted processing performance when the processing request is realized based on the log information notified from the server computer system is provided in each of the client computer systems. Client-server type database system characterized by. 2. A plurality of the log files in which the same log information is accumulated and registered are provided in the server computer system,
The client-server database system according to claim 1, wherein log information in each log file is optimized and arranged according to different conditions. 3. A log information analysis unit for analyzing the log information stored and registered in the log file and estimating the estimate information is provided in the server computer system. The client-server type database system described in 2.