• Building a Scalable Data Warehouse with Data Vault 2.0 (Paperback / softback) 9780128025109
1 1
£38.39 GBP
£54.99 GBP £38.39 GBP
Sale Sold out
Free UK Shipping

Freshly Printed - allow 10 days lead

Building a Scalable Data Warehouse with Data Vault 2.0

This book covers everything users need to create a scalable data warehouse from scratch, including a presentation of the Data Vault modeling technique which provides the foundations to create a technical data warehouse layer, also including tactics on how to create the inner and presentation layer of the data vault 2.0 standard.

Daniel Linstedt (Author), Michael Olschimke (Author)

9780128025109

Paperback / softback, published 5 October 2015

688 pages
23.4 x 19 x 4.2 cm, 0.95 kg

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.

Chapter 1. Introduction to Data WarehousingChapter 2. Scalable Data Warehouse ArchitectureChapter 3. The Data Vault 2.0 MethodologyChapter 4. Data Vault 2.0 ModelingChapter 5. Intermediate Data Vault ModelingChapter 6. Advanced Data Vault ModelingChapter 7. Dimensional ModelingChapter 8. Physical Data Warehouse DesignChapter 9. Master Data Managment Chapter 10. Metadata Managment Chapter 11. Data ExtractionChapter 12. Loading the Data Vault Chapter 13. Implementing Data Quality Chapter 14. Loading the Dimensional Information MartChapter 15. Multidemensional Database

Subject Areas: Databases [UN], Information technology: general issues [UB], Library, archive & information management [GLC]
View full details