Virtual Database Storage System for Consistent Application Data Recovery
Solution Overview
Problem
Existing database management systems inadequately manage data associated with applications that is stored outside the database, such as executable files and media files, making it difficult to restore application data to a previous consistent state during disaster recovery.
Innovation Solution
Creating virtual application environments by taking point-in-time copies of both the application and database, allowing for the recreation of a virtual application and database environment that matches a specific state, enabling efficient storage and retrieval of historical changes and data synchronization.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If databases store only data within the database, then database management features like backup and restore work effectively, but application data stored outside the database (executable files, configuration information, documents, images) cannot be managed or restored
Solution Approach 1:
The patent merges the database with its associated application data by creating a unified virtual application environment that includes both the database and external application files. This is achieved through virtualization techniques that treat application data (executable files, configuration information, documents, images) the same way as database data, allowing both to be managed together through database backup and restore operations. The virtualization layer abstracts the distinction between internal and external data storage locations.
2Reliability
If users restore database data to a previous consistent state during disaster recovery, then database integrity is maintained, but application data stored outside the database cannot be restored to the corresponding state
Solution Approach 1:
The patent implements preliminary action by capturing snapshots of both the database and application data at regular intervals before changes occur. These snapshots are stored in advance and can be restored to any previous consistent state. The system maintains a timeline of snapshots for both database and application data, enabling restoration to any point in time when both were in a consistent state, thus preventing information loss during disaster recovery operations.
3Ease of manufacture
If the system stores complete copies of application data for every point-in-time copy, then data restoration is simple, but storage space is consumed excessively
Solution Approach 1:
The patent applies segmentation by dividing application data into discrete files and tracking only the changes to each file between snapshots. Instead of storing complete copies of all application data for every point-in-time copy, the system stores only the delta changes (modifications, additions, deletions) between consecutive snapshots. This segmented approach maintains restoration simplicity while dramatically reducing storage space requirements, as only the differences need to be stored rather than entire data sets.
Data Source
AI summary
A database storage system provides replication capability that allows data from a source database and application specific data from a source application to be replicated respectively to a target database storage system and a target application, thereby creating a virtual database and a virtual application. The database storage system generates a plurality of snapshots of the virtual database at a corresponding plurality of time points and a plurality of snapshots of the virtual application at the corresponding plurality of time points. The database storage system associates the plurality of snapshots of the virtual database with the plurality of snapshots of the virtual application at the corresponding plurality of time points so as to generate a historical time-sequence of concurrent modifications to both the virtual database and the virtual application at the one or more development environments, thereby allowing concurrent read/write and rollback, of data and applications.



