Automated Backup for Integrated Domino and DB2 Databases
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current methods for backing up and recovering integrated database systems like Domino and DB2 are manual, error-prone, and lack an integrated programmatic approach, requiring in-depth knowledge of both systems and separate methods for traditional and relational database formats.
Innovation Solution
An automated and programmatic client-server backup and recovery system using backup/recovery client and server software that manages backup and recovery processes programmatically, utilizing APIs to coordinate the backup and restoration of data and metadata across linked databases with different structures, such as Lotus Notes/Domino and DB2.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If manual backup and recovery methods are used for integrated database systems, then backup and recovery can be performed, but the process is error-prone and requires in-depth knowledge of both Domino and DB2 systems
Solution Approach 1:
The patent introduces a backup agent as an intermediary component that automatically manages the backup and recovery process. This agent coordinates between Domino and DB2 systems, eliminating the need for manual intervention and reducing errors. The agent serves as a mediator that handles the complexity of integrated database backup by automating the coordination between different database systems.
Solution Approach 2:
The backup system performs self-service through automated agents that independently execute backup and recovery operations without requiring manual intervention. The system automatically identifies database files, creates backups, manages metadata, and restores data when needed, reducing operational complexity and eliminating the need for deep system knowledge.
2Reliability
If separate methods are used to independently backup Domino and DB2 databases, then each database can be backed up, but the process requires manual coordination and is error-prone
Solution Approach 1:
The patent merges the backup processes for Domino and DB2 databases into a single integrated operation. The backup agent simultaneously manages both database systems, creating coordinated backups of both the Domino namespace files and DB2 database files along with their metadata. This unified approach eliminates the need for separate manual backup procedures and reduces process complexity.
Solution Approach 2:
The backup agent is designed with multi-functionality to handle both Domino and DB2 database systems through a single interface. It performs diverse functions including backing up Domino namespace files, backing up DB2 database files, managing metadata, and coordinating recovery operations across both systems, thereby simplifying the overall backup process.
3Ease of operation
If automated backup and recovery is implemented for integrated databases, then errors and complexity are reduced, but a unified programmatic approach must be developed that coordinates multiple database systems
Solution Approach 1:
The patent segments the backup and recovery functionality into distinct modular components: a backup agent for Domino namespace files, a backup agent for DB2 database files, and a coordination mechanism that manages metadata. This segmentation allows each component to handle specific database systems independently while the coordination mechanism integrates them, reducing overall system integration complexity.
Solution Approach 2:
The patent introduces a metadata coordination mechanism as an intermediary that manages the relationship between Domino and DB2 database backups. This mediator stores and coordinates metadata that links namespace files to their corresponding DB2 databases, enabling automated recovery without requiring complex direct integration between the database systems.
Data Source
AI summary
A programmatic method for automatically backing up and restoring an integrated database system including a Lotus Notes/Domino loosely structured database and a linked DB2 relational database that stores data mapped from the Domino database. The method includes integrated first and second client application programs running on server hosts for backup and recovery of the Domino and DB2 databases that communicate with the database managers for the databases using client application APIs. Backup and recovery of the integrated linked databases is controlled by the client application associated with the Domino database.