Heterogeneous DBMS Backup via Third-Party Tool Pipes
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database management systems lack unified backup and recovery algorithms for systems that use both dynamic tiering and non-dynamic tiering, making it difficult for users to effectively backup and recover data.
Innovation Solution
A system comprising a Name Server Backup Manager, Master Server Index, Dynamic Tiering Server, Native Name Server, and Disk and Execution Monitor, which work together to create pipes for data backup and recovery, allowing for synchronized backup and recovery of heterogeneous database management systems by partitioning data into hot and warm categories and managing access to centralized resources.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If a single DBMS performs both dynamic tiering and non-dynamic tiering, then data management flexibility is improved, but backup and recovery capability deteriorates due to lack of unified algorithms
Solution Approach 1:
The system segments the heterogeneous database system into distinct components: dynamic tiering database, non-dynamic tiering database, and third-party backup tool. Each component is backed up independently using appropriate methods, then integrated through a unified backup architecture that manages both types of databases simultaneously.
Solution Approach 2:
The patent introduces a third-party backup tool as an intermediary that bridges the gap between dynamic and non-dynamic tiering databases. This intermediary component provides the unified backup algorithm that neither native DBMS can provide alone, enabling coordinated backup and recovery across heterogeneous database types.
2Adaptability or versatility
If heterogeneous DBMSs are used for dynamic and non-dynamic tiering, then functional capability is improved, but system complexity increases making backup difficult
Solution Approach 1:
The third-party backup tool is designed with multi-functionality to handle both dynamic tiering databases and non-dynamic tiering databases through a single unified interface. This universal backup solution eliminates the need for separate backup procedures for each database type, reducing operational complexity despite system heterogeneity.
Solution Approach 2:
The backup system segments management tasks by database type while maintaining a unified control plane. The third-party tool independently manages dynamic tiering backups and non-dynamic tiering backups through separate but coordinated processes, simplifying the overall complex system through structured division of labor.
3Ease of manufacture
If separate backup methods are used for dynamic and non-dynamic tiering databases, then compatibility with native DBMS is improved, but backup synchronization deteriorates
Solution Approach 1:
The patent merges separate backup operations for dynamic and non-dynamic tiering databases into a coordinated unified backup process. The third-party backup tool combines both backup types under a single management framework that ensures synchronization, while still utilizing native DBMS compatibility features for each database type.
Solution Approach 2:
The unified backup algorithm implements feedback mechanisms that monitor the state of both dynamic and non-dynamic tiering databases during backup operations. This feedback enables real-time coordination and synchronization adjustments, ensuring consistent backup states across heterogeneous database types while maintaining native compatibility.
Data Source
AI summary
Synchronized backup and recovery of heterogeneous DBMSs is described herein. An embodiment operates by receiving, by at least one processor, a request for a data backup process at a first server; creating, by at least one processor, a pipe between processes of the first sever and the data backup process; performing, by at least one processor, the data backup process according to an execution command sent from a second server; and sending, by at least one processor, a result of the data backup process from the second server to the first server when the data backup process has terminated.