Snowflake schema

id: snowflake-schema-235-3053699
title: Snowflake schema
text: In computing, a snowflake schema or snowflake model is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake shape. The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions. "Snowflaking" is a method of normalizing the dimension tables in a star schema. When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact
brand slug: wiki
category slug: encyclopedia
description: A logical arrangement of computing tables in a multidimensional database
original url: https://en.wikipedia.org/wiki/Snowflake_schema
date created:
date modified: 2024-03-27T13:32:05Z
main entity: {"identifier":"Q1345076","url":"https://www.wikidata.org/entity/Q1345076"}
image: {"content_url":"https://upload.wikimedia.org/wikipedia/commons/b/b2/Snowflake-schema.png","width":1459,"height":881}
fields total: 13
integrity: 15

Related Entries

Explore Next Part