Synchronizing query result between heterogeneous databases

A method for synchronizing query results between databases which are performed in a second database server, the method comprising:

• receiving a synchronization command from a first database server which is remotely located from the second database server in which there is a master table in the first database server, there is a materialized view which refers to the master table, in the second database server, and the first database server and the second database server are heterogeneous;
• and
• performing synchronization between the materialized view present in the second database server and the master table present in the first database server, in response to the received synchronization command.

A second database server which synchronizes query results between databases, the server comprising:

• a communication module which is configured to receive a synchronization command from a first database server which is remotely located from the second database server in which there is a master table in the first database server, there is a materialized view which refers to the master table, in the second database server, and the first database server and the second database server are heterogeneous;
• and
• a synchronization module which is configured to perform synchronization between the materialized view present in the second database server and the master table present in the first database server, in response to the received synchronization command.

A computer program stored in a computer readable medium including encoded commands, wherein when the computer program is executed by one or more processors of a computer system, the computer program allows the one or more processors to perform the following operations, and the operations comprise:

• an operation of receiving a synchronization command from a first database server which is remotely located from a second database server in which there is a master table in the first database server, there is a materialized view which refers to the master table, in the second database server, and the first database server and the second database server are heterogeneous;
• and
• an operation of performing synchronization between the materialized view present in the second database server and the master table present in the first database server, in response to the received synchronization command.