Database Migration Structure Conversion Downtime Reduction
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Traditional combined upgrade and migration processes in software systems require significant technical resources and result in extensive downtime due to data duplication and structural changes during the conversion from source to target database structures.
Innovation Solution
The process involves determining sets of tables in the source database that need conversion, converting data in-memory before writing it to the target database, and creating tables in the target structure before data migration, thereby reducing the need for structural changes and data duplication.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data is migrated in the structure of the original system and then structural changes are applied after migration, then data can be migrated from source to target database, but this results in extensive downtime and significant technical resource consumption
Solution Approach 1:
The patent applies preliminary action by creating the target database structure before migrating data. The target schema is prepared in advance with all necessary tables, columns, and constraints defined, so that when data migration occurs, the target structure is already in place and ready to receive converted data, eliminating the need for post-migration structural changes.
Solution Approach 2:
The patent extracts the data conversion process from the traditional sequential approach (migrate then convert) and integrates it into the migration process itself. Data is converted during the transfer from source to target database, removing the separate conversion step that previously caused extended downtime.
2Adaptability or versatility
If data is converted after migration in an integrated process, then data structure changes from source to target structure can be applied, but this requires data to be read and written multiple times, increasing runtime and resource consumption
Solution Approach 1:
The patent implements continuity of useful action by performing data conversion continuously during the data transfer process. As data flows from the source database through the conversion process into the target database, the transformation occurs in a single continuous operation rather than requiring the data to be written, read back, and converted in separate steps.
Data Source
AI summary
Methods, systems, and computer-readable storage media for data migration in an upgrade procedure executed on a software system include actions of initiating the upgrade procedure, determining a first set of tables of a source database that include data to be converted before being first written to a target database, converting data of the first set of tables to provide first converted data, and writing the converted data to one or more tables in the target database.