Database Replication Using Heterogeneous Encoding
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Database replication systems require significant storage capacity due to the need for multiple copies of databases, which increases storage requirements and is inefficient in using different encoding formats for redundant copies.
Innovation Solution
Implementing a database replication method that analyzes data patterns and evaluates candidate encoding formats to select an optimal encoding format based on computing cost, allowing for heterogeneous encoding between primary and backup databases, thereby reducing storage needs.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If database replication is implemented to ensure redundancy and accessibility, then data protection and availability are improved, but storage requirements increase significantly
Solution Approach 1:
The patent applies parameter changes by transforming the encoding format parameter of the backup database. Instead of storing backup data in the same encoding format as the primary database, the system converts backup data to a different encoding format (e.g., from UTF-8 to GBK or ASCII), which reduces the storage space required for redundant copies while maintaining data integrity and accessibility.
2Stability of the object's composition
If multiple copies of the database are stored in the same encoding format, then data consistency is maintained, but storage efficiency is reduced
Solution Approach 1:
The patent applies local quality by allowing different parts of the database system (primary vs. backup) to use different encoding formats. The primary database maintains its original encoding format for operational consistency, while the backup database uses a converted encoding format optimized for storage efficiency. This localized differentiation resolves the contradiction between maintaining data consistency and improving storage efficiency.
Data Source
AI summary
A database replication using heterogenous encoding is provided. Aspects include obtaining a database and analyzing a data pattern of data in the database. Aspects also include identifying a plurality of candidate encoding formats and evaluating a computing cost for encoding the database for each of the plurality of candidate encoding formats. Aspects further include selecting an encoding format from the plurality of candidate encoding formats based at least in part on the computing cost and storing a backup copy of the database using the encoding format.