Asset Group Backup Log Deletion for Redundant Database Logs
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Managing large numbers of databases individually results in inefficient use of system resources and redundant log storage in high-availability configurations.
Innovation Solution
Grouping databases into asset groups based on type and applying backup protection strategies at the group level, with the data manager determining successful backups and deleting redundant logs on non-backed up assets.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If databases are managed individually, then each database can be backed up independently, but system resources are used inefficiently and redundant log storage occurs
Solution Approach 1:
The patent groups multiple databases into asset groups and applies backup protection strategies at the group level rather than individually. This merging approach consolidates backup operations, reduces redundant log storage in high-availability configurations, and improves overall system resource utilization while maintaining independent backup capability when needed.
2Reliability
If backup protection strategies are applied at individual asset level, then each asset can be protected independently, but resource utilization becomes inefficient
Solution Approach 1:
The patent enables backup protection strategies to operate at multiple levels: individually for each asset and collectively for asset groups. This multi-functionality allows the system to apply universal group-level strategies to reduce management complexity and resource usage, while still permitting individual asset protection when specific reliability requirements demand it.
3Reliability
If logs are maintained on all databases in high-availability configurations, then data redundancy is ensured, but storage space is wasted on duplicate logs
Solution Approach 1:
The patent extracts and identifies redundant log files across databases within an asset group, particularly in high-availability configurations. By detecting duplicate logs that exist across multiple databases, the system can selectively remove redundant copies while preserving necessary redundancy for availability, thereby reducing total log storage volume without compromising reliability.
Data Source
AI summary
In general, embodiments relate to a method for managing logs on databases, the method comprising determining that a backup request has been completed for an asset group, wherein the asset group comprises a plurality of databases, and triggering, in response to the determining, deletion of logs on the databases in the asset group.