What Is Data Vault 1.0?
Data Vault 1.0 (DV1) is highly focused on the data vault modeling components and
relational database technology. A DV1 data model attaches surrogate sequence keys as
its primary key selection for each of the entity types. Unfortunately, surrogate sequences
exhibit the following problems:
- Introduce dependencies on the ETL/ELT loading paradigm
- Contain an upper bound/upper limit, when reached can cause issues
- Are meaningless numbers (mean absolutely nothing to the business)
- Cause performance problems (due to dependencies) on load of big data sets
- Reduce parallelism (again due to dependencies) of loading processes
- Cannot be utilized as MPP partition keys for data placement, to do so would potentially cause hot
spots in the MPP platform - Cannot be reliably rebuilt or reassigned (reattached to old values) during recovery loads
- Are disparate across multiple source applications that are housing the same data sets
Chapter 6.1: Introduction to Data Vault 2.0