The Data Vault Handbook - Concepts and Applications

In this chapter • Learn the roles of Hubs, Links, and Satellites in capturing business keys, their relationships and descriptive attributes • Discover how derived entities like Non-Historized Links, Multi- Active Satellites, and Reference Data Tables address specific data challenges and business needs • Explore how Point-in-Time (PIT) and Bridge tables optimize performance by simplifying joins and enhancing query efficiency in the Business Vault

3. DATA VAULT MODELING

Data Vault modeling is one of the most defining aspects of Data Vault, distin- guishing it from other approaches. At Scalefree, we frequently observe that this area is a focal point where our cli- ents seek the most support and guidance.

While it can be challenging to grasp initially, mastering the Data Vault model patterns is crucial for effectively implementing a robust and scalable Enter- prise Data Platform. Each entity within the model is designed with a specific purpose, providing not only a structured approach to data loading but also a framework for efficient data storage and retrieval, ultimately optimizing the workflow across the entire data ecosystem. In this section, we will begin by exploring the three foundational entities of the Data Vault model: Hubs, Links, and Satellites. These core components serve as the building blocks upon which more complex entities are derived. A solid understanding of these basics is essential before delving into the more advanced derived entities. Additionally, we will introduce Point-In- Time (PIT) tables and Bridge tables, which are special entities designed to address specific challenges within the data warehousing process. Keep in mind that these modeling standards will be applied throughout our Enterprise Data Warehouse layer (Section 2.2), encompassing both the Raw Data Vault and the Business Vault. The placement of entities within either the Raw or Business Vault will depend on whether we are applying hard or soft rules (Section 1.3.1). Finally, to enhance understanding, practical exam-