JPH05250335A - Data base update processing system of loosely coupled multiprocessor system - Google Patents

Abstract

PURPOSE:To reduce the load on a processor and to alter the transaction processing of its own system without being aware of synchronism with transaction processing of another system. CONSTITUTION:This system includes a data base access device 1 for its data base 6, an access DML storage device 2 for access key information, an access record storage device 3 for a record image after data base update, an after image editing device 4 for after image editing which updates the data base of the other systems according to access key information and the record image after data base update, and a shared file output device 5 which outputs the after image to a shared file 7 between its own system and the other system. In the other system, a shared file input device 8 from the shared file to the after image, an after image update device 9 for an instruction of access to the data base 11 of the other system and an instruction of update of the other- system data base as access information on the after image, and an input/output data base update device 10 for the other-system data base are provided.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database update processing method in a loosely coupled multiprocessor system, and more particularly in a method of updating a non-shared hierarchical database between loosely coupled multiprocessor system records The present invention relates to a database update processing method in a loosely coupled multiprocessor system in which the same record image as an image is held in another system's database, and the other system's database is updated after the own system's database is updated.

[0002]

2. Description of the Related Art Conventionally, in a method of updating a non-shared hierarchical database between loosely coupled multiprocessor systems, business processing is executed based on input data of the own system to update the own database. After that, the input data of the own system was passed to the other system, and the other system executed the same business process as the own system to update the database of the other system.

[0003]

The above-mentioned conventional technique executes the same business process as that of the local system when updating the database of the other system, and therefore executes the same business process twice in the multiprocessor system. Therefore, there is a problem that the load on the processor increases.

Further, there is a problem that a constraint condition that the business processing of the own system and the business processing of the other system are changed in synchronization is necessary.

[0005]

A database update processing method in a loosely coupled multiprocessor system according to the present invention is a database which is not shared between the systems of a loosely coupled multiprocessor system consisting of its own system and another system. If you have a database and you want to delay the update of other databases after updating your own database, a database access device for inputting / outputting your own database in your own system,
Access DML that stores access key information of its own database (DML is a data manipulation language Data M
abbreviation of "animation Language") storage device, access record storage device for storing record image after database update, and after image editing device for editing after image for updating other system database from access key information and record image after database update And a shared file output device for outputting an after image to a shared file between the own system and another system, and a shared file input device for inputting an after image from the shared file in the other system and an after image. An after image updating device for instructing access to the other system database according to the stored access information and for updating the other system database with the record image after the database update, and an instruction from the after image updating device. A database updating device for inputting / outputting the other system database is provided, and the record image after updating the own system database is delivered to the other system and the other system database is delayedly updated.

[0006]

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 database update processing system in a loosely coupled multiprocessor system of the present invention. FIG. 2 is a block diagram showing the storage form of the access DML storage device 2 of this embodiment. FIG. 3 is a block diagram showing the storage form of the access record storage device 3 of this embodiment. FIG. 4 is a configuration diagram showing the storage form of the after image of the present embodiment.

The loosely coupled multiprocessor system includes a database access device 1 for inputting / outputting a database, an access DML storage device 2 for storing access key information of a database, an access record storage device 3 for storing a record image after database update, After-image editing device 4 for editing an after-image for updating another database from the access key information and the record image after updating the database, shared file 7
Shared file output device 5 for outputting after image, own database 6, shared file 7 for passing after image between own system and other system, shared file input device for inputting after image from shared file 7 8. Access to the database according to the access information held in the after image, and the other system database by the record image after the database is updated 1
1, an after-image updating device 9 for instructing to update 1; a database updating device 10 for inputting / outputting the other-system database 11 according to an instruction from the after-image updating device 9;

The storage form of the access DML storage device 2 is
As shown in FIG. 2, a record identifier 21 indicating the type of record in the database and D used for record input / output.
DML identifier 22 representing ML, access information 23 representing a key used for record input / output, record identifier 2
Higher-level identifier 24 and record identifier 2 representing the parental relationship of 1
It is composed of key ranks 25 representing one hierarchical level.

As shown in FIG. 3, the storage form of the access record storage device 3 is composed of a record identifier 31, a DML identifier 32, and a record image 33.

The after image is as shown in FIG.
An access path 41 that represents access information to the update target record, a record identifier 42, a DML identifier 43, a record image 44, and the access path 41 is composed of a number of DML identifiers 45 and access information 46 corresponding to the number of hierarchical levels of the database. Has been done.

Next, a series of operations will be described.

When inputting / outputting a database in the own system, it is always performed via the database access device 1. When the database access device 1 inputs a record from the local database 6, the database access device 1 accesses the access command used to input the record and the record identifier 21 indicating the type of the input record to access the DML.
Hand it over to the storage device 2. The access DML storage device 2 stores the access information 2 and the DML identifier 22 corresponding to the record identifier 21 having the same value as the record identifier 21 of the input record.
Set the value to 3. The DML used in the access command is set in the DML identifier 22. The access information 23 includes
When a record having a key is input, the key of the access instruction is set, and when a record having no key is input, the access instruction does not have a key, so the order of records in the same set is set.

When the database access device 1 outputs a record to the local database 6, the database access device 1 outputs the DML identifier 22 used to output the record, the output record image and the record identifier 2.
1 is passed to the access record storage device 3. The access record storage device 3 stores the DML identifier 32 used to output the record, the output record image 33 and the record identifier 31.

The after-image editing mechanism 4 creates an access path 41 using the DML identifier 22 and the access information 23 stored in the access DML storage device 2, and the DML identifier 3 stored in the access record storage device 3.
The after image is created from 2, the record image 33, and the record identifier 31, and is passed to the shared file output device 5.

The access path 41 is created by setting the DML identifier 22 corresponding to the record identifier 21 having the same value as the record identifier 31 and the access information 23 in the key order 2.
5 is set in the DML identifier 45 and the access information 46 at the position shown in FIG. 5, and then the same processing is performed for the DML identifier 22 and the access information 23 corresponding to the record identifier 21 having the same value as the value of the upper identifier 24, Repeat until the value of 24 is empty.

The shared file output device 5 outputs the after image to the shared file 7. In the other system, the shared file input device 8 inputs an after image from the shared file 7 and passes it to the after image updating device 9.

The after-image updating device 9 uses the DML identifier 45 and access information 46 set in the after-image access path 41 through the database updating device 10 to position the other-system database 11 for updating the record. Then, the record image 44 is updated using the DML identifier 43 that is the update instruction information.

The positioning method for updating a record is as follows:
If a key is set in the access information 46, D
When the DML and the key set in the ML identifier 45 are used for access, and the record order in the set is set in the access information 46, the DML set in the DML identifier 45 is repeated for the number of record orders. Do by running.

As described above, the post-update record image of the own system database 6 is transferred to the other system to perform the delayed update of the other system database 11.

[0021]

As described above, according to the database update processing method in the loosely coupled multiprocessor system of the present invention, the record image after the database update of the own system is passed to the other system and the database of the other system is delayed and updated. Since it is not necessary to execute the same business process as the local system when updating the database of the other system, the load on the processor is reduced.

Further, since the business processing similar to that of the own system is not implemented in the other system, the business processing of the own system can be changed without being aware of the synchronization with the business processing of the other system.

[Brief description of drawings]

FIG. 1 is a configuration diagram showing an embodiment of a database update processing method in a loosely coupled multiprocessor system of the present invention.

FIG. 2 is an access DM in a database update processing method in the loosely coupled multiprocessor system according to the present embodiment.
It is a block diagram which shows the storage form of a L storage device.

FIG. 3 is a configuration diagram showing a storage form of an access record storage device in a database update processing method in the loosely coupled multiprocessor system of the present embodiment.

FIG. 4 is a configuration diagram showing a storage form of an after image in the database update processing method in the loosely coupled multiprocessor system of the present embodiment.

[Explanation of symbols]

 1 database access device 2 access DML storage device 3 access record storage device 4 after image editing device 5 shared file output device 6 own system database 7 shared file 8 shared file input device 9 after image updating device 10 database updating device 11 other system database

Claims (1)

[Claims] 1. A system in which a system of a loosely coupled multiprocessor system including a self system and a remote system has a non-shared self system and a non-system database, respectively, and the other system database is delayed and updated after the self system database is updated. A database access device for inputting / outputting an own database, an access DML storage device for storing access key information of the own database, an access record storage device for storing a record image after database update, and an access key After-image editing device that edits the after-image to update the other database from the record image after updating the information and database, and the shared-file output device that outputs the after-image to the shared file held between the own system and the other system Equipped with the other system,
A shared file input device that inputs an after image from a shared file, and an after image update device that issues an instruction to access another system database according to the access information held in the after image and instruct another database update after the database update And a database updating device for inputting and outputting to another system database according to an instruction from the after-image updating device, and the record image after updating the own system database is passed to the other system, and the other system database is delayedly updated. Database Update Processing Method for Loosely Coupled Multiprocessor Systems.