DEV Community

Cover image for Data warehouse schema design - dimensional modeling and star schema
Snir David
Snir David

Posted on • Edited on • Originally published at snir.dev

9 7

Data warehouse schema design - dimensional modeling and star schema

Original post for Data warehouse schema design - dimensional modeling and star schema in my blog

Introduction to data warehouse schema design: In this talk, I walk through the basics of dimensional design using the kimball group approach.

Amongst other things, I cover:

  • OLAP systems vs OLTP systems
  • Third normal form of operational DB
  • What is a dimension
  • What is a fact
  • Star schema
  • Dimension grain
  • Surrogate keys
  • Slowly changing dimensions

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay