Conditional Database Replication Using Tolerance Ranges
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing methods for synchronizing databases often require replicating all changes, which can be inefficient, especially when dealing with high-frequency changes in sensor data or internal processes.
Innovation Solution
A method that conditionally replicates changes to a second database based on a defined tolerance range, where changes that fulfill the tolerance range are prevented from replication, and those that do not are replicated.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If all changes are replicated to maintain data synchronization, then data consistency is improved, but system resource consumption and replication overhead increase
Solution Approach 1:
The patent introduces a tolerance range parameter to control replication behavior. Changes are evaluated against this parameter to determine whether replication is necessary. This parameter-based control allows the system to adapt replication decisions to actual data variation needs, reducing unnecessary replication while maintaining acceptable data consistency.
Solution Approach 2:
Instead of replicating all changes universally, the patent applies partial replication by selectively copying only those changes that exceed the defined tolerance range. This partial action approach maintains data consistency for significant changes while avoiding the resource overhead of replicating minor or insignificant variations.
2Reliability
If all changes are replicated to ensure complete data synchronization, then data integrity is improved, but replication time and processing overhead increase
Solution Approach 1:
The tolerance range serves as a time-saving parameter by establishing a threshold for significant changes. This allows the system to quickly filter out changes that do not meet the threshold, reducing the time required for replication decisions and execution while maintaining data integrity for meaningful changes.
Solution Approach 2:
The patent implements partial replication by focusing resources only on changes that exceed the tolerance threshold. This selective approach reduces overall replication time by avoiding unnecessary processing of minor changes, while still ensuring data integrity for significant modifications.
3Productivity
If a tolerance range is introduced to filter changes, then replication efficiency is improved, but data synchronization precision may be reduced
Solution Approach 1:
The tolerance range parameter is designed to balance efficiency and precision. By configuring this parameter appropriately, the system achieves high replication efficiency for routine changes while maintaining sufficient precision for significant data variations. The parameter acts as a controllable threshold that can be adjusted based on specific application requirements.
Solution Approach 2:
The patent applies partial precision by using full-precision replication for changes exceeding the tolerance range while using approximate matching for changes within the range. This approach maintains sufficient synchronization precision for critical data while improving overall replication efficiency through selective precision application.
Data Source
AI summary
A computer implemented method for synchronizing a first database with a second database. The method comprises a replication method comprising determining that a first change in the first database fulfils a defined tolerance range in response to detecting that the first change indicates a value of at least one selected attribute of the set of attributes, and determining that a second change in the first database does not fulfil the defined tolerance range in response to detecting that the second change indicates a value of at least one selected attribute of the set of attributes. The replication method further comprises preventing replication of the first change to the second database in response to determining that the first change fulfils the tolerance range, and replicating the second change to the second database in response to determining that the second change does not fulfil the tolerance range.