Hybrid Database Backup Live-Mounting Hot Data Migration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database restoration techniques require significant storage resources on the target device, which may not be available, especially when the target device lacks sufficient storage capacity to accommodate full database restoration.
Innovation Solution
The method involves live-mounting a portion of the backup asset onto a client device while remote access operations are performed, identifying and recovering a hot backup asset data file copy onto the client device while retaining the remainder on the backup storage system, enabling bidirectional migration of database data between local and remote storage.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If full database restoration is performed on target device, then database recovery completeness is improved, but storage resource requirement increases
Solution Approach 1:
The patent divides the backup asset into multiple data files and selectively restores only the frequently accessed (hot) data files to the target device, while retaining less frequently accessed data files on the backup storage system. This segmentation approach enables partial restoration that balances recovery completeness with storage resource constraints.
Solution Approach 2:
The patent implements differential restoration by identifying and restoring only the hot data files that are frequently accessed, rather than restoring all data files uniformly. This local quality approach ensures that the most critical data is available locally on the target device while minimizing storage resource consumption.
2Quantity of substance
If selective hot data file restoration is performed, then storage resource usage is reduced, but database recovery time may increase
Solution Approach 1:
The patent performs preliminary identification of hot data files based on access patterns before the restoration process begins. By pre-identifying which data files are frequently accessed, the system can prioritize their restoration, reducing the overall recovery time for critical data while maintaining efficient storage resource usage.
Solution Approach 2:
The patent creates copies of hot data files from the backup storage system to the target device's local storage. This copying mechanism enables rapid restoration of frequently accessed data without requiring full database restoration, thereby reducing recovery time for critical operations while optimizing storage resource allocation.
3Adaptability or versatility
If hybrid storage architecture is implemented, then storage flexibility is improved, but system complexity increases
Solution Approach 1:
The patent introduces a backup asset management system that acts as an intermediary between the backup storage system and the target device. This intermediary manages the identification, selection, and coordination of hot data file restoration, abstracting the complexity of hybrid storage management from the user and simplifying the overall system operation.
Solution Approach 2:
The patent implements a universal restoration framework that can handle both full database restoration and selective hot data file restoration through the same system architecture. This multi-functionality allows the system to adapt to different restoration scenarios without requiring separate complex systems, thereby improving storage flexibility while managing system complexity.
Data Source
AI summary
A method and system for maintaining live database data across hybrid storage. Specifically, the disclosed method and system entail accessing live backup database data in part residing on local storage and in part residing on remote storage. That is, on occasion, available local storage capacity may fall short of the required free storage space to accommodate the full restoration or recovery of a given database. Accordingly, to overcome this shortfall, the disclosed method and system detect and cycle the recovery of frequently accessed asset (or database) data files, of the given database, from remote storage onto local storage.