Data Vault and Dimensional Modelling
The Data Vault modelled layer is normally used to store data. It is not optimized for query performance, nor is it easy to query by the well known query-tools such as Cognos, SAP Business Objects, Pentaho et al. Since these end-user computing tools expect or prefer their data to be contained in a dimensional model, a conversion is usually necessary.
For this purpose, the Hubs and related Satellites on those Hubs can be considered as Dimensions and the Links and related Satellites on those Links can be viewed as Fact tables in a dimensional model. This enables you to quickly prototype a dimensional model out of a Data Vault model using views. For performance reasons the dimensional model will usually be implemented in relational tables, after approval.
Note that while it is relatively straightforward to move data from a Data Vault model to a (cleansed) dimensional model, the reverse is not as easy.
Read more about this topic: Data Vault Modeling
Famous quotes containing the words data, vault, dimensional and/or modelling:
“This city is neither a jungle nor the moon.... In long shot: a cosmic smudge, a conglomerate of bleeding energies. Close up, it is a fairly legible printed circuit, a transistorized labyrinth of beastly tracks, a data bank for asthmatic voice-prints.”
—Susan Sontag (b. 1933)
“Heaven froze above, severe; the clouds congeal,
And through the crystal vault appeared the standing hail.”
—Geoffrey Chaucer (1340?–1400)
“I don’t see black people as victims even though we are exploited. Victims are flat, one- dimensional characters, someone rolled over by a steamroller so you have a cardboard person. We are far more resilient and more rounded than that. I will go on showing there’s more to us than our being victimized. Victims are dead.”
—Kristin Hunter (b. 1931)
“The windy springs and the blazing summers, one after another, had enriched and mellowed that flat tableland; all the human effort that had gone into it was coming back in long, sweeping lines of fertility. The changes seemed beautiful and harmonious to me; it was like watching the growth of a great man or of a great idea. I recognized every tree and sandbank and rugged draw. I found that I remembered the conformation of the land as one remembers the modelling of human faces.”
—Willa Cather (1873–1947)