Over the last 20 years a number of patterns have emerged for dealing with the data layers in a centralised data repository.
These have typically been attributed to the person who has championed this model, people such as Bill Inmon and Ralph Kimball.
These patterns give us a starting point for defining the data layers in our organisation. While we may not adopt them in their entirety they give us a starting point from which we can adapt.
The Inmon Pattern
[[3rd normal from integration layer]]
The Kimbal Pattern
[[stars for thars, stars in both integration and presentation]]
The Data Vault Pattern
[[ralph Hughes hyper normalsied]]
The Data Lake pattern