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 ...

Get Data Modeling for Azure Data Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.