This is a blurb about loading processes, and the patterns that exist in the Data Vault. It introduces the concepts of code-generation.
1.0 Goals and Objectives The following elements are part of the goals and objectives for loading the Data Vault. The data warehouse should truly represent the source systems in their original formats, and the only thing that should be done to the data is basic defaults, and error reporting. (more…)
Some folks still think that the Data Vault is a product. Data Vault Modeling is NOT a product. It is a free & clear, data modeling architecture. It is open to the public, and the knowledge is considered public domain. Data Vault Modeling has it’s own rules and standards, just like 1st through 6th normal […]
A quick guideline for bootstrapping your effort of building a Data Vault model based on a Star Schema model.
A short way to create a Data Vault model from a 3NF system. This is a very brief introduction/overview of the process.
In this post we discuss the long debated desire to put foreign keys in Satellites. This is only a peek into the types of problems you might have going forward IF you do this.
A short discussion on combining raw data vaults with business vaults in the context of achieving an operational data vault and high performance.
First posting about implementation, design paradigms, the value of patterns in the Data Vault modeling and methodology.
In this post I introduce and discuss some of the SSD hardware from a server side, and what it’s potential is when used to support a Data Vault.
A brief look into handling XML/XSD staging data using Oracle XDB technology.