Chapter 6
Advanced Data Vault Modeling
Abstract
This chapter addresses two additional aspects of Data Vault modeling: query assistant tables and reference tables. Query assistant tables are used to reduce the complexity of queries against the Data Vault and improve the performance. Two specific types of query assistant tables are covered: point-in-time (PIT) tables and bridge tables. Reference tables are covered in detail, including no-history reference tables, history-based reference tables and code and description tables.
Keywords
Query assistant tables
reference tables
point-in-time
bridge tables
description tables
reference tables
The previous chapter has introduced applications and special versions of the core entities in Data Vault 2.0, ...
Get Building a Scalable Data Warehouse with Data Vault 2.0 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.
