Change Data Capture | Database Interview | Skill-Lync Resources
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.

Master These Concepts with IIT Certification
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