Star schemas do not explicitly provide support for attribute
hierarchies. Snowflake schemas provide a refinement of star
522
schemas where the dimensional hierarchy is explicitly
represented by normalizing the dimension tables, as shown in
Figure 4. This leads to advantages in maintaining the
dimension tables. However, the denormalized structure of the
dimensional tables in star schemas may be more appropriate
for browsing the dimensions.