Granular Database Backup Object Restoration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Restoring specific documents from a database backup is inefficient as it requires restoring the entire database, consuming significant time and resources, even when only a few documents need to be recovered.
Innovation Solution
A method to restore selected objects from a database backup by generating a list of object identifiers, selecting specific identifiers, and directly restoring the corresponding objects and their dependencies to a staging database without restoring the entire backup, allowing for granular migration to a production database.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If the entire database backup is restored to retrieve a few specific documents, then the documents can be recovered, but significant time and computing resources are consumed
Solution Approach 1:
The patent segments the database backup restoration process into two distinct phases: first restoring only the metadata (object identifiers, names, types, storage locations) and then selectively restoring only the specific document objects requested. This segmentation allows the system to avoid restoring the entire database while still recovering the needed documents, directly resolving the contradiction between complete recovery and time consumption.
Solution Approach 2:
The patent extracts and restores only the necessary components (specific document objects and their metadata) from the backup, leaving out unnecessary data. By using object identifiers to precisely identify and extract only the required documents rather than restoring the entire database, the system achieves complete recovery of needed documents while eliminating wasteful restoration of unrelated data, thus reducing restoration time.
2Reliability
If the entire database backup is restored, then all documents are available, but large storage space is occupied on the staging database
Solution Approach 1:
The patent segments the restoration process to separate metadata restoration from object content restoration. By first restoring only the lightweight metadata (object identifiers, names, types, locations) and then selectively restoring only the specific document objects requested, the system minimizes staging database space usage while ensuring complete availability of the needed documents.
Solution Approach 2:
The patent extracts and restores only the necessary document objects and their metadata from the backup, excluding all unnecessary data. This selective extraction approach ensures that only the required documents are made available on the staging database, achieving document availability while minimizing storage space occupation.
3Productivity
If thousands of database objects are restored, then the backup is complete, but the process occupies gigabytes of space even when only a few documents are needed
Solution Approach 1:
The patent segments the backup restoration into metadata-only phase and selective object restoration phase. This segmentation enables the system to achieve restoration completeness for the needed documents without restoring unnecessary objects, thereby preventing waste of storage space while maintaining productivity.
Solution Approach 2:
The patent extracts and restores only the specific document objects requested by the user, excluding all other objects in the backup. By using object identifiers to precisely target and extract only the needed documents, the system achieves complete restoration of required content while eliminating waste of storage space on unnecessary data.
Data Source
AI summary
Techniques and systems for restoring objects from a backup file without restoring a remainder of the backup file are described. For example, a plurality of object identifiers that identify a plurality of objects stored in the backup file may be determined. A selection of an object identifier of the plurality of object identifiers may be received. A set of objects to be restored from the backup file may be determined based on the object identifier. The set of objects may be granularly restored to a staging database directly from the backup file, without restoring a remainder of the backup file. The set of objects may be migrated from the staging database to a production database.