Category

data engineering

7 articles

Stream Processing Pipeline Pattern: Stateful Real-Time Data Products

TLDR: Stream pipelines succeed when event-time semantics, state management, and replay strategy are designed together — and Kafka Streams lets you build all three directly inside your Spring Boot service. Stripe's real-time fraud detection processes...

15 min read

Lambda Architecture Pattern: Balancing Batch Accuracy with Streaming Freshness

TLDR: Lambda architecture is justified when replay correctness and sub-minute freshness are both non-negotiable despite dual-path complexity. TLDR: Lambda architecture is a fit only when you need both low-latency views and deterministic recompute fro...

12 min read

Dimensional Modeling and SCD Patterns: Building Stable Analytics Warehouses

TLDR: Dimensional modeling with explicit SCD policy is the foundation for reproducible metrics and trustworthy historical analytics. TLDR: Dimensional models stay trustworthy only when teams define grain, history rules, and reload procedures before d...

13 min read

Data Pipeline Orchestration Pattern: DAG Scheduling, Retries, and Recovery

TLDR: Pipeline orchestration is an operational control plane problem that requires explicit dependency, retry, and backfill contracts. TLDR: Pipeline orchestration is less about drawing DAGs and more about controlling freshness, replay, and recovery ...

13 min read

Change Data Capture Pattern: Log-Based Data Movement Without Full Reloads

TLDR: Change data capture moves committed database changes into downstream systems without full reloads. It is most useful when freshness matters, replay matters, and the source database must remain the system of record. TLDR: CDC becomes production-...

14 min read

Big Data Architecture Patterns: Lambda, Kappa, CDC, Medallion, and Data Mesh

TLDR: A serious data platform is defined less by where files are stored and more by how changes enter the system, how serving layers are materialized, and who owns quality over time. Lambda, Kappa, CDC, Medallion, and Data Mesh are patterns for makin...

15 min read

Data Warehouse vs Data Lake vs Data Lakehouse: Which One to Choose?

TLDR: Warehouse = structured, clean data for BI and SQL dashboards (Snowflake, BigQuery). Lake = raw, messy data for ML and data science (S3, HDFS). Lakehouse = open table formats (Delta Lake, Iceberg) that bring SQL performance to raw storage — the ...

14 min read