Data Synchronization for Distributed Heterogeneous Database

Abstract

Heterogeneous distributed database concurrent data is one of the important topics of heterogeneous databases that have important meaning. This paper discusses the mechanism of optimizing data synchronization for distributed heterogeneous database and trying to propose real solutions. Database synchronization is the exchange of records in databases on the condition that they are different. When modifications are made to a specific database, they will be applied to the database that has been synchronized in different environments and servers horizontally. The synchronization is either a one-way or two-way application and can be incidental, i.e. it is synchronous to the local network and asynchronous to the Internet due to its lagging technology. Heterogeneous distributed database systems consisting of a row storage database and a column storage database will face many difficulties, due to the inconsistent storage type such as: synchronization speed mismatch in data synchronization compared to a homogeneously distributed database system. Heterogeneous database management systems work on exchanging information for a package of various formats, accessing modification information in a heterogeneous database, maintaining the independence of the proposed system, and ensuring a good application of the proposed system in order to reach data synchronization between several packages of databases.