1 / 5

Oracle Change Data Capture

Are you looking to migrate or load SQL Server data to Snowflake? Check out the highly optimized tool from BryteFlow. Our automated solution has low latency, log-based replication, and very low compute to minimize Snowflake data costs. Manage large volumes at lightning speeds. Contact us for more details and expert advice.

3116
Download Presentation

Oracle Change Data Capture

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A Guide to Change Data Capture Feature in Oracle Database

  2. Change Data Capture (CDC) is software design patterns that are used to monitor changes in input in the database at source so that specific actions can be taken based on those changes. The process takes into account all types of changes made to the source of enterprise databases like data capture and data identification.

  3. Oracle Change Data Capture allows data integration in real-time across business networks, thereby enhancing the performance and availability of databases and speeding up all data warehouse activities. This technology enables implementation of critical replication processes without any lag or drop in performance of the databases. The tasks optimized with Oracle Change Data Capture include migrating databases to the cloud without any downtime or stoppage of work and carrying out analytics from databases in production to data warehouses. Incremental data can also be extracted from different sources and transferred to a data warehouse with Oracle CDC. • One of the main functions of Oracle Change Data Capture is capturing and preserving data in a data warehouse environment that can also be used as a data repository system or any other database. This makes it easy for developers to set up Oracle CDC mechanisms through application logic or physical storage in several groupings of system layers.  • Oracle CDC does not depend on intermediate files to place the data outside the relational database. It captures the change data that is a result of INSERT, UPDATE, and DELETE operations that are made to user tables. The change data is then stored in a change table which is a database object and this change data can be used by applications in a controlled manner.

  4. What is the effect of database extraction with Oracle Change Data Capture? • Extraction: With CDC, database extraction happens immediately from INSERT, UPDATE, and DELETE operations at the same time that the changes take place in the source tables. Without CDC, database extraction is not effective for INSERT operations and very problematic for UPDATE, and DELETE as the data is no longer available in the table.  • Staging: With CDC, staging data is directly placed in relational tables and flat files are not required. Without CDC, the contents of the entire tables are moved into flat files.  • Interface: CDC provides an easy-to-use publish and subscribe interface through DBMS_LOGMNR_CDC_PUBLISH and DBMS_LOGMNR_CDC_SUBSCRIBE packages. Without CDC, the process is susceptible to errors and requires extensive manpower to administer.  • Costs: Oracle CDC is provided with the Oracle 9i and later database server. Overhead costs are reduced by simplifying the extraction of change data. Without CDC, the process is expensive as the capture software must be written and maintained in-house or be purchased from a third-party vendor.   • The Oracle Change Data Capture feature was first introduced by Oracle in its 9i version. Subsequently, Oracle released another version with Oracle 10g that leveraged redo logs of the source database called Oracle Streams. 

More Related