Claims:We claim:
1. A method of synchronization of Relational Database Management System (RDBMS) to non-Structured Query Language (noSQL) database, the method comprising:

receiving, by a database synchronization system, a user request and an associated predefined business logic from a user device for retrieving one or more transactional data, wherein the one or more transactional data is stored in the RDBMS;

synchronizing, by the database synchronization system, the RDBMS to the noSQL database based on the predefined business logic;

segregating, by the database synchronization system, 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, wherein the segregation is based on one or more actions to be performed ;

prompting, by the database synchronization system, the noSQL database to retrieve data related to one or more elements of one or more tables related to the one or more transactional data from the RDBMS, wherein the RDBMS performs the one or more actions associated with the one or more processing divisions assigned to the RDBMS on the data related to the one or more elements of the one or more tables;

receiving, by the database synchronization system, a transformed data from the noSQL database, wherein the transformed data is formed by the noSQL database by performing the one or more actions associated with the one or more processing divisions assigned to the noSQL database on the retrieved data related to the one or more elements of the one or more tables; and

providing, by the database synchronization system, the transformed data to the user device.

2. The method as claimed in claim 1, wherein the one or more actions are at least one of cleansing, validation, complex calculations, normalization, consolidation, grouping, filtering and conversion performed on the data related to one or more elements of the one or more tables.

3. The method as claimed in claim 1 further comprises capturing, by the database synchronization system, one or more changes made to the data related to the one or more elements of the one or more tables at real time.

4. The method as claimed in claim 1, wherein the transformed data is provided to the user device without performing Object-Relation Mapping (ORM) conversion.

5. The method as claimed in claim 1, wherein the synchronization of the RDBMS to the noSQL database is at least one of time bound and performed at real-time.

6. A database synchronization system for synchronization of Relational Database Management System (RDBMS) to non-Structured Query Language (noSQL) database, the database synchronization system comprising:
a processor; and
a memory communicatively coupled to the processor, wherein the memory stores the processor-executable instructions, which, on execution, causes the processor to:

receive a user request and an associated predefined business logic from a user device for retrieving one or more transactional data, wherein the one or more transactional data is stored in the RDBMS;

synchronize the RDBMS to the noSQL database based on the predefined business logic;

segregate 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, wherein the segregation is based on one or more actions to be performed on the one or more transactional data;

prompt the noSQL database to retrieve data related to one or more elements of one or more tables related to the one or more transactional data from the RDBMS, wherein the RDBMS performs the one or more actions associated with the one or more processing divisions assigned to the RDBMS on the data related to the one or more elements of the one or more tables;

receive a transformed data from the noSQL database, wherein the transformed data is formed by the noSQL database by performing the one or more actions associated with the one or more processing divisions assigned to the noSQL database on the retrieved data related to the one or more elements of the one or more tables; and

provide the transformed data to the user device.

7. The database synchronization system as claimed in claim 6, wherein the one or more actions are at least one of cleansing, validation, complex calculations, normalization, consolidation, grouping, filtering and conversion performed on the data related to one or more elements of the one or more tables.

8. The database synchronization system as claimed in claim 6, wherein the processor is further configured to capture one or more changes made to the data related to the one or more elements of the one or more tables at real time.

9. The database synchronization system as claimed in claim 6, wherein the processor provides the transformed data to the user device without performing Object-Relation Mapping (ORM) conversion.

10. The database synchronization system as claimed in claim 6, wherein the synchronization of the RDBMS to the noSQL database is at least one of time bound and performed at real-time.

Dated this 17th day of March 2016

SWETHA S.N
OF K & S PARTNERS
AGENT FOR THE APPLICANT
, Description:TECHNICAL FIELD
The present subject matter is related in general to database management systems, and more particularly, but not exclusively to a method and a system for synchronization of Relational Database Management System (RDBMS) to non-Structured Query Language (noSQL) database.