Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
Physical Implementation Dimensional Modeling also called Star Schema ever insult an alligator until after you have crossed the river." African Proverb Never insult a modeler until after you have the ERWin diagram in hand. Never insult the DBA especially until you have received your privileges or you could get a real death role! Many believe that a normalized model is best while others argue that dimensional models are better. A combination of both is an excellent strategy. Dimensional Modeling was originally designed for retail supermarket applications because their systems did not have the performance to perform joins, full table scans, aggregations, and sorting. Dimensional Modeling often implements fewer tables and can be adapted to enhance performance. This is because dimensional modeling was designed around answering specific questions.