Tag: data-warehouse

All the articles with the tag "data-warehouse".

• Kafka (Part 6): Oracle-to-PostgreSQL CDC with Kafka Connect and Debezium, and Cache Consistency

  2 Dec, 2023

  Introduces CDC and synchronizes Oracle data to PostgreSQL through a Kafka Connect and Debezium example. It discusses database synchronization, Elasticsearch imports, and cache consistency, comparing the conditions under which different approaches are suitable.

• PostgreSQL (Part 2): Best Practices for Procedural Language Usage

  26 Nov, 2022

  Database server-side programming with PL/pgSQL.