Other Architectures

• snowflake schema:dimension tables do not contain denormalized data Fig.33.3(32.2)

• allow dimensions to have dimensions

• starflake schema:a hybrid structure that contains a mixture of star and snowflake schemas

• Advantages of those schemas: pp.1230(1185)