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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access