Advanced Virtual Data Vault and WWDVC 2022
Advanced Virtual Data Vault will be introduced at WWDVC 2022 – get your seat today!
-
-
Effectivity Sats and Second Level Stages
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…
-
Understanding Late Arriving Data
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…
-
Technical Tip: Clustered Hash Keys – Don’t Do it!
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…
-
Data Vault 2.0 Suggested Object Naming Conventions
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…
-
How To:Test an Idea for Data Vault Standards
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 AI and Data Science with Data Vault
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…
-
What is Data Fabric?
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…
-
Building a Snowflake 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…
-
Data Vault New Powerful Weaponry In Your Data Science Toolkit
Picnic is an online grocery, where we aim to bring grocery shopping and the traditional Milkman model into the 21st century. Easy and frictionless ordering, a focus on personal service, home delivery with electric vehicles, and an efficient, highly optimized just-in-time supply chain. In short, we are tech’s answer to groceries. We do not just…
