Replicated Table Attribute Management via Suspension

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

The challenge lies in efficiently managing and modifying replicated table attributes during data replication processes, especially when large data volumes are involved and transfer latency is high, as existing methods often disrupt the replication process and fail to utilize the full potential of new systems effectively.

Innovation Solution

A system and method that includes a table selector, suspension manager, and table attribute manager to suspend and resume data replication processes, allowing for changes to replicated table attributes without disrupting the transfer, using pre-stored change procedures and a graphical user interface for operator interaction.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If data replication is performed continuously without suspension, then data transfer completeness is improved, but table attribute modification capability deteriorates

Engineering Contradiction:

Improvedata transfer completenessVSAvoidtable attribute modification capability

Core Design Contradiction:

ReliabilityVSEase of operation

Solution Approach 1:

The system performs preliminary actions by suspending the replication process before allowing table attribute modifications. This ensures that changes can be made safely without disrupting ongoing data transfer, and the replication is resumed afterward to maintain data completeness.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The replication process is made dynamic by allowing it to be suspended and resumed. This enables the system to adapt between continuous operation (for data completeness) and paused state (for attribute modifications), resolving the contradiction between reliability and operational flexibility.

Inventive Principle:

Principle #15Dynamics

2Ease of operation

If data replication is suspended for attribute changes, then table attribute modification capability is improved, but data transfer time increases

Engineering Contradiction:

Improvetable attribute modification capabilityVSAvoiddata transfer time

Core Design Contradiction:

Ease of operationVSLoss of time

Solution Approach 1:

The system performs preliminary suspension only when attribute changes are needed, rather than maintaining a permanently paused state. This minimizes the time loss while still enabling necessary modifications to table attributes during the replication process.

Inventive Principle:

Principle #10Preliminary action

3Reliability

If data replication is performed on large datasets with high transfer latency, then data transfer completeness is improved, but processing time increases

Engineering Contradiction:

Improvedata transfer completenessVSAvoidprocessing time

Core Design Contradiction:

ReliabilityVSLoss of time

Solution Approach 1:

The system performs preliminary suspension of replication only when attribute changes are required, rather than continuously pausing. This approach maintains data transfer completeness for large datasets while minimizing the additional processing time introduced by suspensions.

Inventive Principle:

Principle #10Preliminary action

Data Source

PatentUS9563686B2Table attribute management for replicated data tables

Publication Date: 2017.02.07 SAP SE

AI summary

A table selector may receive a selection of a replicated table storing data replicated from an original table of a first system, the replicated table being stored using a second system and currently executing a process of receiving the replicated data. A suspension manager may suspend the process of receiving the replicated data, and a table attribute manager may change a replicated table attribute of the replicated table, while the process of receiving the replicated data is suspended. The suspension manager may then resume the process of receiving the replicated data.