Cross-Database Backup Recovery via Intermediary Configuration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems are unable to recover backup files stored in third-party backup tools from one database system into another database system.
Innovation Solution
The system uses the system identifier of the source database system to determine the appropriate configuration file and pipe names to access and recover backups from the third-party backup tool, allowing the target database system to request and receive the necessary backups for recovery.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If backup files are stored in a third-party backup tool with abstracted storage and lifecycle management, then backup file security and management control are improved, but the ability to recover backup files from one database system into another database system deteriorates
Solution Approach 1:
The patent introduces an intermediary mechanism that bridges the third-party backup tool's abstracted storage system and the target database system. This intermediary enables the target database system to access and recover backup files from a different source system by translating between the backup tool's abstracted interface and the database system's recovery requirements, thus resolving the contradiction between maintained security control and enabled cross-system versatility
2Ease of operation
If a backup tool implements its own lifecycle management and access control for backup files, then backup file security and organizational control are improved, but compatibility with foreign database systems deteriorates
Solution Approach 1:
The patent implements a universal access mechanism that allows the backup tool's lifecycle management and access control system to serve multiple database systems beyond its native system. By creating a standardized interface layer that works with different database systems' recovery protocols, the backup tool maintains its security and control features while gaining the versatility to support foreign database system recoveries
Data Source
AI summary
A system includes reception, at a target database system, of a request to recover a backup created by a source database system into the target database system, determination of a backup tool configuration file associated with the source database system, determination of a filepath of the backup, determination of a backup filepath associated with the target database system, and request of a recovery of the backup using the backup tool configuration file, wherein the request using the backup tool configuration file includes the filepath of the backup and the backup filepath associated with the target database system.