Building a Scalable Data Warehouse with Data Vault 2.0 (Paperback)

Dan Linstedt, Michael Olschimke

  • 出版商: Morgan Kaufmann
  • 出版日期: 2015-09-29
  • 售價: $2,530
  • 貴賓價: 9.5$2,404
  • 語言: 英文
  • 頁數: 684
  • 裝訂: Paperback
  • ISBN: 0128025107
  • ISBN-13: 9780128025109
  • 相關分類: JVM 語言
  • 海外代購書籍(需單獨結帳)



The Data Vault was invented by Dan Linstedt at the U.S. Department of Defense, and the standard has been successfully applied to data warehousing projects at organizations of different sizes, from small to large-size corporations. Due to its simplified design, which is adapted from nature, the Data Vault 2.0 standard helps prevent typical data warehousing failures.

"Building a Scalable Data Warehouse" covers everything one needs to know to create a scalable data warehouse end to end, including a presentation of the Data Vault modeling technique, which provides the foundations to create a technical data warehouse layer. The book discusses how to build the data warehouse incrementally using the agile Data Vault 2.0 methodology. In addition, readers will learn how to create the input layer (the stage layer) and the presentation layer (data mart) of the Data Vault 2.0 architecture including implementation best practices. Drawing upon years of practical experience and using numerous examples and an easy to understand framework, Dan Linstedt and Michael Olschimke discuss:




  • How to load each layer using SQL Server Integration Services (SSIS), including automation of the Data Vault loading processes.
  • Important data warehouse technologies and practices.
  • Data Quality Services (DQS) and Master Data Services (MDS) in the context of the Data Vault architecture.
  • Provides a complete introduction to data warehousing, applications, and the business context so readers can get-up and running fast
  • Explains theoretical concepts and provides hands-on instruction on how to build and implement a data warehouse
  • Demystifies data vault modeling with beginning, intermediate, and advanced techniques
  • Discusses the advantages of the data vault approach over other techniques, also including the latest updates to Data Vault 2.0 and multiple improvements to Data Vault 1.0


《建立可擴展的資料倉儲》一書涵蓋了創建可擴展資料倉儲所需的一切,包括介紹了資料倉儲建模技術Data Vault,該技術提供了創建技術資料倉儲層的基礎。該書討論了如何使用敏捷的Data Vault 2.0方法逐步建立資料倉儲。此外,讀者還將學習如何創建Data Vault 2.0架構的輸入層(階段層)和展示層(資料集市),包括實施最佳實踐。Dan Linstedt和Michael Olschimke根據多年的實踐經驗,使用眾多例子和易於理解的框架討論了以下內容:

- 如何使用SQL Server Integration Services(SSIS)加載每個層,包括自動化Data Vault加載過程。
- 重要的資料倉儲技術和實踐。
- 在Data Vault架構中使用資料品質服務(DQS)和主資料服務(MDS)。

此外,該書還提供了對資料倉儲、應用和業務背景的完整介紹,讓讀者能夠快速上手。它解釋了理論概念並提供了實踐指導,教讀者如何建立和實施資料倉儲。它還揭示了資料倉儲方法相對於其他技術的優勢,包括Data Vault 2.0的最新更新和對Data Vault 1.0的多項改進。