变化数据捕获研究及基于SQL SERVER的开发与应用

Research on the Change Data Capture and Its Application in SQL SERVER Database

变化数据捕获是数据集成的核心内容,为高效地实现数据集成,探讨了变化数据捕获的常见机制,重点介绍了SQL SERVER的变化数据捕获方案———更改跟踪和变化数据捕获,并以实际开发项目为背景,介绍在偶尔连接场景下,如何运用变化数据捕获技术,合理设计数据集成方案,满足业务要求,实现异构数据源的有效更新.

The change data capture is the core content of data integration. For implementing data integration efficiently, this paper introduced the usual methods of change data capture,laid heavy stress on the change data capture solutions of SQL SERVER and demonstrated how to use it with an application example.