Free AI web copilot to create summaries, insights and extended knowledge, download it at here
2803
Abstract
e-commerce businesses</figcaption></figure><p id="374e"><b>Key takeaways</b></p><p id="417d">Looking at the tools that Raw Vault brings with it, we can easily draw out following benefits –</p><p id="9470"><b>Fully equipped to tackle business changes —</b> Be it a change in the business keys or entity relationships, the isolation of the keys and relationships from the actual data around them makes such integrations hassle free</p><p id="66fb"><b>Handles large data volume and achieves parallelism —</b> One satellite per source enables parallel processing which inturn means load distribution and faster load cycles. Satellites can also be distributed on the basis of change velocity that results in reduced data redundancy.</p><p id="ebc5"><b>Incremental data onboarding —</b> Onboarding new sources and data points made easier. Data Vault’s design advocates pattern driven development that enables a quick time to business for new requirements.</p><p id="e3cd"><b>Fail early and rectify fast — </b>With Data Vault, SMEs can identify problems in the source data/model much before reaching the Data Marts.</p><h1 id="e2c5">Beyond Raw Vault</h1><p id="c5dc">So far, we’ve spoken about the advantages of implementing the Raw Vault. But, does that mean it doesn’t bring challenges of its own?</p><p id="7c5c">As a matter of fact, it does. A quick look at the model above and stakeholders often find themselves asking questions like “How do we proceed from here?”, “What about the performance coming out of Raw Vault?”, “Is there a standard for pulling data out of the Raw Vault?”, “Shouldn’t there be a Business Vault, and what does that entail?”</p><p id="1712">These are all valid queries, especially when it comes to constructing a robust and scalable architecture for the organization’s data management strategy. Some of the answers can be found in Business Vault. We’ll take a quick look at how it helps the data flow from Raw Vault to the Marts and if it is even mandatory for a fully compliant Vault implementation.</p><p id="29b3">The business vault is an extension of a raw vault that applies selected business rules, de-normalizations, calculations & other query-assistance functions. Business vault too comes with a few standard data extraction approaches as detailed below –</p><p id="f882"><b>PIT tables —</b> PIT tables specifically address the need for denormalization. Denormalization doesn’t just mean stitching together data that’s maintained independently in the source systems, but also getting back data points that were segregated into multiple objects by the virtue of Raw Vault. For example, in the investment sector, one may want to look at not just the basic details around an instrument that they have invested into but also the coupon attached to it, the factors that get
Options
updated every 10th of the month and/or the ratings provided from various Credit Rating Agencies.
On the other hand, denormalization between the Raw Vault objects for daily positions data, that pivots on the relationship between a portfolio and an instrument is inevitable.
A PIT table can help tie the data together for a better 360 view of the entities as well as tie the relationship stored in links back to the driving datasets and ready for consumption in the Data Marts.</p><p id="b7df"><b>Bridge tables —</b> The concept of bridge tables has been there for a while and just like any typical scenario, these will be created to optimize joins across datasets that are expected to be used together frequently.</p><p id="423a"><b>Satellites with predefined calculations —</b> Quite often, there are some transformations / calculations / aggregations that are a common requirement across multiple user groups and functions. Business vault would be the recommended place to achieve these transformations which makes it available to various data marts.</p><p id="e010">All this being said, is Business Vault a mandatory hop? The answer is no. One can be fully compliant to DV 2.0 and still not have a business vault implemented. We can see that the requirement for a business vault pivots around the complex scenarios that may pop up during the warehouse implementation.</p><h1 id="0603">Conclusion</h1><p id="a759">To conclude, let us take a moment and look at the factors of Data Vault that may impact the decision making process.
Data Vault offers flexibility, scalability, governance and agility. All this, topped with a pattern driven approach for Raw Vault development, inturn results in a high speed delivery. There are frameworks and tools that can fuel the velocity even further (Check out more on Astraa’s MDD framework success story <a href="https://astraa.com/recognition/astraa-revolutionizing-insurance-analytics-with-intelligent-data-solutions/">here</a>).</p><p id="4032">However, we have also seen how data extraction from Raw Vault can be a complex task in itself and may require stakeholders to factor in the implementation of Business Vault during their time and cost estimation. Not to forget, an increased number of objects to be maintained and monitored is an obvious byproduct.</p><p id="74fd">These are all very important points to be considered before choosing Data Vault as the warehousing approach. Considering the size of the enterprises is a critical factor too. A small enterprise would be recommended against going through the complexity of a Vault implementation if they have fairly lesser functions/line of businesses.</p><p id="0e41">Hope this helps in getting a fair understanding of Data Vault 2.0 and help gauge the impact of it’s implementation.</p></article></body>
