Database Backup Integration Using Topology Discovery and Streaming
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Integrating the functionality of multiple databases is complex due to the particulars of each technology, and existing systems lack efficient methods for providing backup services to databases.
Innovation Solution
A Cloud Data Management (CDM) system is used as a storage layer for a third-party database, with an agent installed in a TPD host interacting with a Receiver Service (RS) to facilitate backup operations, utilizing a Backint interface for SAP HANA databases, and configuring an interface module to stream updates to a second database system.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If multiple databases are integrated to provide unified functionality, then the versatility and feature set improve, but the system complexity increases due to technology particulars
Solution Approach 1:
The patent introduces a storage service as an intermediary layer between the database and distributed storage system. This storage service abstracts the complexity of integrating multiple database technologies by providing a unified interface for data operations, thereby enabling versatile database functionality while managing integration complexity through the mediator layer
2Adaptability or versatility
If manual scripts are used for backup operations, then flexibility in customization is improved, but the ease of operation deteriorates due to manual intervention requirements
Solution Approach 1:
The patent implements automated backup operations where the storage service and distributed storage system automatically perform backup, restore, and data management tasks without requiring manual script execution. The system self-configures backup policies, automatically discovers database topology, and executes backup operations, thereby improving ease of operation while maintaining flexibility through configurable parameters
3Reliability
If distributed storage system is used for database backup, then the reliability and data protection improve, but the device complexity increases due to multi-node architecture
Solution Approach 1:
The patent creates a universal storage service layer that handles multiple functions including backup, restore, data migration, and storage management across the distributed storage system. This multi-functional approach improves data protection reliability while reducing perceived complexity by providing a single unified interface that abstracts the underlying distributed system complexity
Data Source
AI summary
Methods, systems, and computer programs are presented for providing backup services to a database. One method includes operations for installing a backup agent in a first database, receiving information about the first database, and executing, by the backup agent, queries to the first database to determine a topology of the first database. Further, the method includes configuring, based on the topology, a receiver service of a second database for backing up the first database in the second database. The backup agent configures an interface module of the first database to back up the first database to the second database. The configuration includes an interface to the receiver service of the second database and connection information for storing data in one or more nodes of the second database. The interface module streams updates from the first database to the second database based on the configuration of the interface module.