Fact constellation

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


References
  1. "Data Warehouse Schema Architecture - fact constellation schema".
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.