Fact constellation
{{Short description|Database schema}}{{More citations needed|date=November 2024}}
A fact constellation schema, also referred to as a galaxy schema, is a model using multiple fact tables and multiple dimension tables.{{Cite journal |last1=Turcan |first1=G. |last2=Peker |first2=S. |date=2022 |title=A multidimensional data warehouse design to combat the health pandemics |journal=Journal of Data, Information and Management |volume=4 |issue=3–4 |pages=371–386 |doi=10.1007/s42488-022-00082-6|pmc=9763078 }} 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.