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)

nextjs tutorial video

Youtube Tutorial Series 📺

So you built a Next.js app, but you need a clear view of the entire operation flow to be able to identify performance bottlenecks before you launch. But how do you get started? Get the essentials on tracing for Next.js from @nikolovlazar in this video series 👀

Watch the Youtube series