Dynamic Delta Client Copy Selection Using Table Statistics
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing client copy tools apply a global copy strategy for an entire client copy process, which is inefficient in terms of space and runtime, and struggle to minimize disruption to productive operations.
Innovation Solution
Implement a dynamic selection of delta client copy strategies based on database statistics and client copy logs to determine the optimal copy strategy for each table, including delta copy algorithms to selectively copy or skip operations based on table changes and record counts.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If a global copy strategy is applied for an entire client copy process, then the copy process is simplified and can be implemented uniformly, but the space and runtime requirements increase significantly and disruption to productive operations increases
Solution Approach 1:
The patent divides the client copy process into table-level segments, allowing each table to be evaluated and copied independently based on its own characteristics. The system analyzes database statistics for each table (such as table fullness, change frequency, and record count) and applies appropriate copy strategies individually, rather than applying a single global strategy to the entire client. This segmentation enables selective copying of only necessary tables, significantly reducing overall copy time and resource consumption.
2Ease of operation
If a global copy strategy is applied for an entire client copy process, then the implementation is uniform and simple, but the space requirements increase significantly
Solution Approach 1:
The patent extracts and identifies specific tables that require copying by analyzing database statistics, separating them from tables that do not need copying. The system uses criteria such as table fullness thresholds, change frequency since last copy, and record count comparisons to determine which tables should be copied. This extraction approach ensures that only necessary data is copied, significantly reducing the space requirements compared to copying the entire client.
3Ease of operation
If a global copy strategy is applied for an entire client copy process, then the process can be implemented uniformly, but disruption to productive operations increases
Solution Approach 1:
The patent implements a dynamic copy strategy that adapts to the current state of each table by continuously analyzing database statistics. The system dynamically determines copy priorities based on factors such as table modification frequency, business criticality, and current load on the source system. This dynamic approach allows the copy process to be more selective and efficient, reducing the overall disruption to productive operations compared to a static global copy strategy.
Data Source
AI summary
Arrangements for dynamic selection of delta client copy strategies are provided. An intelligent client copy computing platform may determine whether a database table of a source client is empty. If not, the copy computing platform may determine whether the database table has changed. If not, the computing platform may determine whether the database table has been copied from a same source client of a last copy operation. If so, the computing platform may determine whether a record count of the source client is the same as the record count of a target client. If not, the computing platform may apply a delta copy algorithm. The algorithm may select records of the source client, deduct records of the target client from those records, insert records that are in the source but not in the target client, and delete records that are in the target but not in the source client.