Home▸Physics & Mechanics▸Star Schema Design Lab (2D)

Star Schema Design Lab (2D)

A flat-diagram companion to the 3D star schema lab: a central fact table wired by spokes to a ring of dimension tables, with adjustable grain, dimension count and customer SCD type.

Physics & Mechanics2DModerate60 FPS📱 Mobile-adapted⇄ 3D version

This 2D companion draws the same star schema as the 3D version on a flat canvas: a central fact table with a scatter of rows, spokes to each dimension table, and a customer-dimension badge that reshapes to show SCD Type 1, 2 or 3. Click "Run join query" to send a pulse from every dimension into the fact table.

⚙ Under the hood

2D Canvas star schema diagram with adjustable fact grain, dimension count and customer SCD type, driven by the same grain/dimension logic as the 3D lab.

star schemadata modelingdatabasedimensionalitygrain

2D · HTML5 Canvas 2D · 60 FPS target · runs fully client-side, no install