• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Star Schema vs. Snowflake Schema

DaShen

Lifer
Which do you prefer.

For personal databases, I think normalizing to simpliest form 3NF and 4NF is preferable.

But it seems...

Star Schema is just too easy to use in programming data warehousing terms to not use in big projects. But redundancy is so painfully annoying coming from a stickler for clean data and programming.
 
Originally posted by: FrankyJunior
I prefer the Asteroid Schema myself.

Rusty Griswold: Ya' got Space Invaders?
Cousin Dale: Nope.
Rusty Griswold: Ya' got Asteroids?
Cousin Dale: Naw, but my dad does. Can't even sit on the toilet some days.

🙂
 
Back
Top