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 of time.
To obtain the description of students' information or time dimension, the fact table can be linked to the
dimension table as follows:
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.