The following whitepapers are available for download. These are more in-depth explanation of patterns, techniques and approaches of topics covered in the weblog.
- The Natural Business Key. The Natural Business Key as high performance alternative to Hash Keys.
- Applying Business Logic to Data Vault. Generating standard Data Vault components is relatively easy. But how to overlay business rules?
- All about dates and times. What are the typical date / time attributes you would encounter in a data solution such as Data Vault?
- Introduction to Biml. If you use the Microsoft stack, check out the Business Intelligence Markup Language (BIML).
- Introduction to Data Vault. Data Vault is used as driver for the data solution in many areas, but what is it really?
- Merging Time-Variant data sets. Fundamental techniques to combine two or more historical data sources.
- Some insights about … Insights. How are business insights really created?
- When is a change a change. An holistic view of ‘Change Data Capture’. Every time time-variant data moves to a smaller target set there is a chance to record redundant rows. This paper explains mechanism to address this.
- Multi-Active Satellite considerations. An overview of the most common approach for managing ‘grain shift’ in Data Vault.
- Abstracting away complexity by developing the engine. ‘Engine thinking’ is explained as guideline / principle for iterative refactoring a data solution for maximum business benefit.
- Consistency and Referential Integrity How can consistency and RI be managed in a continuous parallel loading environment?
- What is The Virtual Data Warehouse. The Virtual Data Warehouse is more than just a technology, it’s a mindset to design and manage data solutions.
- A pattern for Data Mart delivery. The single pattern to deliver Point-in-Time, Fact and Dimension tables, including handling of late-arriving data.
- Bitemporal Backdated Adjustments. An example of the expected behaviour when dealing with late-arriving data (backdated adjustments), and how this can be represented in a deterministic way.