Building a Scalable Data Warehouse with Data Vault 2.0
eBook - ePub

Building a Scalable Data Warehouse with Data Vault 2.0

  1. 684 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Building a Scalable Data Warehouse with Data Vault 2.0

About this book

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

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Building a Scalable Data Warehouse with Data Vault 2.0 by Daniel Linstedt,Michael Olschimke in PDF and/or ePUB format, as well as other popular books in Computer Science & Computer Science General. We have over one million books available in our catalogue for you to explore.

Table of contents

  1. Cover
  2. Title page
  3. Table of Contents
  4. Copyright
  5. Authors Biography
  6. Foreword
  7. Preface
  8. Acknowledgments
  9. Chapter 1: Introduction to Data Warehousing
  10. Chapter 2: Scalable Data Warehouse Architecture
  11. Chapter 3: The Data Vault 2.0 Methodology
  12. Chapter 4: Data Vault 2.0 Modeling
  13. Chapter 5: Intermediate Data Vault Modeling
  14. Chapter 6: Advanced Data Vault Modeling
  15. Chapter 7: Dimensional Modeling
  16. Chapter 8: Physical Data Warehouse Design
  17. Chapter 9: Master Data Management
  18. Chapter 10: Metadata Management
  19. Chapter 11: Data Extraction
  20. Chapter 12: Loading the Data Vault
  21. Chapter 13: Implementing Data Quality
  22. Chapter 14: Loading the Dimensional Information Mart
  23. Chapter 15: Multidimensional Database
  24. Subject Index