For incremental update the popular strategy is trigger and mining log.
The materialized view and synchronous CDC is replicating data utilizing the trigger strategy.
Stream and asynchronous utilizing the mining log.
CDC(Change Data Capture) is designed for the incremental extract for ETL which can be divided by Asynchronous and synchronous. We need not synchronous. So let us analyze the asynchronous. CDC also provide the interface to stream.
Oracle Streams enables information sharing. Using Oracle Streams, each unit of shared
information is called a message, and you can share these messages in a stream. The
stream can propagate information within a database or from one database to another.
The stream routes specified information to specified destinations. The result is a
feature that provides greater functionality and flexibility than traditional solutions for
capturing and managing messages, and sharing the messages with other databases
and applications. Streams provides the capabilities needed to build and operate
distributed enterprises and applications, data warehouses, and high availability
solutions.
We can use stream for data warehouse loading.Data warehouse loading is a special case of data replication. Some of the most criticaltasks in creating and maintaining a data warehouse include refreshing existing data,and adding new data from the operational databases. Streams components can capture
changes made to a production system and send those changes to a staging database or
directly to a data warehouse or operational data store. Streams capture of redo data
avoids unnecessary overhead on the production systems. Support for data
transformations and user-defined apply procedures enables the necessary flexibility to
reformat data or update warehouse-specific data fields as data is loaded. In addition,
Change Data Capture uses some of the components of Streams to identify data that
has changed so that this data can be loaded into a data warehouse.
The difference between the CDC and stream.
CDC encapsulate the complex details for replication so it is simpler than stream.
Stream give you more option to meet you needs and provide the interface for user definition procedures.
分享到:
相关推荐
D. Ross, J. Lim, R.-S. Lin, and M.-H. Yang. Incremental Learning for Robust Visual Tracking. IJCV, 77(1):125–141, 2008.
基于增量PCA的视觉跟踪技术,引用率很高的一篇文章,很经典
An ultra-fast universal incremental update algorithm for trie-based routing lookup
Devised to rescue failing IT implementations, Incremental Software Architecture presents an advanced approach for designing durable, flawless, and elastic software systems to enable business growth....
SVD-Based Incremental Approaches for Recommender Systems
is intended to characterize it as a fully planned and coherent system, rather than an incremental accretion of very speci c and in exible tools, as is frequently the case with other data analysis ...
As today’s organizations are capturing exponentially larger amounts of data than ever, now is the time for organizations to rethink how they digest that data. Through advanced algorithms and ...
增量式更新
Incremental Few-Shot Learning for Pedestrian Attribute Recognition
An Incremental Tuning Method Based on Ultraconservative Update for Statistical Machine Translation
Master pandas, an open source Python Data Analysis Library, for financial data analysis About This Book A single source for learning how to use the features of pandas for financial and quantitative ...
自适应草图识别的SVM方法,孙正兴,彭彬彬,适应性是以用户为中心的人机交互的关键问题。本文针对基于手绘草图识别的人机交互提出了一种基于SVM的增量学习方法,该方法分别采
To balance the accuracy and efficiency in multiple-view triangulation with sequential images, a high-efficiency propagation-based incremental triangulation (INT) method, carving three-dimensional (3D)...
Incremental support vector machine combined with ultraviolet-visible spectroscopy for rapid discriminant analysis of red wine
Incremental SVM 可实现SVM的在线学习功能
一种基于matlab自带SVMtrain模型训练函数的在线SVM增量学习方法代码。
Incremental Sampling-based Algorithms for Optimal Motion Planning, Robotics
KM_IKM Oracle Incremental UpdateLOB.xml KM_LKM SQL to SQL LOB(JYTHON).xml 里面包含两个KM 可以直接用
This MATLAB package implements the methods for exact incremental/decremental SVM learning, regularization parameter perturbation and kernel parameter perturbation presented in "SVM Incremental ...