基于Oracle物化视图日志的数据同步技术研究

Study of Data Synchronization Based on Oracle Materialized View Log

在当今数据信息系统的开发中,分布式数据库和分布式应用系统间的数据同步问题是一个较为常见且较难解决的问题。现有的各种解决方案存在反映源数据频繁变化比较困难和数据同步效率低等问题。本文通过对Oracle数据库的物化视图日志机制的研究,简要介绍Oracle数据库物化视图日志的数据结构、对数据库记录操作的记录方式,提出了一种基于Oracle数据库物化视图日志的数据库同步技术,为分布式应用系统中数据表间的数据同步提供了一种新思路。

In the process of developping information system,data synchronization between distributed database and distributed appli- cation system is a common and complex problem.There are difficulties in the solutions,e.g, it＇s hard to reflect the frequent changes of data and inefficient for data synchronization.This paper focuses on the mechanism of the materialized view log in Oracle database, discusses the data structure of the materialized view log in Oracle database and how it works, and introduces a method for data synchronization based on the materialized view log in Oracle database.