snowflake schema

GPTKB entity

Statements (16)
Predicate Object
gptkbp:instanceOf database schema
gptkbp:advantage more complex queries
reduces data redundancy
slower query performance compared to star schema
gptkbp:characterizedBy normalized tables
gptkbp:contrastsWith star schema
gptkbp:feature dimension tables are normalized
fact table at the center
multiple related dimension tables
https://www.w3.org/2000/01/rdf-schema#label snowflake schema
gptkbp:originatedIn data warehouse design
gptkbp:purpose organize data for analytical queries
gptkbp:usedIn data warehousing
gptkbp:bfsParent gptkb:TPC-DS
gptkb:OLAP_databases
gptkbp:bfsLayer 7