THE ILLUSTRATE OF DATA VAULT MODEL

admin管理员组

文章数量:1130349

  —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

table 1 Hub table schema example

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.

Figure 1 Link table scema example

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.

Figure 2 Satellite table scema example

Figure 3 Satellite table data example

  The Data vault Model as follows:

Figure 4 data vault model example

  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:

Figure 5 adjust data vault model example

  finally，your data warehouse model will become the same as Figure 6,just like a big web.

Figure 6 the finally data vault model                       

References：《Building a Scalable Data Warehouse with Data Vault 2.0》

  —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

table 1 Hub table schema example

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.

Figure 1 Link table scema example

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.

Figure 2 Satellite table scema example

Figure 3 Satellite table data example

  The Data vault Model as follows:

Figure 4 data vault model example

  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:

Figure 5 adjust data vault model example

  finally，your data warehouse model will become the same as Figure 6,just like a big web.

Figure 6 the finally data vault model                       

References：《Building a Scalable Data Warehouse with Data Vault 2.0》

本文标签： DATAillustrateModelVAULT