Misplaced Pages

Fact constellation

Article snapshot taken from Wikipedia with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.
(Redirected from Fact constellation schema) Database schema
This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.
Find sources: "Fact constellation" – news · newspapers · books · scholar · JSTOR (November 2024) (Learn how and when to remove this message)

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

References

  1. ^ Turcan, G.; Peker, S. (2022). "A multidimensional data warehouse design to combat the health pandemics". Journal of Data, Information and Management. 4: 371–386. doi:10.1007/s42488-022-00082-6.
Stub icon

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

Categories: