Hi Everyone, Recently I heard about the CDVP2 hands-on materials, and the CDVP2 materials were not representing normalization or denormalization in the right light. I wanted to take a minute to refresh the understanding of what these things truly are, and how they are defined to be. We do use / apply the terms properly,…
Advanced Virtual Data Vault will be introduced at WWDVC 2022 – get your seat today!
This week I bring you a few definitions, and some interesting questions and answers that I’ve had over the years. We teach these concepts in our CDVP2 class, but probably not to this level of detail. EFFECTIVITY SATELLITE Effectivity Satellite = is a Satellite structure containing “begin and end dates” or multiple instances of begin…
Call it back-dated data, call it real-time feeds, call it old data arriving late, call it what you will. The problem has persisted since day 1 of systems creating, feeding, and sharing data. But the problem is deeper than just systems. The problem lives on whenever business users can and must back-date data. What does…
This is a short tip for everyone out there implementing Data Vaults. We’ve heard throughout the years about people trying to CLUSTER the Hash Keys in Data Vault on SQLServer and other databases that support clustering. This is a bad idea and should be avoided at all costs. What is a Clustered Key? Generally a…
Hello everyone, We have a list of suggested naming conventions that are essentially best practices. There are a few standards documented here (rules that must be adhered to), but the naming conventions themselves are best practices (suggestions for you to execute if you choose). The Data Vault 2.0 Standards for Naming Objects Objects in the…
Hi Everyone! We want to encourage you to engage in helping evolve the Data Vault Standards. While this is not a democratic process (as we don’t believe in voting for standards), this must be an evolutionary process. In that light, we want community suggestions. However, the proper rigor must be applied to the new standards…
Navigating Your AI and Data Science Initiatives to Success with Data Vault Artificial Intelligence can be complex and difficult for businesses to adopt and implement successfully. Business leaders can be nervous about going into the breach with AI. Business executives may even float plans to implement AI while privately leaving it to the next CTO…
Data Fabric is one of the latest buzzwords associated with another buzzword, Digital Transformation. In this post, let’s untangle the concept of Data Fabric and unsnarl it from marketing entanglements. Then, we can look at Data Fabric in the context of Data Vault, how the approaches complement each other, and how taking a Data Vault…
In this day and age, with the ever-increasing availability and volume of data from many types of sources such as IoT, mobile devices, and weblogs, there is a growing need, and yes, demand, to go from batch load processes to streaming or “real-time” (RT) loading of data. Businesses are changing at an alarming rate and…