User Tools

Site Tools


design:data-vault

Data Vault

The Data Vault Modeling is a combination of the relational database modeling with the third normal form (3NF) and the dimensional database modeling with the star schema.1) It was developed in 1990 by Daniel Linstedt and was first published in 2000. Since this time the Data Vault modeling technique was enhanced and described in the “Data Vault Series” and new results being published in the “Data Administration Letter”.2) In Data Vault Modeling, there are three basic entities:hubs, links and satellites.3) The structure of the tables are formed like relational database schemas. Compared to dimensional modeling, links can be considered as fact tables. Special links, for example aggregated links, are comparable to aggregated fact tables.4) By using the Data Vault modeling technique, it is possible to build an effective database because the data warehouse can be designed very flexible, agile, traceable and fully historized.5)

All Articles in This Category

<nspages design:data-vault -h1 -textPages=“” -exclude:start >

1) , 5)
Hultgren, Hans. Modeling the Agile Data Warehouse with Data Vault. Brighton Hamilton, 2012. S. 20. Print.
2)
Linstedt, Dan. “Data Vault Series.” The Data Administration newsletter. N.p., 01 Juli 2002. Web. 27 Mar 2013.
3)
Linstedt, Dan. Super Charge your Data Warehouse. Dan Linstedt, 2011. S. 7. Print.
4)
Linstedt, Dan. Super Charge your Data Warehouse. Dan Linstedt, 2011. S. 71. Print.
design/data-vault.txt · Last modified: 2020/08/20 13:27 (external edit)