Two-Step Data Deletion for Business Server Migration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing methods for deleting data from business management platforms, such as ERP systems, are time-consuming and can render the data inconsistent or unusable, particularly when migrating data to new servers or in-memory databases.
Innovation Solution
A method involving a two-step delete command process, where a first delete command is issued to the database management system to delete data, followed by a second command to the business management platform to update data definitions, allowing selective data deletion and preservation of configuration data, which is then copied to a new server system.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of time
If conventional deletion tools are used to delete data from the database, then data deletion can be performed, but the deletion process takes significant time and may render the resultant data inconsistent and unusable
Solution Approach 1:
The deletion process is segmented into two distinct phases: first, a database-level delete command removes the actual data from storage quickly; second, a platform-level delete command updates the data definitions and metadata. This segmentation allows each phase to be optimized independently - the first for speed and the second for consistency - resolving the contradiction between deletion time and data reliability.
2Reliability
If all data is copied to the new database server, then complete data migration is achieved, but hardware requirements and copying time increase significantly
Solution Approach 1:
The patent extracts and deletes unnecessary historical data and logs from the source database before copying. By removing data that is not needed in the new system beforehand, the copying process becomes faster and requires less hardware resources, while the essential configuration data and operational data are preserved for migration.
3Ease of operation
If configuration data is deleted along with other data, then deletion process is simplified, but manual reconstruction of configuration information is required
Solution Approach 1:
The deletion process applies different quality treatment to different types of data: configuration data is protected from deletion by the platform-level delete command while other data is removed. This selective approach maintains the simplicity of the deletion process while preserving critical configuration information that would otherwise require manual reconstruction.
Data Source
AI summary
A method of selectively migrating data for a mixed server environment including deleting a first dataset from the first database server in response to a first delete command issued to the first database management system, issuing a second delete command after deleting the first dataset, copying to a second database server a complete set of data stored by the first database server, starting a second application server, starting a second business management software platform on the second application server, and providing the second business management software platform with the business software configuration data from the second database. The first dataset is deleted by a first database management system of a first database server, and the second delete command is issued to a first business management software platform and instructs the first business management software platform to delete the first dataset.