Partial Database Restoration Through Change Tracking
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database restoration methods require processing entire backups, consuming significant computing resources and network bandwidth, and result in loss of data changes since the last backup, leading to reduced productivity and inefficient recovery.
Innovation Solution
A system that restores a database by processing only the changed data entries since a specified restore time, using database versioning and change tracking to revert these entries to their initial values, thereby reducing the need to process the entire database.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If the entire database backup is loaded and processed for restoration, then the database can be restored to a previous state, but significant computing resources and network bandwidth are consumed
Solution Approach 1:
The patent extracts only the changed data entries from the database backup since the last restore time, rather than processing the entire database. This selective extraction approach reduces computing resource consumption and network bandwidth usage while maintaining the ability to restore the database to its previous state by reverting only the modified entries.
Solution Approach 2:
The database restoration process is segmented into identifying changed data entries versus unchanged entries. By dividing the restoration task into processing only the changed portion, the system achieves efficient recovery without the overhead of processing the complete database, thus reducing energy and resource consumption.
2Reliability
If the entire database backup is transferred for restoration, then complete database recovery is achieved, but network bandwidth is significantly consumed
Solution Approach 1:
The system extracts and transfers only the changed data entries from the backup storage to the database system, rather than transferring the entire database backup. This selective transfer mechanism maintains recovery completeness for all changed data while significantly reducing network bandwidth consumption during the restoration process.
3Reliability
If the entire database is processed during restoration, then complete restoration is achieved, but the database is inaccessible during recovery leading to reduced productivity
Solution Approach 1:
By extracting and processing only the changed data entries rather than the entire database, the restoration process completes much faster. This reduced processing time minimizes the period during which the database is inaccessible, thereby maintaining higher productivity and database availability during the recovery operation.
Solution Approach 2:
The patent applies partial action by processing only the necessary changed entries rather than the complete database. This partial processing approach achieves sufficient restoration for the affected data while reducing the overall recovery time, allowing the database to return to service faster and maintain productivity.
Data Source
AI summary
Described herein is a system that restores a database by processing a portion of the database. The system restores the database to a previous state at a particular time by reverting data entries that have changed since the time to their initial values before the change. Data entries that have changed after the restore time are identified. For the data entries that have changed after the restore time, their initial values before the change are determined from various sources. The system determines a database version that is created most recently before the restore time. The system additionally identifies changes to the database between the restore time and when the database version is created. The initial values can be determined from either the database version or the changes made to the database between the restore time and when the database version is created.