Apr 3 · 5 min read · A streaming data warehouse built on RisingWave and Apache Iceberg combines the freshness of a real-time pipeline with the analytical depth of a traditional data warehouse—without the cost of either a dedicated streaming engine or a commercial warehou...
Join discussion
Mar 13 · 14 min read · 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...
Join discussionJan 31 · 10 min read · Why your "Sales by Region" keeps lying to you If a "simple" KPI like Sales by Region keeps changing every time someone moves house or changes team, that's not your dashboard being flaky. That's your data model telling you it only remembers the latest...
Join discussion
Jan 28 · 7 min read · Introduction The star schema is a data warehouse table design pattern where a single main table contains measurable/ numerical data, and multiple other tables contain descriptive data about the entries in the main table. A fact table is the name give...
Join discussionJan 18 · 25 min read · Module 1: Guide to Core Concepts 1. What is an Operational System (OLTP)? An operational system is the system that supports day-to-day business operations. It handles frequent, real-time transactions such as order entry, payments, inventory updates, ...
Join discussionJan 15 · 4 min read · 🗒 Framed through DLER and MLER for property management operators. Instead of talking about exit or sale, this comparison is framed in terms that matter day to day for operators: DLER and MLER. The question is simple. Which approach gives you clear...
Join discussion
Dec 17, 2025 · 3 min read · 📜 What Is “Storage Wars”? As data volumes grow, organisations face a fundamental question:Where should data live once it’s ingested and prepared? Over time, three major storage architectures have emerged: Data Lakes for raw, large-scale data storag...
Join discussion
Nov 12, 2025 · 5 min read · Let’s be real: hospitals are drowning in data. Patient records. Lab results. Insurance claims. Scans. Wearables. Billing. Each system speaks its own language, and none of them get along. So when a doctor needs to make a fast decision — the data is sc...
Join discussion
Nov 9, 2025 · 1 min read · 개념 OLTP 데이터베이스를 그대로 복제하고 동기화하는 공간이다. OLTP의 최신 데이터로 ODS의 데이터를 계속 덮어쓴다. 반면 DW는 기존재하는 테이블에 계속 레코드를 삽입한다. DW 테이블을 생성하는 원천 데이터베이스가 된다. DW를 위한 임시 영역으로 사용될 수 있다. OLTP 내에서는 여러 원천(i.e., Oracle의 Database 단위 이상)에 물리적으로 흩어져 있는 테이블들을 한데 모으는 의미가 있다. 이를 통해 함께 작...
Join discussion
