The Data Vault Handbook - Concepts and Applications

valid for a given business key, preserving the full context of multiple active entries at any point in time.

MULTI-ACTIVE SATELLITE EXAMPLE

In a hospital setting, patients can often be enrolled in multiple medical treat- ments at the same time. A Multi-Active Satellite is well-suited to capture these multiple records per patient, allowing us to store information about each treatment uniquely. In this case, the Patient Hub serves as the parent key, and each treatment is stored with its own sequence number to differ- entiate it. In this example, patient “d4af83d...” is enrolled in three treatments at the same time. If any details about one of the treatments change, the entire block (all three rows) will be reinserted with a new Hash Diff calculation. Similarly, patient “e8ba92f...” is participating in two concurrent treatments, and the same behavior applies.