Bi-kipedia
Star schemas
Two "dimensional modeling” techniques are generally used for modeling the data structures within a data warehouse context.These are the "star schema” and "snowflake schema” techniques. Both find their roots within the Kimball dimensional modeling techniques.A star schema is the preferred technique within the Kimball approach.Properties of star schemas :are easier to navigateimproves query performanceeases the "browsing” of dimensionsismore widely used andthe dimensions are fully de-normalized.