Data Vault Modeling
Data vaults have 3 types of entities: Hubs, Links, and Satellites.
Represent core business entities like customers, products, or stores.
Contain the business key and essential fields.
Do not hold contextual or detailed entity information.
Maintain a one-row-per-key constraint, ensuring that each key is associated with only one entry.
Establish relationships between different business entities.
Connect hubs to illustrate associations between entities.
Help capture how entities relate to each other in a structured manner.
Store descriptive attributes related to the business entities in hubs (these can change over time, similar to a Kimball Type II slowly changing dimension).
Contain additional information like timestamps, status flags, or metadata.
Provide context and historical data about the entities over time.