Dynamic Data Consistency Correction in Distributed Transactions

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing methods for maintaining data consistency in distributed transactions, such as the saga pattern, face challenges in handling failures and require reconciliation processing, necessitating a technique to select appropriate data inconsistency correction methods based on transaction specifications and execution status.

Innovation Solution

A computer system that manages service and program information to select and execute data consistency maintenance programs dynamically, considering the specification and execution state of local transactions, to correct data inconsistencies.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If the saga pattern is used to divide transactions into local transactions, then data consistency can be maintained through compensation transactions, but reconciliation processing is still required to handle failures and confirm data consistency

Engineering Contradiction:

Improvedata consistencyVSAvoidreconciliation processing

Core Design Contradiction:

ReliabilityVSDevice complexity

Solution Approach 1:

The system enables automatic selection and execution of appropriate data inconsistency correction methods by the computer system itself, without requiring manual intervention or complex external reconciliation processing. The computer system autonomously determines which correction method to apply based on transaction specifications and execution status.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The system changes the parameter of correction method selection from manual/static to automatic/dynamic by implementing a selection mechanism that automatically chooses appropriate correction methods based on transaction specifications and execution status, thereby simplifying the overall system complexity.

Inventive Principle:

Principle #35Parameter changes

2Adaptability or versatility

If multiple data inconsistency correction methods are available, then flexibility in handling different transaction failures is improved, but the complexity of selecting the appropriate correction method increases

Engineering Contradiction:

Improvecorrection method selectionVSAvoidselection process

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The system implements a feedback mechanism where the computer system automatically selects correction methods based on feedback from transaction specifications and execution status. This automated feedback loop eliminates the need for complex manual selection processes while maintaining adaptability to different failure scenarios.

Inventive Principle:

Principle #23Feedback

Solution Approach 2:

The correction method selection is made dynamic rather than static, allowing the system to automatically adapt and choose appropriate correction methods based on real-time transaction specifications and execution status, thereby improving versatility without increasing operational complexity.

Inventive Principle:

Principle #15Dynamics

3Measurement precision

If manual selection of correction methods is required based on transaction specifications and execution status, then accuracy in applying the right correction method is improved, but the time and effort required for selection increases

Engineering Contradiction:

Improvecorrection method accuracyVSAvoidselection time

Core Design Contradiction:

Measurement precisionVSLoss of time

Solution Approach 1:

The computer system performs automatic selection of correction methods without requiring manual intervention, thereby eliminating the time loss associated with manual selection while maintaining high accuracy through automated decision-making based on transaction specifications and execution status.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The system performs preliminary setup by storing multiple correction methods and their associated conditions in advance, enabling automatic and accurate selection during failure scenarios without time-consuming manual analysis. The correction methods are pre-configured with their application conditions.

Inventive Principle:

Principle #10Preliminary action

Data Source

PatentUS20230325248A1Computer system and data consistency maintenance method

Publication Date: 2023.10.12 HITACHI LTD

AI summary

A data inconsistency correction method to be applied is selected in consideration of a specification of a transaction, execution status of the transaction, and the like. A computer system includes a computer that executes a service, is connected to a computer that divides a transaction across a plurality of services into a plurality of local transactions and executes the plurality of local transactions, and holds service management information for managing a specification of the local transaction in the service and program management information for storing a program for correcting data inconsistency and data associated with an application condition. The computer system selects the program to be applied based on the service management information, the program management information, and execution states of the plurality of local transactions when a failure of the transaction is detected.