Data Vault

This is one method in which a database or data warehouse can be designed. Data sourced from different operational systems is stored in such a way that it can be completely traced in term of history. In the data vault architecture you can have three basic entities: hub, link and satellite.

A hub consists of a unique list of business keys. These hubs can be joined with several satellites that contain more detailed information about the hub and its keys. All the different hubs can then be connected with the help of the links. A link stores the single unique association between the business keys of the connecting hubs.