Chapter 9: Data Vault Modeling
In Chapter 7, Dimensional Modeling, you learned how to create a star schema database. In Chapter 8, Provisioning and Implementing an Azure Synapse SQL Pool, you implemented a star schema. The goal was to optimize the database for analysis and reporting.
Demands and regulations change over time, meaning that the way we use data also changes over time. These changes the way we use data for us to implement changes in the star schema designs we create. To create a stable data platform, we implement a layer in between the operational databases that we learned about in chapters 3 to 6, and the dimensionally modeled databases that we learned about in Chapter 7, Dimensional Modeling, and Chapter 8, Provisioning and Implementing an Azure Synapse SQL Pool. This layer should be optimized for the long-term, flexible storage of historical data. When data here means relational data, creating a data vault data warehouse is a good option. That is what this chapter...