Distributed Database Backup Partitioning for Faster Recovery

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Conventional database backup procedures take too long, especially for large databases, which can be critical in disaster recovery scenarios, as they involve transferring data to a single destination, leading to prolonged downtime.

Innovation Solution

The data is divided into multiple sections and distributed to multiple locations in parallel, using control information and parity sections to ensure redundancy and efficient recovery, with the option of cloud-based or on-site storage.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If data is backed up to a single destination database, then data integrity is ensured, but backup time becomes too long

Engineering Contradiction:

Improvedata integrityVSAvoidbackup time

Core Design Contradiction:

ReliabilityVSLoss of time

Solution Approach 1:

The patent divides the database data into multiple sections and distributes them across multiple destination databases. This segmentation allows parallel backup operations to occur simultaneously to multiple destinations, significantly reducing total backup time while maintaining data integrity through distributed redundancy

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent combines multiple destination databases to work together as a distributed backup system. By merging the capabilities of multiple databases and using parallel backup procedures, the system achieves both fast backup times and reliable data integrity through redundant storage across the combined destinations

Inventive Principle:

Principle #5Merging (Combining)

2Productivity

If data is distributed to multiple locations in parallel, then backup time is reduced, but system complexity increases

Engineering Contradiction:

Improvebackup speedVSAvoidsystem complexity

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The patent introduces a backup system as an intermediary that manages the complexity of distributed parallel backups. This intermediary coordinates data section distribution, monitors backup progress across multiple destinations, and handles recovery operations, thereby enabling high-speed parallel backups without exposing the complexity to users

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent segments the backup process into manageable components: data division into sections, parallel transmission to multiple destinations, and coordinated recovery procedures. This segmentation of the backup process makes the complex distributed system easier to manage and control while maintaining high productivity

Inventive Principle:

Principle #1Segmentation

Data Source

PatentUS20260064543A1Backing up a database in multiple parts to multiple locations to improve timing

Publication Date: 2026.03.05 DIGICERT INC

AI summary

Systems and methods for backing up a database are provided. A method, according to one implementation, includes a step of receiving a command to perform a full backup procedure in which data stored in a database is intended to be backed up. The method further includes a step of detecting physical locations that are available for data storage. Based on the detected physical locations and a data distribution plan, the method further includes a step of dividing the data stored in the database into multiple data sections and distributing the multiple data sections to corresponding physical locations.