Data engineering·Modelling for analysis
the raw layer is split into keys, relationships and attributes as three kinds of table, and nothing is ever updated or deleted.
Data vault
Also calleddata vault 2.0, hubs links and satellites
A modelling approach that separates business keys, the relationships between them and their descriptive attributes into hubs, links and satellites, all insert-only. It is built for auditability and for absorbing source change without refactoring: a new source adds satellites rather than altering existing tables. Nobody queries it directly — the table count is enormous — so it is always a raw layer with dimensional marts built on top, and adopting it without that second layer is the usual failure.