JPH07230404A - High-speed data access system of network connection system - Google Patents

Abstract

PURPOSE:To decrease the frequency of communication and enable fast access by successively referring to next data on a host computer and continuously sending the data to a terminal computer when reference instructions succeed. CONSTITUTION:This system has communication means 14 and 21 which send and receive data between the host computer 10 and terminal computer 20, a sent data control means 22 which receives instructions and composes communication data on the terminal computer, a received data control means 23 which returns received data from the host computer, one by one, a received data control means 12 which decomposes the received data into the instructions on the host computer, a data base access means 11 which accesses the data base, and a sent data control means 13 which stores the data in a data storage table 15 and composes communication data of the stored data.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a high-speed database access method for a network connection system, and more particularly to a high-speed database access method for a network connection system that continuously refers to data when accessing a database of a computer system connected by a communication line. Regarding

[0002]

2. Description of the Related Art Conventionally, when accessing a database of a computer system connected by a communication line, transmission and reception were performed once for each command. As a result, even when a large amount of data satisfying the specified condition is referred to, communication processing occurs each time the subset created by the condition specification command is read by the data reference command, (the number of references x
2) was communicating once.

[0003]

In the above-mentioned conventional data reference method, data is transmitted / received for each instruction. Therefore, even when a large amount of data is continuously referred, the number of communications increases proportionally. However, there is a drawback that it takes time.

[0004]

A high-speed database access method for a network connection system according to the present invention is a communication means for transmitting and receiving data between a host computer and a terminal computer, and a database issued from an input device on the terminal computer. Determine the type of access command,
Transmission data control means for assembling communication data, reception data control means for storing data received from the host computer in a data storage table, and taking out and returning one data item from the table, and communication data on the host computer Received data control means for receiving and decomposing it into a reference instruction from the terminal computer, database access means for converting the reference instruction from the terminal computer into a database access instruction and accessing the database, and data received from the database access means Is stored in the data storage table one by one, and the transmission data control means for assembling communication data is stored when the data is stored to the end.

[0005]

Embodiments of the present invention will now be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of a high speed database access system of a network connection system of the present invention.

As shown in FIG. 1, the high-speed database access method of the network connection system of this embodiment is such that the communication means 21, the transmission data control means 22, the reception data control means 23 on the terminal computer 20 and the host computer 10 are operated. Database access means 11, reception data control means 12, transmission data control means 13, communication means 14
Composed of.

FIG. 2 is a flow chart showing an example of processing in the high speed database access method of the network connection system of this embodiment. The operation will be described with reference to FIGS. 1 and 2.

When referring to data satisfying a certain condition,
Normally, a process of reading a subset created by a condition specification command one by one by a data reference command is performed. First, the condition designation process will be described below.

The transmission data control means 22 on the terminal computer 20 determines the type of command issued from the input device 2. If it is a condition designation command, the transmission data control means 22 assembles communication data and passes it to the communication means 21. The communication data is sent to the host computer 10 by the communication means 21.

In the host computer 10, the communication data is received by the communication means 14. The reception data control means 12, which has received the communication data from the communication means 14, decomposes the communication data into a condition designating instruction and passes it to the database access means 11. The database access means 11 is
The condition designation command from the terminal computer 20 is converted into a database access command, the database 1 is accessed to create a subset, and the data length and the number of data items satisfying the conditions are obtained (step 31).

When the transmission data control means 13 receives the data length and the number of data from the database access means 11, the transmission data control means 13 assembles the data into communication data, and the communication data 14 is transferred to the terminal computer 20. Terminal computer 20
The data received from the communication means 21 is returned to the output device 3 by the reception data control means 23 (step 3).
2). Normally, in order to obtain all data, the data reference command for this number of data is issued from the input device 2.

Next, the data reference process will be described.

The transmission data control means 22 on the terminal computer 20 determines whether the database access command issued from the input device 2 is the first continuous data reference command. If it is the first continuous data reference command, the communication data is assembled and passed to the communication means 21. The communication data is
It is sent to the host computer 10 by the communication means 21 (step 33).

In the host computer 10, the communication data is received by the communication means 14. The reception data control means 12, which has received the communication data from the communication means 14, reads the information indicating that it is a continuous data reference instruction from the communication data, and issues the data reference instruction to the database access means 11.
Pass to. The database access unit 11 converts a reference command from the terminal computer 20 into a database access command, accesses the database 1, obtains one data item, and transfers the data item to the transmission data control unit 13.

The transmission data control means 13 stores the received data in the data storage table 15, and then passes a reference command to the database access means 11 to obtain the next data. The data received from the database access means 11 is continuously stored in the data storage table. The above process is repeated until the data storage table is full or the final data is stored (step 3).
4).

When the data storage table 15 is full, the transmission data control means 13 assembles it as communication data and passes it to the communication means 14. The communication means 14 transmits communication data to the terminal computer 20 (step 3).
5).

Further, the transmission data control means 13 passes the communication data to the communication means 14 and at the same time passes the reference command to the database access means 11. Then step 34
The same processing as the above processing is repeated (step 36).

On the other hand, in the terminal computer 20, the reception data control means 23, which has received the communication data from the communication means 21, decomposes the communication data and stores only the reference data in the data storage table 24. Reception data control means 23
Extracts one data from the data storage table 24 and outputs it (step 37).

When the command received from the input device 2 is the next reference command, the transmission data control means 22 passes the command to the reception data control means 23. The reception data control means 23
The next data of one case is taken out from the data storage table 24 and output. This process is repeated until there is no data in the data storage table 24 (step 38).

When there is no more data in the data storage table 24, the reception data control means 23 requests the communication means 21 to receive the next communication data and stores the reception data in the data storage table 24. After that, the same process as step 38 is repeated until all the data are output (step 39).

The processing up to obtaining all the data satisfying the conditions from the host computer 10 has been described above.

Finally, the process of interrupting data reception will be described. FIG. 3 is a flow chart showing an example of processing in the case of interrupting a data reference instruction in the high speed database access method of the network connection system of the present embodiment.

Before outputting all data, the input device 2
When the command other than the reference command is received from the transmission data control unit 22, the transmission data control unit 22 makes a reception cancel request to the communication unit 21 (step 41), assembles the command as communication data, and passes it to the communication unit 21 (step 42).

On the other hand, in the host computer 10, the communication means 14 having received the reception cancel request cancels the communication data transmission request of the transmission data control means 13 (step 43). The transmission data control means 13 that has received the cancellation request discards the remaining data in the data storage table 15 and notifies the reception data control means 12 of the information that the cancellation has been performed (step 44).

Thereafter, the reception data control means 12 receives the communication data from the terminal computer 20 (step 45).

[0027]

As described above, the high-speed database access method of the network connection system of the present invention is
When a continuous reference command is issued, data is continuously referenced on the host computer, the results are collectively transferred, and at the same time the next reference command is executed, resulting in a significant reduction in the number of communications and parallel processing. The waiting time can be shortened, data can be referred to at high speed, and it is particularly effective when referring to a large amount of data satisfying all conditions.

[Brief description of drawings]

FIG. 1 is a configuration diagram showing an embodiment of a high-speed database access method of a network connection system of the present invention.

FIG. 2 is a flowchart showing an example of processing in the high-speed database access method of the network connection system according to the present embodiment.

FIG. 3 is a flowchart showing an example of processing when a data reference instruction is interrupted in the high-speed database access method of the network connection system according to the present embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 database 2 input device 3 output device 10 host computer 11 database access means 12,23 reception data control means 13,22 transmission data control means 14,21 communication means 15,24 data storage table 20 terminal computer

Claims (1)

[Claims] 1. In a computer system connected by a communication line, a communication means for transmitting and receiving data between a host computer and a terminal computer, and an instruction for referring to the data of the host computer on the terminal computer are received and converted into communication data. Transmission data control means for assembling and passing to the communication means, reception data control means for returning data received from the host computer one by one,
On the host computer, reception data control means for decomposing communication data from the terminal computer into reference instructions from the terminal computer, and database access means for converting the reference instruction from the terminal computer into a database access instruction and accessing the database. A high-speed database access method for a network connection system, comprising: transmission data control means for storing the data in a data storage table, assembling the data as communication data to the communication control means, and delivering the communication data.