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