Star schema is the most commonly used way of dimension modeling. The star pattern centers on the fact table, and all dimension tables are directly connected to the fact table, just like a star. The dimension modeling of star schema consists of a fact table and a group of dimension tables, which have the following characteristics: a. Dimension tables are only associated with fact tables, but there is no association between them; B, the primary key of each dimension table is a single column, and the primary key is placed in the fact table as a foreign key connected on both sides; C, taking the fact table as the core, and the dimension table is distributed in a star shape around the core;
Snowflake mode is an extension of star mode. The dimension table of snowflake mode can have other dimension tables. Although this model is more standardized than the star model, it is not easy to understand, the maintenance cost is high, and the performance needs to associate multi-layer dimension tables, which is lower than the star model. So it is generally not very common.