Column based data stores have been around for a long time. This blog will talk about what you need to do to make the Data Vault successful on a column based data store. It’s quite simple really, and in the end – some parts of physical data modeling don’t matter in a column based data […]
I had a great interview (now posted) with Jorge Garcia of Technology Evaluation Centers. It’s a fairly decent read.
A quick Q&A about the choices I made in the Northwind Data Model, particularly regarding the Data Vault I wrote about in 2001.
I cover an overview of SSD and Hard Drives, along with how data modeling can affect your current BI/EDW in a positive way.
Here are the rules for specification Version 1.0.9 of Data Vault Modeling. (Please feel free to comment on them by replying to this post). The new pieces are marked in RED as usual. (more…)
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.
I’ve long held a belief that the Data Vault modeling style ushered in a new era, that being one where we have the power to dynamically accept and automatically absorb new data elements. Of course, as always there are some rules and regulations (patterns) around when and how this can happen, and when the modeling […]
Covering the Frameworks, Architectures, and Data Modeling designs – basic overview of where you can compare/contrast, and how you can talk about these issues