Tag: Data Modeling
All the articles with the tag "Data Modeling".
-
Modeling a patient roster as a FHIR Group (Da Vinci ATR)
Map a roster CSV to FHIR Group, Patient and Coverage using the Da Vinci ATR profile — with a Python converter and namespaced identifiers.
-
Designing Event Schemas for Product Analytics in ClickHouse
Fixed columns vs Map vs JSON, ORDER BY for funnels, dedup, TTL and materialized views: a practical event schema for product analytics in ClickHouse.
-
Understanding Slowly Changing Dimensions (SCD) in Data Warehousing
When dealing with data warehouses, handling changes in dimension data over time is crucial. Unlike operational databases where updates are straightforward, data warehouses require preserving
-
Understanding Surrogate Keys in Databases
When designing relational databases, one crucial decision is how to uniquely identify each record in a table. This is where surrogate keys come into play. Unlike natural keys, which derive from