Patent application EP16177606A (EP), filed 2016-07-01
Publication number: EP3220291A1
Title: METHOD AND SYSTEM FOR SYNCHRONIZATION OF RELATIONAL DATABASE MANAGEMENT SYSTEM TO NON-STRUCTURED QUERY LANGUAGE DATABASE
Abstract: 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.
IPC codes: G06F  17/    30            A I
G06F  16/    27            A I
G06F  16/    28            A I
Claims: number: 1
text: A computer-implemented method of synchronization of a Relational Database Management System to a non-Structured Query Language database, the method comprising:
number: 2
text: 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.
number: 3
text: The method as claimed in claim 1 or claim 2, further comprising capturing one or more changes made to the data related to the one or more elements of the one or more tables at real time.
number: 4
text: The method as claimed in any preceding claim, wherein the transformed data is provided to the user device without performing Object-Relation Mapping conversion.
number: 5
text: The method as claimed in any preceding claim, wherein the synchronization of the Relational Database Management System to the non-Structured Query Language database is at least one of time bound and performed at real-time.
number: 6
text: A database synchronization system for synchronization of a Relational Database Management System to a non-Structured Query Language database, the database synchronization system comprising:
number: 7
text: 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.
number: 8
text: The database synchronization system as claimed in claim 6 or claim 7, 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.
number: 9
text: The database synchronization system as claimed in any of claims 6 to 8, wherein the processor provides the transformed data to the user device without performing Object-Relation Mapping conversion.
number: 10
text: The database synchronization system as claimed in any of claims 6 to 9, wherein the synchronization of the Relational Database Management System to the non-Structured Query Language database is at least one of time bound and performed at real-time.
number: 11
text: A non-transitory computer readable medium including instructions stored thereon that when processed by at least one processor causes a database synchronization system to perform operations comprising:
number: 12
text: The medium as claimed in claim 11, 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.
number: 13
text: The medium as claimed in claim 11 or claim 12, wherein the instructions further cause the processor 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.
number: 14
text: The medium as claimed in any of claims 11 to 13, wherein the instructions cause the processor to provide the transformed data to the user device without performing Object-Relation Mapping conversion.
number: 15
text: The medium as claimed in any of claims 11 to 14, wherein the synchronization of the Relational Database Management System to the non-Structured Query Language database is at least one of time bound and performed at real-time.
Office action: search_report, dated 2017-09-20
Rejection reasons: novelty_epc_54
Prior art cited: ref_id: US2015154259A1
ref_type: patent
severity: background
ref_id: US2015142736A1
ref_type: patent
severity: background
ref_id: US2014172833A1
ref_type: patent
severity: background
ref_id: US2014172833
ref_type: patent
severity: background
ref_id: US2015142736
ref_type: patent
severity: background
ref_id: US2015154259
ref_type: patent
severity: novelty_destroying
Final disposition: pending (2017-09-20)