Capturing Temporal Data on Changing Relationships in Data Vault

Watch the Video

In the latest installment of our enlightening Data Vault Friday series, our CEO, Michael Olschimke, delves into a thought-provoking query posed by a member of our engaged audience.

“We have received the relationship between investor and company with a PostingMonth for the last couple of months. Also, the ownership percentage for the relationship could change over time (see attached Excel for mock data :)). So our question is: should we take the Period as a part of the Investor_Company_Link? If yes, how can we track the relationship changes with Effectivity Satellite? Or do you think Multi-active link satellite is a better choice here?”

Michael meticulously explores the intricacies of modeling investor-company relationships, particularly when faced with dynamic factors such as changing ownership percentages over distinct time periods. He offers valuable insights into the considerations between incorporating Period as part of the Investor_Company_Link and the nuanced application of Effectivity Satellite or Multi-active link satellite to accurately capture and manage the evolving nature of these relationships.

This insightful discussion proves instrumental for data professionals navigating the complexities of representing dynamic relationships within the Data Vault framework.

Meet the Speaker

Get Updates and Support

Please send inquiries and feature requests to [email protected]. 

For Data Vault training and on-site training inquiries, please contact [email protected] or register at www.scalefree.com.

To support the creation of Visual Data Vault drawings in Microsoft Visio, a stencil is implemented that can be used to draw Data Vault models. The stencil is available at www.visualdatavault.com.