Hard Database Systems Distributed Databases
What is Change Data Capture (CDC) and how is it implemented?
Answer
CDC captures database changes (inserts, updates, deletes) for streaming to other systems. Methods: Log-based (read transaction log - Debezium, most efficient, no query overhead), Trigger-based (database triggers write changes - adds latency), Timestamp-based (poll for recent changes - simple but misses deletes), Diff-based (compare snapshots - resource intensive). Use cases: event sourcing, search index sync, data warehousing, microservices sync. Log-based preferred for production; consider schema evolution.
IIT Certified
Master These Concepts with IIT Certification
175+ hours of industry projects. Get placed at Bosch, Tata Motors, L&T and 500+ companies.
Relevant for Roles
Data Engineer Senior Software Engineer Systems Architect