Virtual-Hosted Database Backup Segmentation for Faster Restoration

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Cloud-based database backups face challenges such as latency in data transfer, slow restoration times, and cybersecurity risks due to outdated database applications, particularly when restoring from incorrect versions.

Innovation Solution

A system and method for generating separate backups of database data and machine configurations using column-oriented storage format, including product keys, to facilitate fast and secure restoration of virtualized databases.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If cloud-based database backups are used, then data storage and offsite backup are enabled, but data transfer latency increases and restoration speed decreases

Engineering Contradiction:

Improvedata availabilityVSAvoidrestoration speed

Core Design Contradiction:

ReliabilityVSSpeed

Solution Approach 1:

The patent segments the backup into two independent parts: a machine backup (virtual machine image) and a data backup (database data files). This allows the data backup to be stored separately from the machine, enabling selective restoration of only the data portion when needed, thereby reducing transfer latency and improving restoration speed while maintaining reliability.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent extracts the data backup from the machine backup process. Instead of backing up the entire virtual machine including all temporary files and system data, the system extracts only the essential database data files for separate backup and restoration, reducing the amount of data transferred and improving restoration performance.

Inventive Principle:

Principle #2Taking out (Extraction)

2Reliability

If full database backup is performed, then complete data recovery is ensured, but storage space consumption increases

Engineering Contradiction:

Improvedata recovery completenessVSAvoidstorage space

Core Design Contradiction:

ReliabilityVSVolume of stationary object

Solution Approach 1:

The patent extracts only the essential database data files from the virtual machine for backup, excluding temporary files, system data, and other non-essential components. This selective extraction ensures complete data recovery capability while significantly reducing the storage space required compared to full virtual machine backup.

Inventive Principle:

Principle #2Taking out (Extraction)

Solution Approach 2:

The patent applies different backup strategies to different components: the machine backup includes all necessary system files and configurations for virtual machine restoration, while the data backup includes only the essential database data files. This differentiated approach optimizes storage space utilization while maintaining recovery completeness.

Inventive Principle:

Principle #3Local quality

3Reliability

If database backup restores to outdated application version, then data recovery is achieved, but cybersecurity risks increase

Engineering Contradiction:

Improvedata recoveryVSAvoidcybersecurity risk

Core Design Contradiction:

ReliabilityVSObject-affected harmful factors

Solution Approach 1:

The patent segments the restoration process into separate steps: first restoring the machine with the updated database application, then applying the data backup. This segmentation ensures that the application version is updated before data restoration, eliminating cybersecurity risks associated with outdated applications while maintaining complete data recovery.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent performs preliminary action by restoring the machine with the updated database application before applying the data backup. This ensures that the application is up-to-date and secure before the data is restored, preventing cybersecurity vulnerabilities while maintaining data recovery integrity.

Inventive Principle:

Principle #10Preliminary action

4Adaptability or versatility

If virtual machine backup includes all files, then complete system restoration is enabled, but temporary files consume excessive storage space

Engineering Contradiction:

Improvesystem restoration capabilityVSAvoidstorage space

Core Design Contradiction:

Adaptability or versatilityVSVolume of stationary object

Solution Approach 1:

The patent segments the backup into machine backup (virtual machine image) and data backup (database data files). The machine backup includes all necessary system files for virtual machine restoration, while the data backup separately stores only the essential database data, eliminating redundant storage of temporary files and reducing overall storage space requirements.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent applies different backup scopes to different components: the machine backup captures the complete virtual machine state for system restoration, while the data backup focuses only on essential database data. This differentiated backup strategy maintains system restoration capability while minimizing storage space consumption from temporary files.

Inventive Principle:

Principle #3Local quality

Data Source

PatentUS12461827B1System and method for backup and restoration of a virtual-hosted database system

Publication Date: 2025.11.04 EON IO LTD

AI summary

A system and method for the device may include accessing a database application hosted on a virtual machine, the virtual machine deployed in a computing environment. In addition, the device may include exporting data stored in the database application to a plurality of files, each file utilizing a column-oriented storage format; generating a virtualization backup only of the virtual machine; and generating a data backup of the database application based on the plurality of files.