Database Snapshot Replication for Multi-State Recovery
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing systems for transactional databases cannot revert to multiple states corresponding to different points in time after initial recovery, limiting data recovery and analysis capabilities.
Innovation Solution
Creating a second snapshot of a first snapshot, allowing modifications and reversion to previous states, enabling the database to be put into multiple states corresponding to different points in time by playing transaction logs, and utilizing replication logs to replicate changes and take snapshots at consistent points.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If the database is recovered to a specific point in time by playing transaction logs, then data recovery capability is improved, but the ability to play additional transaction logs to reach later states is lost
Solution Approach 1:
The patent segments the database state management by introducing multiple snapshot points (first snapshot, second snapshot) that divide the transaction log playback journey into separate segments. Each snapshot represents a distinct state that can be independently accessed, allowing the system to recover to one state, analyze it, and then proceed to play additional logs to reach subsequent states without losing the ability to access intermediate points.
Solution Approach 2:
The patent applies preliminary action by creating multiple snapshots at predetermined points in the transaction log sequence before full recovery is needed. These pre-created snapshots serve as ready-to-access state checkpoints that preserve the ability to revert to specific points while enabling continued progression through transaction logs to reach later states.
2Loss of information
If the database is put into a state corresponding to a particular point in time for data recovery, then data analysis capability at that point in time is improved, but the ability to access other time points is lost
Solution Approach 1:
The patent creates copies of the database state at different points in time through the mechanism of snapshots. The first snapshot and second snapshot are essentially copies of the database state at specific moments, allowing simultaneous preservation of multiple temporal states. This enables analysts to examine data at one time point while retaining the ability to access other time points through the snapshot mechanism.
3Manufacturing precision
If transaction logs are played into the database to reach a specific state, then the accuracy of data representation at that state is improved, but the flexibility to explore other states is reduced
Solution Approach 1:
The patent introduces dynamics to the previously static database recovery process by enabling bidirectional navigation through time points. The system can dynamically switch between different snapshot states (first snapshot, second snapshot) and continue playing transaction logs forward, creating a flexible exploration environment where the operator can move freely between different temporal states while maintaining accurate data representation at each point.
Data Source
AI summary
This application describes techniques for creating a second snapshot of a first snapshot of a set of data, modifying the first snapshot, and reverting the modifications to the first snapshot. For example, portions of one or more transaction logs may be played into a database to put the database in a particular state a particular point in time. The second snapshot may then be used to revert to a prior state of the database such that additional transaction logs may be played into the database. These techniques enable the ability to put the database into multiple states as the database existed at multiple points in time. Therefore, data can be recovered from the database as the data existed at different points in time. Moreover, individual data objects in the database can be accessed and analyzed as the individual data objects existed at different points in time.