32 w ·Translate

When updating reporting solutions or building an enterprise data warehouse, the goal is to optimize information organization. To do this you will need to develop a data model. While the relational model is a commonly used solution, the lesser known data vault model may provide a better result for information organization. Data Vault is a hybrid solution that combines data normalization and dimensional modeling.

Data Vault provides flexibility for change by separating out business keys that uniquely identify each business entity and do not mutate, and the associations between them and their attributes. The business keys are stored in tables called Hubs.
Relationships between business keys (Hubs) are also stored in tables and are called Links.
The attributes are stored in one or multiple tables called Satellites.
https://proskale.com/building-....data-vault-on-synaps

image