JPH05342179A - Data processing method for data base client/server distributed processing system - Google Patents

Abstract

PURPOSE:To shorten data processing time and to accelerate an entire distributed processing system for processing data in a data base while linking an application program(AP) to be operated on a terminal computer through a data base client system(DBCL) to a data base server system(DBSL) on a host computer. CONSTITUTION:The DBCL on the terminal computer is composed of an AP interface part 101 to receive the processing request of the AP and to return the processing result to the AP, protocol assembly/analysis part 102 to convert the processing request of the AP to a protocol or to convert a protocol transmitted to the DBSV to a certain form so as to return it to the AP side, and communication managing part 102 to exchange the protocol with the DBSV, and these constitutive parts are controlled by a control part 104.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data manipulation language (DML) from an application program (hereinafter abbreviated as AP) running on a terminal computer for data processing, via a database client system (DBCL).
Is a distributed processing system that operates a database (DB) linked to a database server system (DBSV) on a host computer by transferring
The present invention relates to a data processing method for a database client / server system that realizes a reduction in processing time by predicting and executing the DML that the AP requests next by using the communication time between CL and DBSV.

[0002]

2. Description of the Related Art A conventional data processing method between DBCL and DBSV is DML when DBCL receives a request from AP.
To the DBSV, the DBSV receives the DML, accesses the DB, and receives the processing result from the DB.
It is the repetition of transferring to the BCL.

FIG. 4 shows a conventional database client.
It is a structural diagram of a server distributed processing system. DBCL / D
Shows the connection of the BSV to the surrounding environment. Also, DBCL
-The functional components within the DBSV are described below.

The DBCL on the terminal computer receives an AP processing request and converts the AP processing request into a communicable format (protocol), and from the DBSV. A protocol assembling / analyzing unit 402 that converts the transmitted protocol into a format that can be returned to the AP side, and a communication management unit 403 that transmits / receives the protocol to / from the DBSV, and the control unit 404 controls them.

The DBSV on the host computer is a DB
A communication management unit 405 that transmits and receives a protocol to and from CL, and D
Convert the processing result after B access to the protocol, or D
The protocol assembly / analysis unit 406 that analyzes the protocol transmitted from the BCL and recognizes the processing request of the AP, and the DB access unit 407 that actually accesses the DB and receives the processing result, and the control unit 408 controls them. To do.

[0006]

In the database client / server distributed processing system, a user who performs data processing, via an AP operating on a terminal computer,
It is a system that reads and writes database data.

DML “record sequential reading (FETC) which is transferred when reading data required by the user
H) ”is particularly frequently used and is often requested continuously. In order to reduce the overall data processing time, F
It is required to reduce the data processing time of ETCH.

Further, it is possible to predict the DML requested by the AP next from the executed DML.

After sending the processing result, the DBSV sends the next DML.
Is a waiting state until the reception of, ie, a waiting time.

[0010]

DISCLOSURE OF THE INVENTION The present invention provides a distributed processing system in which an application program running on a terminal computer performs data processing of a database connected to a database server system on a host computer via a database client system. In the data processing method, the database operation is performed by the database server system after the database server system accesses the database from the data operation language transmitted by the database client system and the processing result is transmitted to the database client system. A means for predicting the language to access the database and holding the processing result, and a data operation language transmitted by the database client system are the database server. If the system is the same as predicted, the means for transmitting the retained processing result to the database client system and the data operation language transmitted by the database client system are different from those predicted by the database server system. For example, the means for saving the stored processing result in the temporary save area and the data operation language transmitted by the database client system are the same as those previously predicted by the database server system, and the processing result is temporarily stored. It is characterized in that it is provided with means for retrieving it when it is stored in the save area and transmitting it to the database client system.

[0011]

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

First, the functional configuration of the system configuration "database client / server distributed processing system" of the present invention will be described before describing the embodiments.

FIG. 1 is a block diagram of DBCL and DBSV of the present invention. Shows the connection of DBCL / DBSV to the surrounding environment. The functional components in DBCL / DBSV are described below.

The DBCL on the terminal computer receives an AP processing request, returns the processing result to the AP, and the AP interface unit 101, converts the AP processing request into a protocol, and converts the protocol transmitted from the DBSV into the AP. A protocol assembling / analyzing unit 102 for converting into a format that can be returned to the side, and a communication managing unit 103 for transmitting / receiving a protocol to / from the DBSV are controlled by a control unit 104.

The DBSV on the host computer is a DB
A communication management unit 105 that transmits and receives a protocol to and from CL, and D
Convert the processing result after B access to the protocol, or D
A protocol assembling / analyzing unit 106 that analyzes the protocol transmitted from the BCL and recognizes the processing request of the AP, and a DB that actually accesses the DB and receives the processing result.
The access unit 107 and the control unit 108 control these. Then, after the DBSV sends the protocol of the processing result, the DBCL receives it and the DBS again.
Until the processing request protocol is sent to V, D
The BSV is in a waiting state for receiving the processing request protocol, and is in a state where processing is stopped. Using that time, AP
Predicts the next requested process, executes the predicted process, and converts the process result into a protocol. Then, when the processing request protocol actually received from DBCL is as expected, the processing result protocol that has been created previously is transmitted, and when a processing request protocol different from the prediction is received, it is created first. The processing request protocol that was saved in the temporary save area before executing the processing request, or if a processing request protocol different from the prediction came, the received processing request was executed by the previous prediction processing, and the processing result is There is a predictive access unit 109 that takes out the processing result protocol if it is stored in the temporary save area and transmits it.

In this embodiment, as can be seen by comparing with FIG. 4, the DBSV control unit 108 and the predictive access unit 109 are connected.
It has a.

FIG. 2 is a diagram showing an example of a process of reading a record (FETCH) by the method of the present invention. When compared with FIG. 5, it can be seen that the response is faster as seen from the AP. Here, it is assumed that four records can be blocked and transferred on the communication buffer at one time. Also, t
, T2 ... Show processing times, and the total processing time is shown at equal intervals in order to make the process flow easier to understand.

First, the DBCL receives a request from the AP at the AP interface unit 101, assembles a requested protocol at the protocol assembling / analyzing unit 102 in accordance with the request, and sends it to the DBSV at the communication managing unit 103. The DBSV receives the requested protocol in the communication management unit 105, analyzes it in the protocol assembly / analysis 106, recognizes the AP request, accesses the DB in the DB access unit 107, receives the processing result from the DB, and assembles / analyzes the protocol. The processing result protocol is assembled by the unit 106 and transmitted to the DBCL by the communication management unit 105. The DBCL receives the processing result protocol by the communication management unit 103, analyzes the protocol by the protocol assembly / analysis unit 102, and the processing result by the AP interface unit 101. To A
Notify P.

Conventionally, the DBSV has been in the waiting state for receiving the request protocol after transmitting the processing result protocol to the DBCL. Use this waiting time. After transmitting the processing result protocol to the DBCL in the communication management unit 105, the predictive access processing unit 109 predicts the next request of the AP, the DB access unit 107 accesses the DB, receives the processing result from the DB, and assembles the protocol. The analysis unit 106 assembles the processing result protocol and waits for the request protocol to be transmitted from the DBCL. According to the AP's request, the communication management unit 105 receives the request protocol transmitted by DBCL, analyzes it by the protocol assembling / analyzing unit 106, and if it is the same as the previously predicted request, the protocol of the processing result response already created is used. The predicted access processing unit 109 takes out and the communication management unit 105 transmits. If it is different from the predicted request, the processing result protocol created by the predicted access processing unit 109 is saved in the temporary save area, the DB access unit 107 makes a DB access according to the AP request, receives the processing result from the DB, and the protocol assembly / analysis unit. At 106, a processing result protocol is assembled, and the communication management unit 105 transmits it to DBCL.

In the flow chart of FIG. 3, DBCL.D
The processing flow of each BSV is shown.

The DBCL inputs a request from the AP (step 301) and assembles a request protocol (step 3).
02), transmit (step 303), and wait for reception of the processing result protocol from the DBSV. DBSV is D
The request protocol sent from the BCL is received (step 311) and analyzed (step 312). When the AP request is recognized (step 313) and it is determined that there is no predicted and executed processing result (step 314), the DB is accessed (step 318) and a processing result protocol is assembled from the processing result (step 319). ), And transmit (step 320). Then, the next request from the AP is predicted (step 321), and the DB is accessed (step 32).
2), assemble the processing result protocol (step 3
23), enter the standby state for receiving the DBSV protocol. DBCL receives the processing result protocol sent from DBSV (step 304) and analyzes it (step 30).
5). The processing result is output to the AP (step 306).
Then, when the output of the result ends, the process returns to the input of the AP (step 501).

In step 314, if it is determined that there is a result of prediction and execution, and the prediction is correct (step 315), the processing result protocol created previously is extracted (step 316) and transmitted. (Step 320). Then, again, the process for predicting the next request of the AP (step 321) is started.

If it is determined in step 314 that there is already a predicted and executed result, and if it is determined in step 315 that the prediction is incorrect, the processing result protocol created earlier is saved in the temporary save area (step 317),
Access the DB according to the AP request (Step 3
18), assemble a protocol from the result (step 319), and transmit (step 320). And again A
The process (step 321) of predicting P's next request is entered.

FIG. 4 is a block diagram of a conventional DBCL and DBSV. Details are described in [Prior Art].

FIG. 5 is a diagram showing an example of a process of reading a record (FETCH) by the conventional method. Here, it is assumed that four records can be blocked and transferred on the communication buffer at one time. Further, t1, t2 ... Show the processing times, and the total processing time is shown at equal intervals in order to make the process flow easy to understand.

First, in the DBCL, the AP interface unit 401 receives a request from the AP, the protocol assembling / analyzing unit 402 assembles a requested protocol in accordance with the request, and the communication managing unit 403 sends it to the DBSV.

The DBSV receives the request protocol in the communication management unit 405, analyzes it in the protocol assembly / analysis unit 406 to recognize the AP request, accesses the DB in the DB access unit 407, and receives the processing result from the DB. The processing result protocol is assembled by the protocol assembly / analysis unit 406,
The communication management unit 405 transmits to DBCL. DBCL is
The communication management unit 403 receives the processing result protocol, the protocol assembly / analysis unit 402 analyzes it, and the AP interface unit 401 notifies the AP of the processing result.

[0028]

As described above, according to the present invention, the waiting time of communication is utilized to predict the AP request, and the DB is first searched.
By performing the access, the time from the request to the reception of the processing result can be shortened as seen from the AP.

[Brief description of drawings]

FIG. 1 is a structural diagram of the present invention of a database client / server distributed processing system.

FIG. 2 is a diagram showing an example of a data processing method of a database client / server distributed processing system in the system of FIG.

FIG. 3 is a flowchart of a database client / server distributed processing system.

FIG. 4 is a conventional structural diagram of a database client / server distributed processing system.

5 is a diagram showing an example of a data processing method of a database client / server distributed processing system in the system of FIG.

[Explanation of symbols]

 101 AP Interface Unit 102 Protocol Assembly / Analysis Unit 103 Communication Management Unit 104 Control Unit 105 Communication Management Unit 106 Protocol Assembly / Analysis Unit 107 DB Access Unit 108 Control Unit

Claims (1)

[Claims] 1. A data processing method of a distributed processing system, wherein an application program running on a terminal computer performs data processing of a database connected to a database server system on a host computer via a database client system. After the database server system accesses the database from the data manipulation language sent by the client system and sends the processing result to the database client system, the database manipulation is predicted next time and the database is accessed to access the database. Means for holding the processing result, and the data manipulation language sent by the database client system predicted by the database server system If they are the same, the processing result that is held is held if the means for sending to the database client system and the data operation language sent by the database client system are different from those predicted by the database server system. The processing result is stored in the temporary save area, and the data operation language transmitted by the database client system is the same as that previously predicted by the database server system, and the processing result is saved in the temporary save area. And a means for retrieving it when the data is present and transmitting it to the database client system.