Network Packet Interception for Database Synchronization

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing data storage systems face performance degradation when propagating changes across multiple data storage systems, as the primary server is burdened with the overhead of synchronizing data, which can be unacceptable in certain situations.

Innovation Solution

A synchronization unit is introduced to monitor network packets and automatically propagate changes from the primary server to backup servers, relieving the primary server of this task and enhancing throughput performance by using a separate system for synchronization operations.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If the primary storage system propagates each change to backup storage systems, then data consistency is maintained, but the overhead negatively impacts the performance of the primary data server

Engineering Contradiction:

Improvedata consistencyVSAvoidprimary server performance

Core Design Contradiction:

ReliabilityVSProductivity

Solution Approach 1:

A synchronization unit is introduced as an intermediary component that sits between the primary storage system and backup storage systems. This unit intercepts change notifications from the primary system and independently manages propagation to backup systems, thereby maintaining data consistency while relieving the primary server of the overhead burden.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The change propagation function is extracted from the primary storage system and placed into a separate synchronization unit. This extraction allows the primary server to focus on its core data processing tasks while the synchronization unit handles the propagation of changes to backup systems, improving overall system performance.

Inventive Principle:

Principle #2Taking out (Extraction)

2Productivity

If a separate synchronization unit is introduced to propagate changes, then the primary server performance is enhanced, but the system complexity increases

Engineering Contradiction:

Improveprimary server throughputVSAvoidsynchronization system structure

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The synchronization unit is designed to perform multiple functions: it receives change notifications from the primary system, determines which backup systems need updates, propagates changes to appropriate backup systems, and handles error management. This multi-functionality consolidates what could be multiple separate components into a single versatile unit, reducing overall system complexity.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Solution Approach 2:

The synchronization unit operates autonomously once initialized. It self-manages the propagation process by automatically receiving change notifications, determining propagation targets, executing updates to backup systems, and handling errors without requiring intervention from the primary server or manual configuration for each propagation event.

Inventive Principle:

Principle #25Self-service

Data Source

PatentUS8572026B2Data synchronisation across multiple data storages when processing transactions received on a network

Publication Date: 2013.10.29 ORACLE INT CORP

AI summary

A synchronization unit examines the packets on a network to determine the changes being caused to a database server, and propagates the same changes to corresponding backup server(s). As the synchronization is implemented in a separate unit, the throughput performance of database servers may not be impeded due to the synchronization requirement.