CODEWITHSUNDEEP
data-modelingdata-warehousestar-schemasnowflake-schema
Enrique Benito Casado
Enrique Benito Casado

Reputation: 2080

DWH not a Star-Schema not a Snow flake not a E-R

I m aware aboud litterature/Theorie for datawarehouse-architecture and how should be design. The Bill-Imon E-R 3NF or the Kimball Star-Schema/Snow - flake Schema.

The problem come when i currently work in a DWH and it have no either any of these Schema, it is composed for 3 big Fact Tables around each of them are a lot of dimension Tables.(2 of 3 big Tables are conected) enter image description here

So what kind of Schema its that ?

Thanks in Advance , Enrique

Upvotes: 0

Views: 179

Answers (2)

Wes H
Wes H

Reputation: 4439

If you were viewing the schema for a specific event (fact), you'd be looking at a star schema.

In the diagram you provided, you've pulled back to a larger view and can see multiple star schemas as well as how the events can be related. This can be considered a constellation (collection of related stars, possibly a single module of a larger solution) or a galaxy (all of the star schemas in a solution, even if there is no relation between the stars).

However, I'd still describe your solution as using a star schema as the design pattern conversation normally refers to the event level, and the star pattern implies constellation/galaxy at a higher level.

Upvotes: 2

tobi6
tobi6

Reputation: 8239

This is called a galaxy schema.

Upvotes: 1

Related Questions