Database Backup Replication with Tape Type Override

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Conventional database backup methods require temporary unavailability of the database system, leading to prolonged downtime and issues with control data alteration or loss during backup creation, especially when creating multiple backups for redundancy or testing purposes. Additionally, existing TAPE-TYPE-OVERRIDE mechanisms fail to effectively manage tape type overrides in replicate commands, particularly for commands using multiple reels or different drive types.

Innovation Solution

A method and system for managing tape-type overrides by determining the type of override command (single or double) and ensuring its proper application, replacing tape type identification based on read or write operations in subsequent commands, and alerting users to override restrictions, allowing for seamless replication and backup operations without interrupting database availability.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If multiple backups are created from the database system, then data safety and redundancy are improved, but database system unavailability is prolonged

Engineering Contradiction:
Improvedata safetyVSAvoiddatabase unavailability time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The patent applies preliminary action by creating backups during database unavailability windows and using incremental replication techniques that prepare backup data in advance. The system performs backup operations during scheduled maintenance windows and uses change data capture to replicate only modified records, reducing the time required for each backup operation and allowing multiple backups to be created without proportionally increasing total downtime.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent implements continuity of useful action through incremental backup mechanisms that continue backup operations without requiring complete database shutdowns. The system maintains continuous replication of changed data records and uses streaming backup techniques that allow backup processes to run concurrently with database operations, ensuring that backup creation does not fully interrupt database availability.

Inventive Principle:
Principle #20Continuity of useful action

2Adaptability or versatility

If TAPE-TYPE-OVERRIDE is applied to both source and destination in replicate commands, then tape compatibility is improved, but drive assignment flexibility is reduced

Engineering Contradiction:
Improvetape compatibilityVSAvoiddrive assignment complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent applies local quality by enabling selective tape type override application to either source or destination tape devices independently. The system allows different override configurations for source and destination tapes based on specific drive assignments and compatibility requirements, rather than applying the same override to both. This enables flexible drive assignment where source and destination can have different tape types while maintaining compatibility where needed.

Inventive Principle:
Principle #3Local quality

Solution Approach 2:

The patent implements dynamics by making the tape type override configuration flexible and adaptable based on the specific replicate command parameters. The system dynamically determines which tape devices require override based on their types and assignments, allowing administrators to configure overrides only where necessary rather than applying them universally. This dynamic approach maintains compatibility while preserving drive assignment flexibility.

Inventive Principle:
Principle #15Dynamics

Data Source

PatentUS10007429B2Database replication with continue and tape-type-override functions
Publication Date: 2018.06.26 UNISYS CORP
  • US10007429B2 patent drawing
  • US10007429B2 patent drawing
  • US10007429B2 patent drawing

AI summary

Database performance may be improved by creating additional backups from an existing backup, rather than the original database or audit log source. A second backup may be created from a first backup by copying the files from the first backup to the second backup. The replication from a first backup to a second backup with modification of the file history information allows identical backups to exist on different types of storage devices, including virtual storage devices. Continue functionality may be implemented during a move function to restart replication at a new starting point while retaining the existing move set. Tape-type-override functionality may be implemented during the replication to replace the tape type for the backups with another compatible type while retaining the original type for history file entries, tape trailers, and messages.