—The article is based on 《Building a Scalable Data Warehouse with Data Vault 2.0》,If you want this e-book, please leave a message to me,Best Regards!
The Data Vault model is based on three basic entity types,these entity types are hubs, links,and satellites. Each entity type serves a specific purpose: the hub separates the business keys from therest of the model; the link stores relationships between business keys (and/or hubs); and satellites store the context (the attributes of a business key or relationship).
Hub Entities
The purpose of a hub entity is to store the business keys of business objects along with some other information, which is called the metadata.
HubAirline |
---|
AirlineHashKey(PK) |
LoadDate |
RecordSource |
AirlineID(business key) |
refeshdate |
Link Entities
The Data Vault models these relationships with links that connect two or more hubs.Typical business processes are purchasing, manufacturing, advertising, marketing, and sales. Because these processes often (but not always) represent transactions, a link often represents a transaction as well.Therefore, it often provides the basis for creating the facts of the dimensional model.
Satellite Entities
Satellites add this functionality to the Data Vault model. They store the attributes that belong to either a business key (in a hub), relationship or a transaction (in a link).The satellite also stores the history of the attribute data. Every attribute change is logged to the satellite.
The Data vault Model as follows:
If the business decides to add information about the plane, the Data Vault gets a new hub and the hub is linked to the existing Data Vault with a new set of links as follows:
finally,your data warehouse model will become the same as Figure 6,just like a big web.