Jump to content

Fact constellation

From Wikipedia, the free encyclopedia

This is the current revision of this page, as edited by Me, Myself, and I are Here (talk | contribs) at 08:04, 4 June 2024 (→‎See also: RM item linked in body). The present address (URL) is a permanent link to this version.

(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

Fact constellation is a measure of online analytical processing, which is a collection of multiple fact tables sharing dimension tables, viewed as a collection of stars.[1] It can be seen as an extension of the star schema.

A fact constellation schema has multiple fact tables. It is also known as galaxy schema. 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

[edit]


Stub icon

This database-related article is a stub. You can help Wikipedia by expanding it.

References

[edit]
  1. ^ "Data Warehouse Schema Architecture - fact constellation schema".
Retrieved from "https://en.wikipedia.org/w/index.php?title=Fact_constellation&oldid=1227189322"