JPH0342741A - Updating system for distributed data base in inter-host communication - Google Patents

Abstract

PURPOSE:To attain the asynchronous execution of a reception processing and a file update processing by separating the reception processing of a reception- side host and the file update processing by means of reception data and storing received update information into a temporary storage file in terms of logical data meanwhile. CONSTITUTION:A transaction starting means 4 receives key information transmitted from a reception data input means 2, and gives key information to a file update means 5. It receives key information from the transaction starting means 4, receives reception data in inter-host communication, reads data from the reception data temporary storage file 3, logically and exclusive by controls a job processing file to be updated, updates the job processing file, deletes data from the temporary storage file 3, and a key information transmission processing which is necessary for the cancel of the processing when re-execution is required and for the starting of the transaction starting means 4 is executed.

Description

DETAILED DESCRIPTION OF THE INVENTION (Industrial Application Field) The present invention relates to distributed database update processing through host-to-host communication, and particularly to reception processing based on update information received at a receiving host and asynchronous file update processing. This paper relates to a distributed database update method using host-to-host communication.

(Prior Art) Online host-to-host communication is currently widely used in distributed processing systems because it has the advantage of allowing real-time data communication between hosts.

In conventional distributed processing systems, various processes such as registering, updating, and deleting data in business processing files are performed on different hosts at any time, and files can be shared by multiple transaction processing programs. It is said that For this reason, in file update processing, logical exclusive control of files is performed in order to preserve the execution results of each transaction process and ring program. Regarding host-to-host communication, logical exclusive control is also required when update information of a file processed by the sending host is sent to the receiving host, and the receiving host updates the file with the received data that is this update information. Become.

In the conventional technology, a single transaction processing program performs reception processing and file update processing using received data. Therefore, if logical exclusive control is applied to a file and the exclusive control is unsuccessful, the transaction processing program will wait for exclusive release.
Meanwhile, reception processing has also stalled. Additionally, after receiving the data, the data is saved in the memory and the first file is updated, so the received data cannot be held during that time.

Therefore, in the conventional method, it is difficult to perform reception processing and file update processing using received data in parallel. Only data that does not require the receiving host to update the file based on the received data, or data that does not require update processing from other transaction processing programs on the receiving host, although the file may be updated using the received data, It can be used for inter-communication. For data other than this, we have dealt with it by using other methods such as batch processing without using inter-host communication.

(Problems to be Solved by the Invention) In the above-described conventional file update processing using received data in inter-host communication, when logical exclusion of a file is unsuccessful,
Because the transaction processing program enters the logical exclusion release wait state, the reception processing also becomes stagnant.
This method has disadvantages in that the speed of communication between hosts is reduced, the processing efficiency of the receiving host is reduced, and it is difficult to synchronize transmission processing and reception processing.

On the other hand, the file update has finished after receiving! Since the data is not held in the file during this time, there is also the disadvantage that data integrity cannot be maintained if a failure occurs in the file update process.

It is an object of the present invention to eliminate the above-mentioned drawbacks by separating the reception processing of the receiving host and the file update processing using the received data, and during this time, storing the received update information in a temporary storage file in units of logical data. An object of the present invention is to provide a distributed database update method for communication between hosts that enables asynchronous execution of reception processing and file update processing.

(Means for Solving the Problems) A distributed database update method using host-to-host communication according to the present invention includes a received data input means, a temporary storage means, a file update means, and a transaction activation means. It is.

The received data input means is used to update the database constituting the business processing file on the sending host in the online distributed system, and to receive the updated information at the receiving host through host-to-host communication.

The temporary storage means is for sequentially storing received data input by the received data input means.

The file update means reads the received data from the temporary storage means, applies logical exclusive control to the file using the key of the data, and when the exclusion is successful, updates the business processing file with the read received data, and This is to physically delete the data, cancel the file update process if exclusion is unsuccessful, and pass control to the online control program so that it can be executed by the transaction starting means at the preset re-execution start time. be.

The transaction activation means updates the key information to the file when receiving the key information of the received data inputted from the received data input means or when receiving the key information of the received data again in order to re-execute the file updating means. This is for sending the file to the file updating means and activating the file updating means.

(Example) Next, the present invention will be explained with reference to the drawings.

FIG. 1 shows the constituent countries of an embodiment of a distributed database update method using host-to-host communication according to the present invention.

In FIG. 1, 1 is a distributed database update system;
2 is a received data input means, 3 is a temporary storage file, 4 is a transaction activation means, 5 is a file update means, 1
4 is update information (data).

The distributed database update system 1 includes a received data input means 2, a temporary storage file 3, a transaction activation means 4, and a file update means 5.

The substance of the received data input means 2 is a transaction processing program, which receives received data through host-to-host communication.
The received data is stored in the temporary storage means 3 and the key information of the received data is stored in the transaction activation means 4. The entity of the temporary storage means 5 is a business processing file, which stores data sent from the received data input means 2 and transfers the data to the file update means 5. The substance of the transaction activation means 4 is a transaction control program applied to the online system, and receives key information sent from the received data input means 2, passes this key information to the file update means 5, and starts the file update means 5. do. The substance of the file updating means 5 is a transaction processing program, which receives key information from the transaction starting means 4, reads data from the temporary storage file 5, applies logical exclusive control to the business processing file to be updated, and executes the transaction processing file. It updates the data, deletes the data from the temporary storage file 3, and executes the key information transmission process necessary for canceling the process when re-execution is required and activating the transaction starting means 4.

FIG. 2 is an explanatory diagram showing the structure of physical data of update information for communication between hosts. The data is divided into control information and messages, and the control information mainly contains information necessary for communication between hosts. However, this includes a message classification indicating the type of message as logical data. The message is divided into a key part and a data part, which contain actual file update information. The key part contains key information for business processing data, and the data part contains data update information. This physical data is created in the above structure when the sending host performs transmission processing in inter-host communication, and the received data input means 2
The received data is received from the host-to-host communication in units of physical data, and the message part from which the control information has been removed is stored in the temporary storage means 3. The logical format of this update information may be a single data message format consisting of only - items of physical data, or a group data message format consisting of a plurality of physical data. For example, consider data from a product inventory file. In a format in which each product has a single piece of data, when information about a certain product is updated, - pieces of data are updated, and a message consisting of a single piece of data is sent and received through host-to-host communication. However, in a format where several products are placed in one order unit and one piece of logical data is made up of multiple data, if the file is updated after - orders, the overall information for the order and the detailed information for each product will be updated. will be updated. Therefore, data messages of a group consisting of a plurality of pieces of data are transmitted and received in inter-host communications.

In this embodiment, a group data message will be explained as an example. Even in the case of a group data message, the receiving data input means 2 receives the data in units of physical data, and sequentially stores the message parts in the temporary storage file 3.

When storing data in the temporary storage file 3, the data is stored in logically meaningful groups based on the message classification.

FIG. 4 is an explanatory diagram showing the structure of a group data message (logical data) in communication between hosts. A data message consists of n pieces of physical data, and the first data of the n pieces of physical data has the message classification -FN% second
Message classification % for data from th to n-1st.
M#, the nth data contains the message classification %Lp.

The content of the message is arbitrary depending on the processing task.

FIG. 8 is a flowchart showing a processing method of the distributed database update method in communication between hosts shown in FIG.

Next, one embodiment of the process will be described in detail along the flowchart of FIG.

The file update information processed by the sending host is stored in a sending file by the data sending processing program of the sending host, and is sent to the receiving host through host-to-host communication. As can be seen in Figure 1, in the user distributed processing system, files A and B are stored on the sending and receiving hosts respectively.
, C1...File A%B, C,... are held, and these files are processed independently on each host. Inter-host communication sends and receives file update information regarding the contents of these independently processed files that need to be made consistent on both hosts.

The receiving host receives one piece of update information in units of physical data using the received data input means 2, and if the message classification is %F#, writes the data to the temporary storage file 3 and processes it. finish. Thereafter, each time received data is sent, the physical data is sequentially received, and as long as the message classification is 1MN, the data is written one after another into the temporary storage file 6 as data messages of the same group, and the processing is completed. These operations are performed as in step 20.21.

Next, when data whose message classification is %L' is received, this final data is written to the temporary storage file 3, and at the same time, the key information of the received data is sent to the transaction activation means 4, and control is passed to the transaction activation means 4. The process ends. These operations are performed in step 22.

Through the above process, data reception is completed and
It is held in the temporary storage means 3, and other processing is performed after the transaction starting means 4 operates. Therefore, the received data input means 2 can immediately start receiving processing when the next group data message arrives.

(12) Next, the transaction activation means 4 which received the key information of the received data and was activated transmits this key information to the file update means 5 and activates it. This operation is performed in step 23. The file updating means 5 receives the key information in step 24, and uses this key to read data from the temporary storage file 3 in step 25.

Next, in step 26, logical exclusive control is applied to the business processing file on the receiving host side using the same key.

If the exclusion is successful, processing such as registration, updating, or deletion in the business processing file is performed in step 2γ according to the contents of the received data successively sent to the temporary storage file 3. In step 28, the next data is read. If the key value received from the transaction activation means 4 and the key value of the received data read from the temporary storage means 3 do not match, or if there is no received data, step 27 is performed.
．． Repeat the process in step 28. When the file update is completed normally, exclusive control of the business processing file is released using the same key in step 29. Then, using the same key (13), the temporary storage file is read again, the data is physically deleted in units of data messages of the group, and the file update process is completed. These are performed by step 30.

If the logical exclusive control in step 26 is unsuccessful,
As logical exclusion error processing, necessary key information is transmitted to the transaction starting means 4, which is a transaction control program, so that the processing performed by the file updating means 5 can be canceled and the file updating means 5 can be re-executed. These operations are performed in step 31.

At this time, the key information to be transmitted consists of the 40 transaction initiating means that activate the file updating means 5, the re-execution start time set in advance in the system, the key information of the received data currently being processed, etc. It is.

Next, the same key is used to release the logical exclusive processing of the business processing file, and the processing ends. This operation is performed by step 32.

If the file updating means 5 ends the file logical exclusion process (14) without success, control is transferred to the transaction starting means 4, and when the re-execution start time is reached, the transaction starting means 4 is started.

This operation is performed by step 33.

In this way, steps 22 to 27 and steps s1 to 33 are repeated until the file update process is successfully completed.

Through the above process, the file update process can be executed while retaining the group data message, which is the received data in the temporary storage file 3, while avoiding the problem of logical exclusion of files with other transaction processing programs. Furthermore, these processes can be performed asynchronously and independently of the reception process of communication between hosts.

(Effects of the Invention) As explained above, the present invention separates the reception process of the receiving host and the file update process using the received data, and during that time, stores the received update information in a temporary storage file in units of logical data. This has the effect of eliminating the above-mentioned drawbacks, separating the reception processing (15) of communication between hosts and the file update processing using received data, and making it possible to execute both processing asynchronously.

This allows reception processing to be executed continuously without being affected by logical exclusive control during file update processing, so transmission processing and reception processing can be synchronized, improving the reliability and speed of communication between hosts. do.

In addition, in file update processing, by applying logical exclusive control of files on a transaction processing program basis, there is no need to wait for logical exclusion release, and file update processing can be automatically re-executed, resulting in efficient file updates. There is.

! In addition, separation of information on reception processing and information on file update processing leads to localization of failures. b1 File storage of received update information in logical data units leads to preservation of received data before file update. This has the effect of facilitating recovery in the event of a file failure and reducing operational man-hours.

[Brief explanation of drawings]

FIG. 1d, Distributed host-to-host communication according to the present invention (16
) FIG. 2 is a block diagram showing the configuration of an embodiment of a database update method. FIG. 2 is an explanatory diagram showing the structure of inter-host communication data processed by the distributed database update method in the inter-host communication of FIG. 1. FIG. 4 is a flowchart showing the processing method of the distributed database update method in the host-to-host communication of FIG. It is an explanatory diagram showing -FIJ of 1...Distributed database update system 2...Received data input means 3...Temporary storage means 4...Transaction starting means 5...File update processing means

Claims (1)

[Claims] Received data input means for updating a database constituting a business processing file on a sending host in an online distributed system, and receiving the updated information at a receiving host through host-to-host communication; temporary storage means for sequentially storing input reception data; reading the reception data from the temporary storage means; applying logical exclusive control to the file using a key of the data;
When the exclusion is successful, the business processing file is updated with the read received data, and the same data in the temporary storage file is physically deleted, and when the exclusion is unsuccessful, the file update process is canceled, and When receiving key information of the received data inputted from the file updating means and the received data input means, or when the file updating means receives the key information of the received data inputted from the received data input means, in order to transfer control to the online control program so that it can execute itself at the re-execution start time. When receiving the key information of the received data again for re-execution, sending the key information to the file updating means;
1. A distributed database update method using host-to-host communication, characterized in that the method includes transaction starting means for starting a file updating means.