DATA SYNCHRONIZATION FOR REMOTE AND LOCAL DATABASES

摘要

The present application discloses a data processing method in which an intermediate server sends a user query received from a client server to a remote database server that includes a remote database. In response to the user query, the intermediate server synchronizes data in the local database with data in the remote database using a database link that is established on a database layer. Data in both the local and remote databases are associated with a software application that is implemented on the client server. The intermediate server further generates a materialized view of the synchronized data in the local database, and the materialized view is atomically refreshed with respect to the synchronized data. The intermediate server computes the synchronized database on the materialized view according to a set of business rules associated with the software application, and communicates the computed data to the client server.