Data Vault in Business Intelligence
summary
Claims a practical Data Vault deployment that splits sources into hubs links satellites so identification never updates, relationships are many‑to‑many links, and satellites record every change for audit and historization. Reports and star marts get rebuilt from the vault in days; ETL parallelises hub/link/satellite loads and runs on relational engines (SQL Server, Oracle). Presenter reports one project success, notes tradeoffs (more tables, query patterns) and points to LinkedIn, YouTube and Genesis Academy resources.
AI-written summary · about
chapters (6)
- 0:00Start
- 6:59Place of Data Vault in DWH architecture
- 14:31Decomposition example
- 18:44Data Vault structure example
- 19:37How DV contributes to incremental build and agility?
- 21:30Structure Extension Examples
related talks
42mData Modelling: Navigating the Data Seas with a Data Vault Compass
17mDataEngBytes 2023 - SYD-T1-05 - Patrick Cuba
44mAgile Data Warehousing/Business Intelligence: Addressing the Hard Problems
27mThe Evolution of Data Architecture
11mBreaking Data Silos: Enterprise Data Management
51mData tiering using data Virtualization in SQL
23m‘Samen Slimmer met Data’ – A company wide Data Transformation
31mData Warehouses Meet Data Lakes
