Combined Database Load and Backup to Cut Read Operations
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database management systems require separate load and dump functions, leading to inefficient use of computational resources and increased processing time due to the need for multiple read and transformation operations, especially when creating backups.
Innovation Solution
A combination load and dump function that automates the transformation and storage of data in a database while generating a backup, eliminating the need for separate read operations and reducing the number of steps required.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If separate load and dump functions are used, then data can be loaded and backed up, but computational resources are used inefficiently and processing time increases
Solution Approach 1:
The patent combines the load function and dump function into a single integrated operation. When data is loaded into the database, the system automatically generates a backup in the same operation sequence, eliminating the need for a separate dump function. This merging reduces the number of read operations and transformations required, thereby improving productivity while reducing computational resource consumption.
Solution Approach 2:
The load function is enhanced to perform multiple functions: loading data into the database and simultaneously creating a backup. This multi-functional approach allows the same data transformation and loading mechanism to serve both the primary database and backup storage, improving resource efficiency without sacrificing backup capability.
2Reliability
If separate load and dump functions are used, then data can be loaded and backed up, but the number of operations increases
Solution Approach 1:
The patent merges the load and dump operations into a single integrated function. The system loads data into the database and automatically triggers a backup operation as part of the same process flow. This reduces the total number of discrete operations from two separate functions (load then dump) to one unified operation, simplifying the system while maintaining complete backup reliability.
3Productivity
If data is read from database for backup, then backup can be created, but input/output processes increase
Solution Approach 1:
The system performs the data transformation and preparation in advance during the load operation itself, before the backup is needed. When data is loaded into the database, it is already in the transformed format required for backup. This preliminary action eliminates the need for subsequent read and transformation operations during backup creation, reducing I/O processes and improving backup speed.
Data Source
AI summary
Embodiments of the present disclosure include systems and methods for optimizing functions of a database system. A combination load and dump function is recited that transforms a first set of backup data into a set of transformed data, where the first set of backup data is accessed in response to receiving a request to load the first set of backup data to the database. A set of operations is automatically executed and includes loading the database with the set of transformed data and storing the set of transformed data in a second set of backup data. This combination load and dump function removes the need for a subsequent read function to read data previously loaded to a database file in order to perform the dump function.