Topic
Data Vault Modeling
Hubs, links, satellites, the data vault philosophy, and when the vault is the right model for an integration-heavy warehouse.
6 entries
Glossary
5
Glossary
Business key
The natural, source-independent identifier by which the business recognizes an entity — the value a data vault hub is built around, as opposed to a system-generated surrogate key.
Read →Glossary
Hub
In data vault modeling, a table holding the unique list of business keys for a core business entity — each with a surrogate key, a load timestamp, and a record source — and nothing descriptive.
Read →Glossary
Link
In data vault modeling, a table that records a relationship, transaction, or association among two or more hubs by carrying their surrogate keys together, with no descriptive attributes of its own.
Read →Glossary
Point-in-time table
A query-assistance table in a data vault that precomputes, for a hub, which satellite versions were active at each snapshot date — collapsing multi-satellite, as-of joins into a single lookup.
Read →Glossary
Satellite
In data vault modeling, a table holding the descriptive, time-variant attributes of a hub or link, tracking every change over time with load timestamps so the complete history is preserved.
Read →