Selective Database Object Restoration with Security Context
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Traditional backup and restoration methods for enterprise-level databases are resource-intensive and require detailed knowledge of database topology, making them inefficient for selective restoration and maintenance of security relationships.
Innovation Solution
A mechanism for selectively restoring portions of a monolithically backed up database while maintaining security relationships, using database table metadata to locate and restore selected objects and their associated security information.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If traditional granular backup scheme is used, then selective restoration is easier, but backup and restoration require extensive knowledge of database topology and are personnel intensive
Solution Approach 1:
The patent creates a copy of the database backup to a temporary area, allowing selective restoration without modifying the original backup. This copying approach enables the system to work with replicas rather than the master backup, preserving the original while enabling flexible restoration operations.
Solution Approach 2:
The patent introduces a temporary database as an intermediary between the backup and the target database. This intermediary allows selective data extraction and transformation without requiring direct manipulation of the original backup or the target database, simplifying the restoration process.
2Device complexity
If monolithic database backup is used, then backup process is simpler and does not require knowledge of database structure, but restoration of selected objects is time-consuming and resource-intensive
Solution Approach 1:
The patent segments the monolithic backup into individual database objects by querying the temporary database and identifying separate objects. This segmentation allows selective restoration of only the required objects rather than restoring the entire database, significantly reducing restoration time and resource consumption.
Solution Approach 2:
The patent performs partial restoration by selecting and restoring only the specific database objects that are needed, rather than restoring the entire database. This partial action approach minimizes restoration time and resource usage while still achieving the restoration goal.
3Reliability
If traditional restoration method is used, then entire database can be restored, but security relationships may not be properly maintained for selected objects
Solution Approach 1:
The patent extracts security-related information separately from the database objects during the restoration process. By taking out security information as a distinct element, the system can apply it specifically to the restored objects, ensuring that security relationships are properly maintained without requiring restoration of the entire database.
Solution Approach 2:
The patent performs preliminary queries on the temporary database to identify database objects and their security relationships before actual restoration. This preliminary action allows the system to prepare the restoration plan, ensuring that security information is properly captured and applied to the selected objects during restoration.
Data Source
AI summary
A mechanism to selectively restore portions of a monolithically backed up database, while maintaining security relationships associated with the restored portions of the database is provided. Embodiments of the present invention provide a method, system and computer-readable storage medium for receiving a request to restore a selected object from among a plurality of backed up objects in a database backup, accessing security-related information associated with the selected object in the database backup, restoring the selected object using the information associated with the selected object in a target area, and associating elements of the security-related information with the restored selected object.