Database Backup System Using Data Compression for Narrow-Band Networks
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database synchronization methods using wide-band networks are costly and inefficient, while methods employing narrow-band networks for disaster recovery systems face challenges in completing synchronization within a reasonable time due to the high volume of data transfer required.
Innovation Solution
A database management system that includes a storage system and a server computer with an update executing unit, an unnecessary information removing unit, and a write unit, utilizing data compression to transfer database updates over a narrow-band network, thereby reducing transfer time and costs.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Speed
If wide-band network is used for database synchronization, then synchronization speed is improved, but network cost increases
Solution Approach 1:
The invention extracts and transfers only the updated data portions from the primary database to the standby database, rather than transferring entire databases. This selective extraction of changed data reduces the volume of network traffic while maintaining synchronization speed, thereby resolving the contradiction between synchronization speed and network cost.
Solution Approach 2:
The database synchronization process is segmented into identification of updated portions and transfer of only those portions. By dividing the synchronization task into identifying changed data segments and transferring only those segments, the system achieves efficient synchronization over narrow-band networks without requiring expensive wide-band infrastructure.
2Loss of energy
If narrow-band network is used for disaster recovery system, then network cost is reduced, but synchronization time increases
Solution Approach 1:
The invention extracts only the essential updated data portions for transfer over the narrow-band network, eliminating unnecessary data transmission. This extraction approach minimizes the amount of data that must traverse the slow narrow-band connection, thereby reducing synchronization time while maintaining cost-effectiveness.
Solution Approach 2:
The system performs preliminary identification of updated data portions before initiating the transfer process. By pre-identifying which data needs to be synchronized, the system prepares the minimal necessary data set for transmission, optimizing the use of narrow-band network resources and reducing overall synchronization time.
3Reliability
If entire database is transferred for synchronization, then data consistency is improved, but data transfer volume increases
Solution Approach 1:
The invention extracts and transfers only the updated data portions rather than the entire database. This selective extraction maintains data consistency by ensuring that only changed data is synchronized, while dramatically reducing the volume of data that must be transferred across the network.
Solution Approach 2:
The system applies partial action by transferring only the necessary updated portions of the database rather than the complete database. This partial transfer approach is sufficient to maintain data consistency between primary and standby systems while minimizing network resource consumption and transfer volume.
Data Source
AI summary
Database synchronization processing is completed within a reasonable time, using narrow-band network that connects a primary site to a secondary site, to reduce the running cost of a system. A primary DBMS has a transaction executing unit for reading a primary DB of a primary storage system to update data as requested in an update request, and a write unit for writing the updated data in the primary storage system. The primary storage system includes an unnecessary information removing unit for overwriting an unused area in the written data successively with one of a preset character and a preset value. The primary storage system is connected, via a network, to a second storage system which stores a copy of the primary DB. The primary storage system is connected to the network via a network device which has a data compression unit for compressing a succession of the same value.