Daily Edition · Page 15

THE DAILY INDEX

Technology, AI, software, security, crypto and business

GENERAL

TLDR Data

VECTOR SEARCH ON APACHE ICEBERG WITHOUT MOVING SOURCE DATA

StarTree adapts Pinot's HNSW vector index for Iceberg tables, keeping Parquet source records in object storage while storing and serving a derived index alongside them. This enables hybrid similarity and SQL-filtered queries without a second copy of the records. The trade-off: indexes are roughly as large as the embeddings, and freshness follows Iceberg snapshot synchronization rather than real-time ingestion.

SEE IT →

Summary unavailable

ACTIVE-ACTIVE ORACLE GOLDENGATE ACROSS REGIONS: DECIDE WHO OWNS THE DATA BEFORE YOU RESOLVE CONFLICT

Active-active GoldenGate only works when data ownership and conflict policy are designed table by table before replication starts. Simulations showed that even convergent strategies like last-writer-wins can silently lose updates, while delta merging preserves each decrement but cannot prevent both regions from accepting a request against the same last unit before replication catches up. The lesson is blunt: if business rules cannot tolerate reconciliation, do not rely on multi-master replication to fix the problem later.

WHAT FIVE P99 CONF TALKS REVEAL ABOUT DATABASE TRADE-OFFS

A sponsored P99 CONF round-up exposes the costs behind several database designs: object storage trades low-cost durability for cold-read latency, read-optimized engines trade RAM and write amplification for tail latency, and vector search trades quantization and cache complexity for scale. The reported benchmarks are workload-specific, but the recurring lesson is: removing one bottleneck moves the constraint elsewhere.

TLDR IndexPage 15