Star Schema

  • Simple query, usually less joins, might be faster than others.
  • Data intergrity is not enforced.
  • Fast loading but slow data checking/validating.
  • Efficient navigation through data.
  • Mapping OLTP schema to it might be more difficult.
  • More space to storage the data, because of de-normalisation.
  • Not flexible for analysis needs.

Snow Flakes

  • Easy to update(create) and maintain.
  • Data quality might be better.
  • Less storage required than Star Schema.
  • More complex queries, more joins.
  • Schema is easier to map from OLTP schema.
  • Loading time is slow but checking is fast.
  • Not flexible for analysis needs.

Fact Constellation

  • Multi fact tables, flexible for analysis needs.
  • More complex structure.
  • Difficult to maintain or to approach.
  • Slow loading but checking time depends on the dimension tables’ normalization.
  • Usually more space used.



Programmer, Geeker, Writer

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store