Data Vault 2.0
Full support for the Data Vault 2.0 methodology.
Core components
- Hubs — business keys and surrogate keys
- Links — relationships between business concepts
- Satellites — descriptive attributes with full history
Advanced patterns
- Effectivity Satellites for relationship tracking
- Point-in-Time (PIT) tables for query performance
- Bridge tables for complex relationships
- Multi-active Satellites for multiple concurrent records
Business Vault
Apply business rules on top of Raw Vault.
- Calculated fields and derived attributes
- Business-friendly naming conventions
- Conformance and standardization rules
- Same-as Links for master data management
Dimensional Modeling
Classic star and snowflake schemas for reporting.
- Fact tables with measures
- Dimension tables with hierarchies
- Slowly Changing Dimensions (SCD Type 1, 2, 3)
- Conformed dimensions across subject areas
Third Normal Form (3NF)
Traditional normalized modeling when required.
- Entity-relationship modeling
- Referential integrity
- Normalization rules enforcement