Second Brain

Home

❯

Modern Data Infrastructure

❯

Data warehouse

Data warehouse

Apr 26, 20261 min read

  • Dimensional Modeling
    • Star Schema
    • Snowflake Schema
    • Fact Constellation (Galaxy Schema)
  • Fact Table Design
    • Transaction Fact
    • Snapshot Fact
    • Accumulating Snapshot Fact
  • Dimension Modeling
    • Slowly Changing Dimensions (SCD)
    • Conformed Dimensions
    • Junk Dimensions
  • Kimball Methodology

Graph View

Backlinks

  • Data Modeling
  • OLAP vs OLTP

Created with Quartz v4.5.2 © 2026

  • GitHub
  • HuggingFace
  • LinkedIn