Integrating co-deployed databases for data analytics

1. A non-transitory computer readable storage medium storing instructions, which when executed by a computer cause the computer to perform operations comprising:

identifying a source database and a destination database co-deployed within an operating system of a first machine, wherein the source database is one of an object-oriented database and a row database, and the destination database is a column database that stores one or more fields of data as columns;

identifying a connector installed within the operating system of the first machine and configured to synchronize the source database and the destination database;

triggering the connector for synchronizing the source database and the destination database;

reading by the connector, a shared memory to identify an event received from the source database;

reading a mapping configuration to map corresponding data fields of the source database and the destination database;

based upon the received event and the mapping configuration, determining data to be read from the source database;

reading the determined data from the source database; and

writing the read data to corresponding data fields of the destination database.

2. The computer readable medium of claim 1 , wherein the event is related to one of addition of data to the source database, deletion of data from the source database, and updating of data in the source database.

3. The computer readable medium of claim 2 , wherein the event comprises one or more key fields related to the data which is added, deleted, or updated.

4. The computer readable medium of claim 1 , wherein the event is received by reading a shared memory or through a change-log.

5. The computer readable medium of claim 4 , wherein the connector monitors the shared memory or change-log in real time or at a predefined time interval for determining the event.

6. The computer readable medium of claim 1 , further comprising instructions, which when executed by the computer cause the computer to:

executing, by the connector, a task or a thread for integrating the source database and the destination database.

7. A computer-implemented method for synchronizing co-deployed databases, the method comprising:

identifying a source database and a destination database co-deployed within an operating system of a first machine, wherein the source database is one of an object-oriented database and a row database, and the destination database is a column database that stores one or more fields of data as columns;

identifying a connector installed within the operating system of the first machine and configured to synchronize the source database and the destination database;

triggering the connector for synchronizing the source database and the destination database;

reading, by the connector, a shared memory to identify an event received from the source database;

reading a mapping configuration to map corresponding data fields of the source database and the destination database;

based upon the received event and the mapping configuration, determining data to be read from the source database;

reading the determined data from the source database; and

writing the read data to corresponding data fields of the destination database.

8. The computer-implemented method of claim 7 , wherein reading the shared memory comprises reading a change-log.

9. The computer-implemented method of claim 8 , wherein the connector monitors the shared memory or change-log in real time or at a predefined time interval for determining the event.

10. The computer-implemented method of claim 7 further comprising:

executing, by the connector, a task or a thread for integrating the source database and the destination database.

11. A computer system for integrating and synchronizing co-deployed databases, the system comprising:

at least one memory to store executable instructions; and

at least one processor communicatively coupled to the at least one memory, the at least one processor configured to execute the executable instructions to:

identify a source database and a destination database co-deployed within an operating system of a first machine, wherein the source database is one of an object-oriented database and a row database, and the destination database is a column database that stores one or more fields of data as columns;

identify a connector installed within the operating system of the first machine and configured to synchronize the source database and the destination database;

trigger the connector for synchronizing the source database and the destination database;

read, by the connector, a shared memory to identify an event received from the source database;

read a mapping configuration to map corresponding data fields of the source database and the destination database;

based upon the received event and the mapping configuration, determine data to be read from the source database;

read the determined data from the source database; and

write the read data to corresponding data fields of the destination database.

12. The system of claim 11 , wherein the event is related to one of addition of data to the source database, deletion of data from the source database, and updating of data in the source database and wherein the event comprises one or more key fields related to the data which is added, deleted, or updated.

13. The system of claim 11 , wherein reading the shared memory comprises reading a change-log.

14. The system of claim 13 , wherein the connector monitors the shared memory or change-log in real time or at a predefined time interval for determining the event.

15. The system of claim 11 , wherein the processor is further configured to execute the executable instructions to:

execute the task or a thread for integrating the source database and the destination database.