Automatic Data Federation Replication Toggle

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current data access methods in distributed systems face challenges in balancing response time and storage usage, as federated data access reduces latency but increases storage, while replicated data access decreases latency but increases storage usage, lacking an efficient automatic toggling mechanism between the two.

Innovation Solution

The system automatically toggles between replication and federation based on predefined criteria, such as query frequency and network performance, identifying data sets that benefit from replication and switching between local storage and remote access to optimize both network usage and storage consumption.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Quantity of substance

If federated data access is used, then local storage is reduced, but response time increases

Engineering Contradiction:
Improvelocal storageVSAvoidresponse time
Core Design Contradiction:
Quantity of substanceVSSpeed

Solution Approach 1:

The system dynamically switches between federation and replication modes based on real-time performance metrics and storage conditions. The data access method is not fixed but adapts automatically, allowing the system to optimize the trade-off between storage and response time under different operational contexts.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The system changes the data access parameter (federation vs. replication) based on monitored conditions such as query frequency, storage capacity, and performance requirements. This allows the system to adjust its behavior to match current operational needs rather than being locked into a single access mode.

Inventive Principle:
Principle #35Parameter changes

2Speed

If replicated data access is used, then response time decreases, but local storage increases

Engineering Contradiction:
Improveresponse timeVSAvoidlocal storage
Core Design Contradiction:
SpeedVSQuantity of substance

Solution Approach 1:

The system dynamically adjusts the replication level based on monitored performance metrics and storage conditions, switching between full replication and federation modes to optimize the trade-off between response time and storage consumption.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The system changes the data access parameter (replication vs. federation) based on monitored conditions such as query frequency, storage capacity, and performance requirements, allowing automatic optimization of the response time versus storage trade-off.

Inventive Principle:
Principle #35Parameter changes

3Speed

If manual toggling between replication and federation is implemented, then data access performance can be optimized, but system complexity increases

Engineering Contradiction:
Improvedata access performanceVSAvoidsystem complexity
Core Design Contradiction:
SpeedVSDevice complexity

Solution Approach 1:

The system automatically monitors its own performance metrics and storage conditions, then autonomously decides when to switch between replication and federation modes without requiring manual intervention or complex external control systems.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system implements a feedback mechanism that continuously monitors data access patterns, storage usage, and performance metrics, then uses this feedback to automatically adjust the data access mode, eliminating the need for manual toggling while maintaining optimized performance.

Inventive Principle:
Principle #23Feedback

Data Source

PatentEP4428713A1Automatic data federation/replication toggle
Publication Date: 2024.09.11 SAP SE
  • EP4428713A1 patent drawingFigure 1
  • EP4428713A1 patent drawingFigure 2
  • EP4428713A1 patent drawingFigure 3

AI summary

Example methods and systems are directed to automatically toggling between replication and federation for access for data received from remote sources. The system may initially use a fully federated strategy, so that results for any query can be generated. Based on one or more of predefined criteria, analysis of the queries being performed, network performance data, and other factors, data sets that would benefit from replication are identified. The identified data sets are accessed from the remote source and replicated in local storage. Future queries for replicated data are satisfied by accessing the replicated data. Other queries continue to be served using federation. After replication has begun, analysis of the benefits of replication may continue. When replication is no longer a net benefit, the local data may be deleted and further access of the data provided through federation.