Data Replication Tracing Topology for Multi-Tier Infrastructure

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

In complex modern data processing environments, tracking data flow through replication systems across hundreds of servers and databases is difficult due to their size and complexity, making it challenging to maintain a comprehensive understanding of data flow.

Innovation Solution

A system and method for data replication tracing that identifies and monitors the replication environment within a multi-tier infrastructure, rendering a topology to display data flow based on the configuration, allowing tracing of data flow relative to target, source, and replication servers, enabling accurate determination of data origin, destination, and replication paths.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If data replication is implemented across hundreds of servers and databases, then data availability and backup capability are improved, but system complexity and difficulty of tracking data flow increase

Engineering Contradiction:
Improvedata availabilityVSAvoidsystem complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent introduces a replication trace database as an intermediary component that stores and manages replication trace information. This trace database acts as a mediator between the complex replication environment and the tracing functionality, simplifying the tracking of data flow across hundreds of servers and databases without adding to the replication complexity itself.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent creates a simplified copy or representation of the replication environment through topology data and trace information. Instead of directly managing the complexity of the original replication system, the invention generates a traceable copy that captures the essential data flow paths, making it easier to track and analyze replication without interfering with the actual replication operations.

Inventive Principle:
Principle #26Copying

2Loss of information

If comprehensive data flow tracking is implemented, then understanding of replication environment is improved, but time and resources required for tracking increase

Engineering Contradiction:
Improveknowledge of data flowVSAvoidtracking time
Core Design Contradiction:
Loss of informationVSLoss of time

Solution Approach 1:

The patent performs preliminary actions by automatically capturing and storing replication trace information as replication operations occur. The trace database pre-stores topology data and replication path information, so when tracing is needed, the information is already available without requiring time-consuming analysis of the replication environment at that moment.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The replication tracing system is designed to be self-service in that it automatically generates and maintains trace information without requiring manual intervention. The system self-captures replication events, self-stores trace data in the trace database, and self-provides tracing capabilities through the user interface, eliminating the need for manual tracking efforts.

Inventive Principle:
Principle #25Self-service

3Measurement precision

If manual examination of replication configuration is performed, then data flow information can be obtained, but the process becomes difficult and time-consuming

Engineering Contradiction:
Improvedata flow information accuracyVSAvoidtracing ease
Core Design Contradiction:
Measurement precisionVSEase of operation

Solution Approach 1:

The patent implements feedback mechanisms where the system automatically provides trace information back to users through a graphical user interface. Instead of requiring users to manually examine configurations, the system captures replication events and feeds back the trace information in an easily consumable visual format, maintaining accuracy while dramatically improving ease of operation.

Inventive Principle:
Principle #23Feedback

Solution Approach 2:

The patent replaces the mechanical process of manual configuration examination with an automated electronic tracing system. The manual mechanical act of reviewing configuration files and tracing data flows manually is substituted with an electronic automated system that captures, stores, and displays trace information through software interfaces, maintaining precision while eliminating the labor-intensive manual process.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

Data Source

PatentUS8935612B2Data replication tracing
Publication Date: 2015.01.13 SYBASE INC
  • US8935612B2 patent drawing
  • US8935612B2 patent drawing
  • US8935612B2 patent drawing

AI summary

System, method, computer program product embodiments and combinations and sub-combinations thereof for data replication tracing are provided. In an embodiment, the data replication tracing includes identifying a replication environment within a multi-tier infrastructure of an enterprise data processing network, and monitoring operational performance within the replication environment. A path is rendered on a topology to display data flow for the replication environment based upon a configuration of the replication environment. The data flow may be represented relative to a target data node, relative to a source data node, and/or relative to a replication server.