Snowflake Schema
A snowflake schema is a dimensional data modeling technique that normalizes dimension tables of a star schema into multiple related sub-tables, reducing data redundancy at the cost of additional joins.
4 resources across 2 libraries
Glossary Terms(3)
Data Mart
A data mart is a focused, subject-oriented subset of a data warehouse, scoped to the needs of a single business function or department such as sales, finance,…
Star Schema
A star schema is a dimensional data modeling technique in which a central fact table, holding measurable business events, is directly connected to multiple den…
Snowflake Schema
A snowflake schema is a dimensional data modeling technique that normalizes dimension tables of a star schema into multiple related sub-tables, reducing data r…