Parallel Database Backup and Restore Mechanism
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database backup and restore processes are inefficient as they typically involve sequential operations, taking a long time to complete when dealing with large amounts of data across multiple locations.
Innovation Solution
Implementing a parallel database system that generates and executes multiple backup and restore commands simultaneously, allowing data to be backed up from multiple locations to a single location and restored from a single location to multiple locations in parallel.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of time
If sequential backup operations are used, then system complexity is low, but backup time is excessively long for large amounts of data across multiple locations
Solution Approach 1:
The patent divides the backup operation into multiple parallel segments, each handling a specific data location or data store. The backup system generates separate backup commands for each location simultaneously, allowing concurrent execution of multiple backup operations rather than sequential processing, thereby reducing total backup time while maintaining manageable system complexity through structured parallelism
2Productivity
If parallel backup commands are executed simultaneously, then backup speed increases, but coordination and management complexity increases
Solution Approach 1:
The patent merges multiple individual backup operations into a single coordinated parallel backup process. By generating and executing multiple backup commands simultaneously across different data locations and data stores, the system achieves higher backup speed while the merging principle helps manage coordination complexity through unified parallel execution rather than separate sequential operations
3Loss of time
If sequential restore operations are used, then system simplicity is maintained, but restore time is unacceptably long for recovering large amounts of data
Solution Approach 1:
The patent segments the restore operation into multiple parallel tasks, where data is restored from a single data store to multiple locations simultaneously. Each restore command targets a specific location and executes in parallel with others, dramatically reducing total restore time while the segmentation structure keeps system complexity manageable through organized parallel restoration processes
4Productivity
If parallel restore commands are executed simultaneously, then restore efficiency increases, but system complexity increases
Solution Approach 1:
The patent combines multiple restore operations into a unified parallel restore process. By generating and executing multiple restore commands simultaneously from a single data store to multiple locations, the system achieves high restore efficiency while the merging principle manages command coordination complexity through integrated parallel execution rather than separate sequential operations
Data Source
AI summary
Embodiments are directed to simultaneously backing up data from multiple locations to a single location and to restoring data from a single location to multiple locations simultaneously. In an embodiment, a computer system receives a backup command from a user which indicates that various specified portions of data are to be backed up. The data portions are stored in multiple different locations in a parallel database. The computer system generates multiple backup commands specific for each location in which the data is stored. The backup commands initiate a parallel backup from the various locations to a single location in a data store. The computer system also executes the generated backup commands in parallel, so that the data from each of the different locations is backed up in the data store.