Fact constellation

A fact constellation schema, also referred to as a galaxy schema, is a model using multiple fact tables and multiple dimension tables.

Uses your system voice; voice and rate in settings.

Snapshot

≈ 1 min read

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

A fact constellation schema, also referred to as a galaxy schema, is a model using multiple fact tables and multiple dimension tables. These schemas are implemented for complex data warehouses. The fact constellation is a measure of online analytical processing and can be seen as an extension of the star schema.

A fact constellation schema has multiple fact tables. It is a widely used schema and more complex than star schemas and snowflake schemas. It is possible to create a fact constellation schema by splitting the original star schema into more star schemas.

It has many fact tables and some common dimension tables.

See also

Online analytical processing Snowflake schema

Text derived from https://en.wikipedia.org/w/index.php?oldid=1283688199 under CC BY-SA 4.0; modifications have been made.

Sources cited in this revision

No external citation was extracted for this revision. That is a statement about the source, not a claim that none exists.