Snowflake schema is refinement of star schema where some dimensional hierarchy is further splitting (normalized) into a set of smaller dimension tables
(Fig 7), forming a shape similar to snowflake.
Assets and liabilities statement analysis star schema mainly includes: fact table of assets and liabilities statement (including accounting time, assets and liabilities index code, opening amount, closing amount, changes, change ratio, etc.), dimension table
of assets and liabilities statement (including index code, index name, etc.), dimension table
To obtain the description of students' information or time dimension, the fact table can be linked to the dimension table
After defining the fact tables, dimension tables
and sub dimension tables
, they are designed and the relationships between them are established.
You should redundantly model any dimensional contact fields such as state or area code in a separate dimension table
. This preserves dimensional query performance and avoids the difficult task of tracking address history (at least in the warehouse).
If users and users' query complexity is considered, a way should be found to place version numbers by grouping within a dimension table
, allowing any recursion to be performed against the dimension.
Key words: fact table, dimension table
, star schema, star join, SQL query, multi-column index, and cardinality.