Home▸Physics & Mechanics▸Star Schema Design Lab

🗄️ Star Schema Design Lab

A 3D star schema diagram: a central fact table surrounded by dimension tables, with adjustable grain, dimension count and SCD type.

Physics & Mechanics3DAdvanced60 FPS

A central fact table wired to a ring of dimension tables in a 3D star schema, letting you change the fact table's grain, add or remove dimensions, and watch a customer dimension reshape itself under each type of slowly changing dimension.

🔬 What It Demonstrates

Grain controls how many facts exist per business event; every dimension attaches to the fact table through a single foreign key; and SCD Type 1/2/3 trade off history for storage in visibly different ways.

🎮 How to Use

Pick a fact grain, drag the dimension-count slider, and switch the customer dimension between SCD types. Click "Run join query" to watch a query pulse travel from every dimension into the fact table.

💡 Did You Know?

Because every dimension joins to the fact table directly rather than through other dimensions, a star schema query never needs more than one hop per dimension — which is exactly why it's fast for BI tools.

⚙ Under the hood

A 3D star schema diagram: a central fact table surrounded by dimension tables, with adjustable grain, dimension count and SCD type.

star-schemadata-modelingdatabaserelational-databasesdimensionalitygrainThree.js

3D · Three.js / WebGL renderer · 60 FPS target · runs fully client-side, no install