Database Export Service for Native Recovery Environments
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database recovery systems are inadequate for real-time critical applications, such as ERP and CRM systems, as they fail to provide instant recovery, testing, and analysis capabilities, with a single system unable to meet these requirements.
Innovation Solution
A system that exports a database from a foreign database recovery environment to a native database recovery environment using foreign snapshot and incremental files, allowing for point-in-time recovery and extended recovery by generating script information and materializing file information to restore and recover the database.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If a single database recovery system is used, then system simplicity is maintained, but the ability to provide instant recovery, testing, and analysis capabilities is insufficient
Solution Approach 1:
The patent divides the database recovery system into two distinct environments: a foreign database recovery environment for backup and storage, and a native database recovery environment for restoration and analysis. This segmentation allows each environment to be optimized for its specific purpose, with the foreign environment handling backup operations using foreign snapshot files and the native environment providing comprehensive recovery capabilities including instant recovery, testing, and analysis functions.
Solution Approach 2:
The patent introduces a database export service as an intermediary component that bridges the foreign database recovery environment and the native database recovery environment. This service exports database information from the foreign environment to the native environment, enabling data transfer and recovery operations without requiring the systems to be directly integrated, thus maintaining simplicity while enhancing functionality.
2Reliability
If database recovery is performed in a foreign database recovery environment, then backup storage is achieved, but processing power and time are consumed unnecessarily
Solution Approach 1:
The patent extracts the actual database recovery operations from the foreign database recovery environment and relocates them to the native database recovery environment. The foreign environment retains only the backup storage function using foreign snapshot files, while the native environment handles all recovery operations. This extraction eliminates unnecessary processing in the foreign environment and enables faster recovery times in the native environment optimized for such operations.
Solution Approach 2:
The patent performs preliminary database export operations during off-peak times, exporting database information from the foreign environment to the native environment in advance. This preliminary action ensures that when recovery is needed, the native environment already has the necessary data ready, significantly reducing actual recovery time and avoiding time-consuming operations during critical recovery moments.
3Quantity of substance
If foreign snapshot files are used for database backup, then backup functionality is achieved, but data integrity and native environment compatibility are compromised
Solution Approach 1:
The patent creates a copy of the database information from the foreign environment to the native environment through the database export service. Instead of directly using foreign snapshot files in the native environment (which would compromise compatibility), the system copies and restores the data using native snapshot files in the native environment. This copying process ensures data integrity and compatibility while maintaining the backup functionality of the foreign environment.
Data Source
AI summary
Systems and methods to export a database to a native database recovery, environment are described. The system includes a native database recovery environment that includes a target host. The target host receives file information and script information, over a network, via directories from a backup host. The backup host utilizes foreign snapshot files and foreign incremental files to store the file information in the foreign database recovery environment. The file information includes native snapshot files and native incremental files. The script information includes scripts that are executed by the target host in the native database recovery environment. The target host executes the scripts to mount the directories, open the database, restore the database, recover the database to a point-in-time, and unmount the directories.