- 了解數據倉庫概念
- 瞭解資料庫和數據建模概念
觀眾
- 數據建模器
- 資料倉庫專家 （Data Warehouse specialist）
- Business 情報專家
- 數據工程師
- Database 管理員
Data Vault 建模是一種資料庫建模技術，可對來自多個來源的數據進行長期歷史存儲。數據保險庫存儲事實的單一版本，或“所有數據，始終”。其靈活、可擴展、一致且適應性強的設計包含了第三範式 （3NF） 和星型模式的最佳方面。
在這個講師指導的現場培訓中，參與者將學習如何構建 Data Vault。
在本次培訓結束時，參與者將能夠：
- 瞭解 Data Vault 2.0 背後的架構和設計概念，以及它與 Big Data、NoSQL 和 AI 的交互。
- 使用數據保險庫技術對數據倉庫中的歷史數據進行審計、跟蹤和檢查。
- 開發一致且可重複的 ETL（提取、轉換、載入）流程。
- 構建和部署高度可擴展且可重複的倉庫。
課程形式
- 部分講座、部分討論、練習和大量動手實踐
介紹
- 現有數據倉庫數據建模架構的缺點
- Data Vault 建模的優勢
Data Vault 架構和設計原則概述
- SEI / CMM / 合規性
Data Vault 應用
- 動態數據倉庫
- 勘探倉儲
- 在-Database Data Mining
- 快速連結外部資訊
Data Vault 元件
- 集線器、鏈接、衛星
構建 Data Vault
對 Hub、Link 和 Satellite 進行建模
Data Vault 參考規則
元件如何相互交互
建模和填充 Data Vault
將 3NF OLTP 轉換為 Data Vault 企業 Data Warehouse （EDW）
瞭解載入日期、結束日期和聯接操作
Business 鍵、關係、鏈接表和聯接技術
查詢技術
載入處理和查詢處理
Matrix 方法概述
將數據導入數據實體
載入 Hub 實體
載入連結實體
載入衛星
使用 SEI/CMM Level 5 範本獲得可重複、可靠和可量化的結果
開發一致且可重複的 ETL（提取、轉換、載入）流程
構建和部署高度可擴展且可重複的倉庫
結束語
United Arab Emirates - Data Vault: Building a Scalable Data Warehouse
Qatar - Data Vault: Building a Scalable Data Warehouse
Egypt - Data Vault: Building a Scalable Data Warehouse
Saudi Arabia - Data Vault: Building a Scalable Data Warehouse
South Africa - Data Vault: Building a Scalable Data Warehouse
Brasil - Data Vault: Building a Scalable Data Warehouse
Canada - Data Vault: Building a Scalable Data Warehouse
香港 - Data Vault: Building a Scalable Data Warehouse
澳門 - Data Vault: Building a Scalable Data Warehouse
台灣 - Data Vault: Building a Scalable Data Warehouse
USA - Data Vault: Building a Scalable Data Warehouse
Österreich - Data Vault: Building a Scalable Data Warehouse
Schweiz - Data Vault: Building a Scalable Data Warehouse
Deutschland - Data Vault: Building a Scalable Data Warehouse
Czech Republic - Data Vault: Building a Scalable Data Warehouse
Denmark - Data Vault: Building a Scalable Data Warehouse
Estonia - Data Vault: Building a Scalable Data Warehouse
Finland - Data Vault: Building a Scalable Data Warehouse
Greece - Data Vault: Building a Scalable Data Warehouse
Magyarország - Data Vault: Building a Scalable Data Warehouse
Ireland - Data Vault: Building a Scalable Data Warehouse
Luxembourg - Data Vault: Building a Scalable Data Warehouse
Latvia - Data Vault: Building a Scalable Data Warehouse
España - Bóveda de Datos: Creación de un Almacén de Datos Escalable
Italia - Data Vault: Building a Scalable Data Warehouse
Lithuania - Data Vault: Building a Scalable Data Warehouse
Nederland - Data Vault: Building a Scalable Data Warehouse
Norway - Data Vault: Building a Scalable Data Warehouse
Portugal - Data Vault: Building a Scalable Data Warehouse
România - Data Vault: Building a Scalable Data Warehouse
Sverige - Data Vault: Building a Scalable Data Warehouse
Türkiye - Data Vault: Building a Scalable Data Warehouse
Malta - Data Vault: Building a Scalable Data Warehouse
Belgique - Data Vault: Building a Scalable Data Warehouse
France - Data Vault: Building a Scalable Data Warehouse
日本 - Data Vault: Building a Scalable Data Warehouse
Australia - Data Vault: Building a Scalable Data Warehouse
Malaysia - Data Vault: Building a Scalable Data Warehouse
New Zealand - Data Vault: Building a Scalable Data Warehouse
Philippines - Data Vault: Building a Scalable Data Warehouse
Singapore - Data Vault: Building a Scalable Data Warehouse
Thailand - Data Vault: Building a Scalable Data Warehouse
Vietnam - Data Vault: Building a Scalable Data Warehouse
India - Data Vault: Building a Scalable Data Warehouse
Argentina - Bóveda de Datos: Creación de un Almacén de Datos Escalable
Chile - Bóveda de Datos: Creación de un Almacén de Datos Escalable
Costa Rica - Bóveda de Datos: Creación de un Almacén de Datos Escalable
Ecuador - Bóveda de Datos: Creación de un Almacén de Datos Escalable
Guatemala - Bóveda de Datos: Creación de un Almacén de Datos Escalable
Colombia - Bóveda de Datos: Creación de un Almacén de Datos Escalable
México - Bóveda de Datos: Creación de un Almacén de Datos Escalable
Panama - Bóveda de Datos: Creación de un Almacén de Datos Escalable
Peru - Bóveda de Datos: Creación de un Almacén de Datos Escalable
Uruguay - Bóveda de Datos: Creación de un Almacén de Datos Escalable
Venezuela - Bóveda de Datos: Creación de un Almacén de Datos Escalable
Polska - Data Vault: Building a Scalable Data Warehouse
United Kingdom - Data Vault: Building a Scalable Data Warehouse
South Korea - Data Vault: Building a Scalable Data Warehouse
Pakistan - Data Vault: Building a Scalable Data Warehouse
Sri Lanka - Data Vault: Building a Scalable Data Warehouse
Bulgaria - Data Vault: Building a Scalable Data Warehouse
Bolivia - Bóveda de Datos: Creación de un Almacén de Datos Escalable
Indonesia - Data Vault: Building a Scalable Data Warehouse
Kazakhstan - Data Vault: Building a Scalable Data Warehouse
Moldova - Data Vault: Building a Scalable Data Warehouse
Morocco - Data Vault: Building a Scalable Data Warehouse
Tunisia - Data Vault: Building a Scalable Data Warehouse
Kuwait - Data Vault: Building a Scalable Data Warehouse
Oman - Data Vault: Building a Scalable Data Warehouse
Slovakia - Data Vault: Building a Scalable Data Warehouse
Kenya - Data Vault: Building a Scalable Data Warehouse
Nigeria - Data Vault: Building a Scalable Data Warehouse
Botswana - Data Vault: Building a Scalable Data Warehouse
Slovenia - Data Vault: Building a Scalable Data Warehouse
Croatia - Data Vault: Building a Scalable Data Warehouse
Serbia - Data Vault: Building a Scalable Data Warehouse
Bhutan - Data Vault: Building a Scalable Data Warehouse