Database Synchronization System Segregating RDBMS and NoSQL Workloads
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Relational Database Management Systems (RDBMS) face performance issues due to increasing data size, making it difficult to retrieve data quickly, especially for mobile applications, and current hybrid data management systems do not effectively distribute processing tasks between RDBMS and NoSQL databases for fast data retrieval.
Innovation Solution
A method and system for synchronizing RDBMS with NoSQL databases by receiving predefined business logic, segregating it into processing divisions, and assigning tasks to both systems, allowing the NoSQL database to retrieve data directly without Object-Relation Mapping (ORM) conversion, thereby distributing processing overhead and improving data retrieval speed.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data is stored in RDBMS in tabular format, then data integrity and transaction reliability are maintained, but data retrieval speed and processing performance deteriorate as data size increases
Solution Approach 1:
The patent segments the database system into two parts: RDBMS for storing transactional data with integrity constraints, and NoSQL database for fast data retrieval. The synchronization mechanism divides data between these two systems, allowing each to operate in its optimal performance mode without compromising data integrity.
Solution Approach 2:
The patent introduces a synchronization mechanism as an intermediary between RDBMS and NoSQL database. This mediator maintains data consistency across both systems, ensuring that data integrity is preserved while enabling fast retrieval through the NoSQL component.
2Reliability
If all processing tasks are handled by RDBMS, then data consistency is maintained, but processing overhead and retrieval time increase
Solution Approach 1:
The patent segments processing tasks between RDBMS and NoSQL database based on their respective strengths. RDBMS handles transactional operations requiring consistency, while NoSQL handles retrieval operations requiring speed, thereby reducing overall processing time while maintaining data consistency through the synchronization mechanism.
3Speed
If hybrid database system is implemented, then data retrieval speed is improved, but system complexity and synchronization overhead increase
Solution Approach 1:
The synchronization mechanism is designed to be universal, handling multiple types of operations (insert, update, delete, query) through a unified approach. This multi-functionality reduces the need for separate synchronization logic for different operations, thereby managing system complexity while enabling fast data retrieval through the hybrid architecture.
Data Source
Figure 1A
Figure 1B
Figure 2
AI summary
The present disclosure relates to method and system for synchronization of a Relational Database Management System (RDBMS) to a non-Structured Query Language (noSQL) database. A database synchronization system receives a user request and associated predefined business logic from a user device for retrieving one or more transactional data and synchronizes the RDBMS to the noSQL database based on the predefined business logic. The database synchronization system segregates the predefined business logic into one or more processing divisions and assigning the one or more processing divisions to the RDBMS and the noSQL database. Further, the noSQL database retrieves data related to one or more elements of one or more tables related to the one or more transactional data from the RDBMS. Thereafter, the noSQL database transforms the retrieved data and provide to the database synchronization system. Finally, database synchronization system provides transformed data received from the noSQL database to the user device.