Tagged articles
Projection
10 articles · Page 1 of 1
This article explains how event sourcing replaces the traditional current‑state table with an immutable event log, allowing systems to reconstruct any state, handle concurrency, support auditing, and power flexible read models through projections, while outlining the necessary architectural components such as aggregates, event stores, snapshots, outbox, idempotency, and the natural transition to CQRS.
IdempotencyOutboxProjection
0 likes · 32 min read

This guide details implementing CQRS and Event Sourcing in Spring Boot, covering command/query separation, event bus choices (Outbox pattern, Kafka), projection idempotency, state snapshots for performance, Saga-based compensation for distributed transactions, and practical tuning tips for production workloads.
Event BusIdempotencyKafka
0 likes · 14 min read

This article walks through Spring Data JPA interface projections—from basic setup and field aliasing to association queries, closed vs. open projections, pagination, and dynamic use—showing how they eliminate redundant data fetching, improve performance, and avoid common pitfalls.
BackendJPAJava
0 likes · 11 min read

This article explains the concepts, standards, and workflows of tile map services, covering WMTS and TMS specifications, map tile fundamentals, projection methods, tile generation, distribution, and rendering techniques with code examples using Leaflet, providing a comprehensive overview for GIS developers.
LeafletProjectionTMS
0 likes · 20 min read

This article provides a comprehensive overview of ClickHouse, covering its origins, core characteristics, and the five most important features introduced in 2021—including JIT acceleration, Lambda‑based UDFs, native window functions, zero‑copy replication for S3/HDFS, and the Projection mechanism—highlighting why it remains a leading high‑performance OLAP database for big‑data analytics.
ClickHouseOLAPProjection
0 likes · 15 min read

This article presents an in‑depth overview of ClickHouse Projection, covering its background, core features, architectural details, practical use cases, performance gains, advantages and drawbacks, and real‑world production results, illustrating how Projection enhances OLAP workloads at Kuaishou.
ClickHouseOLAPProjection
0 likes · 22 min read

The article explains ClickHouse's new Projection feature, how it overcomes MergeTree's single‑sort limitation and materialized view drawbacks, provides step‑by‑step commands to create, materialize, and query projections, demonstrates massive performance gains, and outlines the rules for automatic projection selection.
ClickHouseMaterialized ViewProjection
0 likes · 12 min read

This article presents an in‑depth overview of ClickHouse Projection, covering its background, definition, practical use cases, underlying architecture, query analysis, consistency guarantees, performance comparisons, and real‑world production results, highlighting how it enhances OLAP workloads while maintaining strong data consistency.
ClickHouseOLAPProjection
0 likes · 19 min read

This article presents an in‑depth overview of ClickHouse's Projection feature, covering its background, definition, storage and query mechanisms, practical use‑case demonstrations, performance comparisons with competing OLAP systems, and real‑world production results that highlight its advantages and limitations.
ClickHouseDataWarehouseMaterializedView
0 likes · 20 min read

The article explains how applying filters, projections, and predicate pushdown in Hadoop and Hive reduces data volume, speeds up MapReduce jobs, and improves performance, while also covering join limitations and providing a Java Mapper example for practical implementation.
HadoopHiveMapReduce
0 likes · 4 min read
