loading...
Cover image for Data warehouse schema design - dimensional modeling and star schema

Data warehouse schema design - dimensional modeling and star schema

snird profile image Snir David Updated on ・1 min read

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

Discussion

pic
Editor guide