Snowflake Schema

GPTKB entity

Statements (18)
Predicate Object
gptkbp:instanceOf Database Schema
gptkbp:advantage Complex Queries
More Joins Required
Reduces Data Redundancy
gptkbp:characterizedBy Normalized Tables
gptkbp:contrastsWith gptkb:Star_Schema
gptkbp:example Dimensional Modeling
gptkbp:feature Hierarchical Structure
Multiple Related Dimension Tables
https://www.w3.org/2000/01/rdf-schema#label Snowflake Schema
gptkbp:originatedIn 1990s
gptkbp:purpose Organize Data for Querying
gptkbp:relatedTo Dimension Table
Fact Table
gptkbp:usedBy Business Intelligence Tools
gptkbp:usedIn Data Warehousing
gptkbp:bfsParent gptkb:Enterprise_Data_Warehouse
gptkbp:bfsLayer 7