Database Migration Shadow System for Kernel Version Adaptation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Database migration processes often require significant downtime and are limited by the kernel versions and software restrictions of the source system, lacking flexibility and efficiency in upgrading database structures and software versions.
Innovation Solution
The method involves creating a shadow system on the target device, where metadata and data from the source system are transferred, and the kernel and database tables are adapted to a higher upgrade version, allowing for decoupling from the source system's requirements and enabling flexible migration operations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of time
If database migration is performed using traditional methods, then data can be transferred between systems, but significant downtime is required and the process is constrained by source system kernel versions
Solution Approach 1:
The patent creates a shadow system on the target device that is a copy of the source system's database structure. This shadow system allows migration operations to be performed independently of the source system's running state and kernel version, enabling flexible upgrades without requiring source system downtime or version constraints.
Solution Approach 2:
The migration process is divided into independent phases: creating the shadow system, transferring data to the shadow system, adapting the shadow system to the target kernel version, and finally switching over. This segmentation allows each phase to be optimized independently, reducing overall downtime and eliminating source system version constraints.
2Adaptability or versatility
If traditional database migration methods are used, then data transfer can be accomplished, but the process is constrained by source system software restrictions
Solution Approach 1:
By creating a shadow system that replicates the source database structure on the target device, the patent enables the migration process to be decoupled from the source system's software restrictions. The shadow system can be adapted to different target kernel versions without affecting the source system's software constraints.
Solution Approach 2:
The shadow system acts as an intermediary between the source system and the target system. It receives data from the source system and serves as a buffer for adaptation to the target kernel version, eliminating the need for direct interaction between source and target systems and thus bypassing software version constraints.
3Productivity
If databases are migrated without using shadow tables, then the process is simpler, but data encoding conversions and software upgrades cannot be performed efficiently
Solution Approach 1:
The shadow system is created with the target kernel version's table structures before data transfer. This preliminary setup allows data encoding conversions and software upgrades to be performed in advance on the shadow system, improving migration efficiency without requiring complex real-time conversions during the actual data transfer.
Solution Approach 2:
The shadow system creates a copy of the database structure that can be independently adapted to the target kernel version. This copying approach allows efficient data encoding conversions and software upgrades to be performed on the shadow system before the actual migration, improving overall productivity.
Data Source
AI summary
Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives data from a subset of a first set of exchange tables stored in a first database of a source system. The program further creates a second set of exchange tables in a second database of the device. The program also creates a set of shadow tables in the second database of the device. The program further adapts the second set of exchange tables and the set of shadow tables to a higher upgrade version. The program also performs object generation based on the second set of exchange tables and the set of shadow tables. The program further drops the set of shadow tables. The program also receives a set of application tables from the source system. The program further adapts the set of application tables to the higher upgrade version.