course prep arena ask shorts stories you ?

0 / 100 xp → junior

~course prep arena ask shorts stories you

Loading page…

~/himanshutty1

~/himanshu$cd ~/next-page

[ok]resolve route

[..]stream page

Loading page…

~/sdmtty1

~/sdm$cd ~/next-page

[ok]resolve route

[..]stream page

lecture · 17:24 · 5 checkpoints · browser voiceAdvanced

Data modeling: designing for queries

How to model data so analytics stays fast over billions of rows: OLTP against OLAP, the star schema with facts, dimensions and grain, slowly changing dimensions and point-in-time accuracy, columnar formats, partitioning and Z-ordering, rollups and materialized views, the ETL load order, and the classic modeling mistakes.

Read the lesson: Data Modeling for Analytics→

01 · Previously

W08 · DAY 03 · Data Modeling for Analytics

Where do the numbers live?

Previously: stream and batch

Previously, on Day 2, you chose between streaming and batch.

~/systemdesignmastery.dev

0:00 / 17:24Previously

chapters1/31

checkpoints 0/5 right · +10 XP each

space play · ←/→ step · J/L 10 s · C captions · M music · F full screen · < > speed · S snip

up nextLate data: when real-time isn't real-time→autoplay next

← read the lesson: Data Modeling for Analytics all lectures