Transaction Recovery Administration via Mediator Interface

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current systems lack a centralized mechanism for analysis and administration of global transaction participants, making failure analysis time-consuming and prone to errors due to the absence of administrative tools at the transaction manager level.

Innovation Solution

A transaction processing system that allows for resource-specific analysis and administration of global transaction participants, featuring a graphical user interface for users to issue commands and manage transactions through a transaction manager, enabling end-to-end administration and recovery of transactions.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If a centralized administrative mechanism for global transaction participants is implemented, then ease of operation and recovery capabilities are improved, but device complexity increases

Engineering Contradiction:
Improveease of operationVSAvoiddevice complexity
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The patent introduces an administrative mechanism that acts as an intermediary between users and the complex distributed transaction system. This mechanism provides a simplified interface that abstracts away the underlying complexity of coordinating multiple database resources across different physical locations, allowing users to manage global transactions without directly interacting with low-level APIs or database logs.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Device complexity

If manual problem solving through database logs and administrator contact is used, then device complexity is reduced, but loss of time and productivity decrease

Engineering Contradiction:
Improvedevice complexityVSAvoidloss of time
Core Design Contradiction:
Device complexityVSLoss of time

Solution Approach 1:

The patent implements a self-service administrative mechanism that enables users to independently analyze and recover from transaction failures without requiring manual intervention from database administrators. The system automatically provides tools to search transaction logs, identify failure causes, and execute recovery operations, thereby eliminating time-consuming manual problem-solving processes.

Inventive Principle:
Principle #25Self-service

3Device complexity

If basic reporting of recovery transactions is provided, then device complexity is kept low, but measurement precision and analysis capabilities are insufficient

Engineering Contradiction:
Improvedevice complexityVSAvoidmeasurement precision
Core Design Contradiction:
Device complexityVSMeasurement precision

Solution Approach 1:

The patent implements comprehensive monitoring and analysis capabilities that are prepared in advance, allowing the system to track and analyze transaction participant behavior before failures occur. This preliminary action enables precise measurement and analysis of transaction states, resource conditions, and failure patterns, providing detailed insights necessary for effective recovery decision-making.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS7970737B2Recovery administration of global transaction participants
Publication Date: 2011.06.28 ORACLE INT CORP
  • US7970737B2 patent drawing
  • US7970737B2 patent drawing
  • US7970737B2 patent drawing

AI summary

A transaction system that allows for analysis and administration at the global transaction participant level is disclosed.