Asset Group Backup Management for Database Resource Optimization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data backup systems face inefficiencies in managing and utilizing system resources when backing up large numbers of databases, particularly in high-availability configurations, leading to resource wastage and performance impacts.
Innovation Solution
The introduction of asset groups allows for the application of backup protection strategies at the group level, enabling efficient backup and log management across databases within an asset group, with the data manager determining which assets belong to a group and initiating backup and log deletion processes accordingly.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If backup protection strategies are applied at the individual asset level, then each asset can be backed up independently, but system resource utilization is inefficient and redundant log storage occurs
Solution Approach 1:
The patent merges multiple individual asset backup operations into a single asset group backup operation. By grouping assets that share common characteristics (such as databases in high-availability configurations), the system applies backup protection strategies at the group level, eliminating redundant backup processes and optimizing resource utilization while maintaining comprehensive backup protection.
Solution Approach 2:
The patent creates an asset group concept that serves multiple functions simultaneously: it enables unified backup protection, facilitates coordinated log management, and optimizes resource allocation. The asset group structure allows a single backup operation to protect multiple assets, making the backup system more versatile and efficient.
2Reliability
If backups are performed on all assets in high-availability configurations, then complete data protection is achieved, but redundant log storage consumes excessive system resources
Solution Approach 1:
The patent extracts log management from individual asset operations and centralizes it at the asset group level. By identifying assets within an asset group that have redundant logs (such as standby databases in high-availability configurations), the system selectively deletes redundant logs while preserving necessary backup data, thereby reducing storage consumption without compromising data protection.
Solution Approach 2:
The patent implements a selective log deletion strategy that discards redundant log files from assets that are not the primary backup target while recovering or preserving logs from assets that need them for backup purposes. This approach frees up storage space while maintaining the integrity of backup operations.
3Ease of operation
If individual asset backup management is used, then detailed control over each asset is maintained, but overall system performance and efficiency are impacted
Solution Approach 1:
The patent segments asset management into two hierarchical levels: asset groups for coordinated backup operations and individual assets for detailed control. This segmentation allows the system to apply backup strategies efficiently at the group level while maintaining the ability to manage and control individual assets when needed, thereby balancing operational ease with system performance.
Data Source
AI summary
In general, in one aspect, the technology relates to a method for backing up assets, the method comprising: making a first determination about an asset type of an asset, based on the first determination, associating the asset with an asset group, wherein all assets in the asset group are of the asset type, and protecting the asset in the asset group using a backup strategy associated with the asset group.