JPS63259742A - Resource synchronization control system - Google Patents

Abstract

PURPOSE:To reduce the number of times of communication and to realize a more efficient data processing system by performing the optimum synchronization processing for the processing system of respective resources by a resource group processing state control table. CONSTITUTION:The resource group processing state control table consisting of a resource group processing state bits string, which controls whether an update processing for the respective resource is being performed or not, and a resource list which holds the name of a resource group which is being processed by the update processing, is provided. At a transaction finish processing, as referring to the resource processing state control table, the resource group which is processed by the update processing, is known from the resource processing state bits string and the resource group list, and according to the situation of the update processing, when the update processing was not performed at all, and when the update processing was performed for only one resource, a first phase in the synchronization processing, consisting of the first phase (update insurance processing) and the second phase (finish processing), is omitted. Thus, the finish of the transaction between plural resources can be attained by the minimum synchronization processing.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a resource synchronization control method 1" for a data processing system, particularly in a distributed database system.

The present invention relates to a resource synchronization control method suitable for synchronizing data.

(Conventional technology) Conventional data processing sequence for multiple resource groups 1. .

The synchronous control method at the end of the
Manage each resource as described in Publication No. 63052.

For processing systems that control databases.

The database normal termination command (synchronous processing) was divided into two processing phases. Specifically, at -5°, synchronization is performed in the update guarantee processing (first phase).

After obtaining confirmation and confirming that all resources can be synchronized, perform the synchronization end process (second phase).

The synchronization is completed by notifying the end of the synchronization process.

It was something that could be accomplished. Therefore, communication between the 5 processing systems was required for each phase.8However,
One of multiple database resources.

Either the resource was not updated or...

If it is necessary to update only that one resource, update the resources of other database systems.

Since there is no need to ensure consistency of resources, there is no need to perform update guarantee processing in the first phase to obtain confirmation of synchronization processing.

In this way, when transaction processing is carried out across processing systems that manage multiple databases, it is a series of transactions that performs the synchronized processing.

The processing system of each database is the processing system for snails.

Guarantee that it was done in a timely manner, and that it will eventually become a force.

- This is to prevent a situation where the database processing system is unable to complete processing. .

[Problem that the invention seeks to solve]

In the above-described conventional technology, the synchronous processing at the end of a transaction is performed in two processes (phases), that is, at the same time.

Renewal guarantee processing to obtain confirmation of the period (17th A.

The process consists of a termination process (second phase) that notifies the end of transaction date processing to achieve the completion of the same period. Reduce the number of communications.

There is no consideration given to the point of extinction, especially when it comes to each device.

- If the database processing system is distributed, the communication load will increase and transactions will occur.

There is a problem that the time required for the silon processing becomes longer, and the time required to monopolize the resources of the database processing system also becomes longer, which adversely affects other processing.15 According to the present invention The purpose is 5. At the end of the transaction.

For the resources of the database processing system.

each database without compromising guarantees of resource integrity.

- Resources that reduce the number of communications between base processing systems.

The objective is to provide a synchronous control method.・、
3.

[Failure to solve the problem]

The above purpose is for transaction processing using each resource of each database processing system.

Check whether update processing is being performed on each resource.

A resource group list that holds the managed resource group processing status bit string and the name of the resource group that has been updated.

A resource group processing status management table consisting of a resource group processing status management table consisting of

Refer to the physical status management table, find out the resource groups that have been updated from the resource group processing status bit string and the resource group list, and perform the update process depending on the update process mode.

Of the synchronization/processing consisting of the 17th phase (update guarantee/processing) and the 2nd phase (termination process), if the update process is not performed at all or if the update process is performed using only the resources of -
15 is achieved by omitting the 17th ace.

[Effect]

The resource synchronization control method of the present invention is a distributed database.

- A transaction in a base processing system.

During the processing process, 1.
4. When update processing is performed on a resource, the bits of the resource group processing status bit string in the resource group processing status management table.

On, register the name of the updated resource in the resource group list, refer to the 1 resource group processing status management table at the end of transaction processing, and if update 5 processing is not performed on all resources. ,all.

If the second phase (termination process) is performed without performing the first phase (update guarantee process) for all resources, and the update process is performed only for - resources.

Perform the second phase on the resource that has been updated, and after successfully completing the 27th phase, perform the second phase on the other resources.
Perform 7 aids, and if update processing is performed on two or more resources, perform 17 aids on the resources for which update processing was performed, and once synchronization is confirmed, perform 17 aids on all resources. Since the operation 5 is performed to perform the second phase, transactions between multiple resources can be performed with minimal synchronization processing.

It is possible to achieve the end of Zakushi Sun. .

〔Example〕

An embodiment of the present invention is shown in FIGS. 1 to 5 below.

I will explain further. An example of the system configuration of the present invention is as follows.
As shown in the figure, each processing device consists of a CPU, a processing program, and a database management system (DB'MS).
has. In addition, each processing device has an online control program.

Communication control between processing devices is performed. Data is stored in each processing unit and one disk device, etc., and resources are managed.

ing. In addition, a resource group processing status management table, which will be described later, is provided in the processing program of each processing device.

With this kind of system configuration, it is completely finished.

An example of the control method according to the present invention will be explained using FIG. It also functions as a management system. The processing device A and the processing/processing device C process the data for the resources A and CK among the processing of the transaction 151 generated by the processing device B.

A management system that manages requested processing such as lighting and updates.

It is a stem.

A resource group processing status manager that manages the processing status of resource groups.

An overview of the contents of the management table is shown in Figure 2. Resources.

The group processing status management table is the processing program of the processing device.

The content consists of a bit string with a variable number of resource groups and a list of processed resource groups.

Next, using FIG. 1a, we will explain the processing associated with the start of a transaction. First, in the processing device B, the resource group processing status management table is initialized, and the transaction is started. (1). .

Then, when processing device B requests processing device A to refer to and update data, particularly when requesting processing 11 and data update processing (3) to device A, processing in processing device B is performed. First, the update/flag of the resource group processing status management table is set (2). After that, we inquire whether it is related to the update process or not, and when it is reported that it is related to the update process,
According to the report, the update flag is set 15 again separately (4). Resource group processing status management team.

Change the flag bits set before the pull update process.

Performs the logical product of the bits of the flag set after the new process,
An update flag is set for a resource that is in an update processing state. Similarly, for processing device C (5), 7.

(61, (Similar processing of (71) is performed, and similar processing of (81# (91
The processing of.

and manages the processing status of resource groups. .

FIG. 2 shows a flowchart of the process for managing the update processing status for the above-mentioned resources. -゛The process for this resource can be explained using the flowchart in Figure 2a as transaction processing.

The data update process depends on each resource.

Check for updates if requested. If there is a possibility of updating (11), turn on the update bit for the resource group processing status management table in processing device B (
12). When an update process is being performed on a resource, an inquiry is made as to whether the process is related to an update process, and if there is a report that the process is related to an update process in response to this inquiry (13), The update bit of the resource group processing status management table in the processing device B15.

When it is newly turned on and there is a possibility of updating as mentioned above.

The update bit and the update bit when there is a report.

Performs logical AND (14) to determine the resource group that is truly undergoing update processing.

Therefore, the number of resource groups in the resource group processing status management table is 9.1,
8.

The bit string is turned on and the resource group is updated.

Manage using the processing status management table.

In this way, the update state management process for the resources in FIG. 2a.

The transaction of FIG. 1a is completed.

When the process (10) is started, it is shown in FIG.

Refer to the resource group processing status management table and select resources.

Processing device B of B performs the same processing according to the processing status of each resource.

control the periodic processing and reduce the number of communications.

Controls transaction processing. More than.

FIG. 6 shows the flow of the synchronization process. 1 (1)
In other words, in FIG. 1, the update status is managed.

The results are retained and updated in the resource group processing status management table.

Using this table, explain the synchronization control process.

The result is shown in Figure 3.

FIG. 3 shows how to manage transaction processing.

In the termination processing of Ranzaxiron, the following termination synchronization processing is performed. Refer to the bit string for the number of resource groups in the resource group processing status management table and check whether all bits are off.15) If all bits are off, it is assumed that no update processing has been performed, and each processing Synchronization end processing C (second phase) is performed to notify the device of the end of the transaction (22). Next, check whether only 1 bit is on (1/l), and if only 1 bit is on, processing of the resource group processing status management table is performed by the processing/device that has the resource with the bit on according to the resource 5 group list. In contrast, synchronization end processing C (second phase)
If it is not a rollback (18), the synchronization end process C (second phase) is performed for other resource processing devices.
(19). In this way, all bits are off 10
Or, if only one bit is on, the update process was not performed on other resources, so check that the update process is complete.

There is no need to perform update guarantee processing in the first phase to ensure synchronization processing. In addition, if multiple bits are on, the first phase of synchronization processing is performed for each of the 15 processing devices that manage the resources with the bits on.

Execute the new warranty process Pr-C (20) and click Rollno.

If (21)%, perform synchronous termination processing for the can processing device.

Take C (second phase) (22).

As described above, synchronous processing is performed according to the processing status.

We will conclude all dealings with Trump.

Next, let's talk about the processing associated with the end of the transaction.

The individual processing patterns are shown in FIG. 1, which shows an example of control for each processing state of each resource.

Xl is an example of the case where the maximum number of communications is ``in this transaction ``/process. In this example, update processing was performed on all three resources.

In this case, update 10 guarantee processing (Pr-C) is applied to each of the three processing devices to obtain confirmation of synchronization processing, which is the first step, for the processing devices that manage each resource.

Do it against. If there is confirmation from all management systems.

If it cannot be obtained, for example, an update process is performed.

If one of the resources is locked and becomes blocked, or becomes in a failure state, the update process in the 1' run sequence process will definitely be completed.

I have not completed the update guarantee process (Pr-C).
Even if this happens, there is no guarantee that the synchronization process is complete. Also, simple.

There are cases where the update process is not completed even after it is completed. In such a case, the rollback process will restore 2j, 11
.

Then, the processing units for each resource are returned to the starting state of the transaction. If all the confirmations are obtained, the second phase synchronization termination process fcl is performed on each processing device to notify the end of the transaction process, and all processes related to the transaction process are completed. It ends.

X3. Xn is an example where the number of communications is the minimum in this transaction process. In this example, only one resource is updated, or all resources are not updated. In the former case, the update process is applied to a group of resources other than the updated resource. .

Confirm the completion of the update process and obtain confirmation of the synchronization process.

Processing in the first phase can be omitted. First, the update line.

Synchronization end processing (C1) for the processing device of the resource.

All processing devices, if the processing performed is not successful.

Perform a rollback. If successful, leave.

Perform synchronization end processing (C1) on the other processing device.

This is the end of all processing related to Ranzalaceniformes.

Even in the latter case, the update process has not been performed.

After confirming the completion of the update process to the resource group, synchronization process 7,1
1. 12. You can omit the 17th aes to confirm the theory. Follow me,
Only the synchronization termination process fcl is performed for each resource.

X2 is an example of a case where, in this transaction processing, search processing is performed on processing device A of resource A, and update processing is performed on processing devices of other resources. In this example, synchronization processing is not divided into phases for the resource processing device for which only search processing has been performed, and the first phase is applied only to the resource processing device for which update processing has been performed. Perform update guarantee processing (Pr-C), which is synchronization processing of Phase 10.

After confirmation is obtained, transaxilon processing is performed.

Synchronous termination processing of the second phase for notifying termination.

This is to perform synchronization termination processing for the physical device A.

According to this embodiment, 1- at the end of a transaxilon.

Then, refer to the resource group processing status management table and check the relevant information.

Resource group processing status bit string and resource group in the table.

Update processing status of each database resource.

Check and update the resource name related to the status and update process.

For resource groups that were not processed or updated.

omit the first phase to ensure synchronization when the process is performed only at the time of transaction, reduce the number of communications between the processing systems of each database, and ensure completion of transaction/seal processing. This has the effect of allowing efficient resource synchronization control.

In addition, when processing transactions using multiple database processing systems as in this embodiment, efficient synchronization processing as described above is performed, so that late data update processing is possible. Even if there is a processing device that has not completed the process, consistency among the processing devices of a plurality of resources can be achieved without erroneously terminating the transaction.

〔Effect of the invention〕

According to the present invention, when a transaction transaction is processed across a plurality of resources, the transaction transaction processing is performed using the resource group processing 15 state management table.

Synchronous control to ensure that each resource terminates.

Optimal synchronization processing for each resource processing system.

By doing so, the number of communications can be reduced and more.

It has the effect of realizing an efficient data processing method.

[Brief explanation of drawings]

FIG. 1 is a schematic diagram of transaction processing for multiple resources according to an embodiment of the present invention, FIG. 2 is a flowchart of processing for the resources in FIG. FIG. 43 is a diagram showing a correspondence table between resource processing and transaction scene end processing, and FIG. 5 is a block diagram of the system of the present invention. 1-9...Data processing, 10...Transaction end processing, IQ15-22
...Synchronization processing in consistency control, X1 to Xn...
Panoon of synchronization processing examples in consistency control. r----------- Figure 3 Ton size final 3 processing

Claims (1)

[Claims] (1) Synchronization consisting of transaction processing in a distributed database system that has multiple data resources, update guarantee processing to ensure synchronization for each resource after transaction processing, and synchronization termination processing to complete synchronization. In the processing method, a table is provided in the system to manage the status of update processing for each resource, and when a request for update processing of a data resource is made in transaction processing, the update processing is being executed for the data resource. is registered in the table, and at the end of transaction processing, the table is referenced, and if update processing is not performed on any of the resources, synchronization completion processing is performed for all resources. If the update process is performed on only one resource, the synchronization end process is first performed on the updated resource, and after the synchronization end process is successful, the synchronization end process is performed on all other resources. If update processing is performed on two or more resources, update guarantee processing is performed to obtain synchronization confirmation for the updated resource, and if synchronization confirmation is obtained, synchronization end processing is performed on all resources. A resource synchronization control method characterized by performing the following.