Trigger Table Copy Procedure for Source System Downtime Reduction
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Data copying procedures in multi-tenant computing environments often result in significant downtime for the source system, leading to operational disruptions and inconsistencies between the source and target systems, especially when dealing with large amounts of data and multiple target systems.
Innovation Solution
A computer-implemented method that initiates a copy procedure by generating a trigger table to track changes in selected tables, allowing for real-time synchronization between the source and target systems without requiring the source system to be closed, thereby reducing downtime. This method includes determining compatibility between systems, selecting tables, generating and copying the trigger table, and applying changes to the target system based on the trigger table.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of time
If a traditional copy procedure is performed to copy data from source system to target system, then data can be transferred to the target system, but the source system experiences significant downtime and operational disruptions
Solution Approach 1:
The copy procedure is segmented into multiple phases: initial data copy, trigger table generation, change tracking during operation, and final synchronization. This allows the source system to remain operational while data is being copied in stages, reducing downtime and maintaining productivity.
Solution Approach 2:
The trigger table is generated and copied to the target system before the actual data copy operation begins. This preliminary action enables the target system to be prepared in advance, and subsequent changes to the source system can be tracked and applied without interrupting source system operations.
2Manufacturing precision
If the source system is closed to perform data copying, then data can be copied accurately, but users cannot perform operations and changes are not reflected in the target system
Solution Approach 1:
The trigger table mechanism provides feedback about changes made to the source system during operation. Triggers are generated that automatically track inserts, updates, and deletes, and this feedback is used to synchronize the target system with the source system without requiring closure.
Solution Approach 2:
The source system remains open and operational throughout the copy process. Users can continue to perform operations, and the trigger table continuously tracks changes, ensuring that data consistency is maintained while operational capability is preserved.
3Quantity of substance
If all tables are copied to ensure complete data transfer, then data completeness is improved, but copying time and system complexity increase significantly
Solution Approach 1:
Instead of copying all tables immediately, the method copies only the trigger table initially, then selectively copies and updates tables based on actual changes detected during operation. This partial action approach reduces initial copy time while ensuring complete data transfer through continuous synchronization.
Data Source
AI summary
A system, a method and a computer program product for performing a copy procedure are disclosed. A copy procedure that copies a table in a plurality of tables stored at a source system to a target system is initiated. At least one table in a plurality of tables stored at the source system is selected for copying from the source system to the target system. A trigger table containing at least one trigger is generated. The trigger indicates at least one change made to the at least one selected table. The trigger table is copied from the source system to the target system. The selected table is copied from the source system to the target system. Using the copied trigger table, changes are applied to the table copied to the target system.