top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

what is galaxy schema in context of dataware housing?

+7 votes
900 views
what is galaxy schema in context of dataware housing?
posted Dec 16, 2013 by Neeraj Pandey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
Galaxy schema is also known as fact constellation scheme. It requires no of fact tables to share dimension tables.
Credit: http://www.globalguideline.com/interview_questions/Answer.php?a=What_is_galaxy_schema

1 Answer

0 votes

Star schema: A fact table in the middle connected to a set of dimension tables

Snowflake schema: A refinement of star schema where some dimensional hierarchy is normalized into a set of smaller dimension tables, forming a shape similar to snowflake

Galaxy Schema (Fact constellations): Multiple fact tables share dimension tables, viewed as a collection of stars, therefore called galaxy schema or fact constellation

answer Dec 16, 2013 by Anderson
...