Title page
by Daniel Linstedt, Michael Olschimke
Building a Scalable Data Warehouse with Data Vault 2.0
- Cover
- Title page
- Table of Contents
- Copyright
- Authors Biography
- Foreword
- Preface
- Acknowledgments
- Chapter 1: Introduction to Data Warehousing
- Chapter 2: Scalable Data Warehouse Architecture
- Chapter 3: The Data Vault 2.0 Methodology
- Chapter 4: Data Vault 2.0 Modeling
- Chapter 5: Intermediate Data Vault Modeling
- Chapter 6: Advanced Data Vault Modeling
- Chapter 7: Dimensional Modeling
- Chapter 8: Physical Data Warehouse Design
- Chapter 9: Master Data Management
- Abstract
- 9.1. Definitions
- 9.2. Master Data Management Goals
- 9.3. Drivers for Managing Master Data
- 9.4. Operational vs. Analytical Master Data Management
- 9.5. Master Data Management as an Enabler for Managed Self-Service BI
- 9.6. Master Data Management as an Enabler for Total Quality Management
- 9.7. Creating a Model
- 9.8. Importing a Model
- 9.9. Integrating MDS with the Data Vault and Operational Systems
- Chapter 10: Metadata Management
- Chapter 11: Data Extraction
- Abstract
- 11.1. Purpose of Staging Area
- 11.2. Hashing in the Data Warehouse
- 11.3. Purpose of the Load Date
- 11.4. Purpose of the Record Source
- 11.5. Types of Data Sources
- 11.6. Sourcing Flat Files
- 11.7. Sourcing Historical Data
- 11.8. Sourcing the Sample Airline Data
- 11.9. Sourcing Denormalized Data Sources
- 11.10. Sourcing Master Data from MDS
- Chapter 12: Loading the Data Vault
- Chapter 13: Implementing Data Quality
- Abstract
- 13.1. Business Expectations Regarding Data Quality
- 13.2. The Costs of Low Data Quality
- 13.3. The Value of Bad Data
- 13.4. Data Quality in the Architecture
- 13.5. Correcting Errors in the Data Warehouse
- 13.6. Transform, Enhance and Calculate Derived Data
- 13.7. Standardization of Data
- 13.8. Correct and Complete Data
- 13.9. Match and Consolidate Data
- 13.10. Creating Dimensions from Same-As Links
- Chapter 14: Loading the Dimensional Information Mart
- Abstract
- 14.1. Using the Business Vault as an Intermediate to the Information Mart
- 14.2. Materializing the Information Mart
- 14.3. Leveraging PIT and Bridge Tables for Virtualization
- 14.4. Implementing Temporal Dimensions
- 14.5. Implementing Data Quality Using PIT Tables
- 14.6. Dealing with Reference Data
- 14.7. About Hash Keys in the Information Mart
- Chapter 15: Multidimensional Database
- Subject Index
Building a Scalable Data Warehouse with Data Vault 2.0
Daniel Linstedt
Michael Olschimke
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.