Adaptive Data Replication Strategy for Cloud In-Memory Databases
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Traditional database replication methods are impractical and inefficient for cloud-based in-memory databases, often being costly and complex, and may not be compatible with certain database systems, necessitating a more adaptable and efficient approach.
Innovation Solution
A system that assesses a customer's database architecture and recommends an optimal replication strategy, allowing the use of either on-premise or cloud-based replication technologies, or a combination of both, to provide the best performance and cost-effectiveness.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If traditional pre-set replication strategy is used, then data synchronization is achieved, but device complexity and cost increase
Solution Approach 1:
The patent changes the replication approach from traditional pre-set strategies to a new parameter-based methodology that evaluates multiple factors including data change frequency, access patterns, and cloud service characteristics. This allows the system to select from multiple replication parameters (full replication, incremental replication, selective replication) based on actual needs, reducing complexity while maintaining synchronization reliability
Solution Approach 2:
The patent implements a dynamic replication strategy that adapts to changing conditions in cloud-based environments. Instead of using static pre-set replication strategies, the system continuously monitors data characteristics and cloud service states, adjusting replication parameters in real-time to optimize performance and reduce complexity
2Adaptability or versatility
If cloud-based replication is used, then accessibility and scalability improve, but compatibility issues arise with certain database systems
Solution Approach 1:
The patent introduces an intermediary assessment agent that acts as a bridge between cloud-based replication services and various database systems. This agent evaluates compatibility requirements and translates between different database protocols and cloud replication interfaces, enabling cloud accessibility while maintaining compatibility with diverse database systems including in-memory databases
3Reliability
If local database replication is implemented, then data synchronization is maintained, but cost and complexity increase significantly
Solution Approach 1:
The patent applies partial replication strategies where only necessary data subsets are replicated to cloud services based on access patterns and business requirements. Instead of replicating entire databases, the system identifies and replicates only the critical data portions, significantly reducing replication costs while maintaining essential data synchronization
Solution Approach 2:
The patent implements location-aware replication that places data replication locally when possible and uses cloud services only when necessary. The assessment agent determines which data should remain local versus which should be replicated to cloud services, optimizing the balance between synchronization reliability and replication cost
Data Source
AI summary
System, method, and computer program product embodiments enable configuration of a recommended data replication strategy for cloud based in-memory databases. An embodiment operates by requesting, by a first computing device, configuration of an on-demand cloud-based in-memory database, assessing, at the first computing device, database system components, and transmitting database system component information from the first computing device to a second computing device over a network. The first computing device receives from the second computing device an evaluation of the database system components and a recommended replication strategy responsive to a replication rule set. The database system components at the first computing device are then configured to use the recommended replication strategy.