Types Database Schemas

I am going discusses two types of schema here, Start Schema and Snowflake Schema

Start Schema

          A single Fact table surrendered by multiple Dimension table is called Start Schema. It doesn’t capture hierarchy directly

Benefits of Start Schema

·         Performance (Integer relationships, natural partitioning, Single joins benefit SQL optimizer)

·         Source system independence and multiple integration

·         Supports Change management

·         Usability/Simplicity (easy to read, interpret, join, calculate)

·         Presentation (Consistency, Taxonomy, Labeling)

·         Reuse (Conformed dimensions reduce redundancy, Role-plays)

Snowflake Schema

            It represents the dimension hierarchy directly by normalizing tables