Universal Data Modeling

Chapter 8. Dimensional and Data Vault Models

A note for Early Release readers

With Early Release ebooks, you get books in their earliest form—the author’s raw and unedited content as they write—so you can take advantage of these technologies long before the official release of these titles.

This will be the 8thth chapter of the final book. The GitHub repo will be made active later on.

If you’d like to be actively involved in reviewing and commenting on this draft, please reach out to the editor at @oreilly.com.

In the previous chapter, you have explored the document model, the key-value model, the wide-column model, the relational model, and the graph model, all of which play important roles in transactional/operational systems and data storage architectures. While relational databases emphasize structured, normalized data for transactional consistency, and document/key based databases support flexibility for semi-structured and unstructured information, analytical requirements introduce a different set of needs. Organizations require models that support historical analysis, aggregation, trend exploration, and business intelligence at scale. This shift in purpose from supporting day-to-day transactions to enabling insight and decision-making drives the need for specialized data modeling approaches in analytics environments.

Dimensional modeling is the most widely adopted modeling techniques for analytical systems, particularly in data warehouses/lakehouses and business intelligence ...