Second look at technology stacks in the Hadoop, MapReduce arena, and beginning to consider the technology to implement for Data Vault model testing.
#datavault Training! Cincinatti, Ohio Intense 3 day Class
You can check out the details here: http://www.lucruminc.com/datavaulttraining, I am offering a non-certification based, intense 3 day Data Vault class in the US, hosted by Lucrum Inc. A consultancy in the US. – There will be no certification test, so there are some differences…
#datavault: New Response to Frank Habers – Part 1
If you don’t like discussions, then this posting is not for you. This is a quick dive in to false assumptions and statements made by someone out there who is not DV certified, and has never built an audited/reviewed Data Vault model.
Column Based Data Vaults #datavault
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 store.
Comments Off 
Mathematics of Joins, Denormalization, Rows Per Block and IO
People come to me all the time complaining about the NUMBER OF JOINS in the Data Vault. I thought I might take a crack at answering this question/complaint, and provide some solid mathematical proof behind the fundamental design of the Data Vault model. I welcome your feedback (I hope you take the time to comment).
Hardcore Table Comparisons: Dimensional and Data Vault
There are a lot of comments, and questions out there about the Data Vault model, particularly from those who claim to know it and understand it. Yet some of them have a) not engaged me, nor b) gone to take the certification class. Reasons for the DV model are buried in the methodology – a lot of benefits come from using both the data modeling techniques and the methodology. That’s for another post. In this post I will try to focus JUST on the physical table structures, similarities and differences, so that the physical nature of the structures can be “compared” (so to speak).
Clash of the Titans: Post on Kimball Forum
The Data Vault Model is NOT the be-all-end-all solution to data warehousing, it IS a single evolutionary step forward, as it is a Hybrid design. If you don’t feel pain in your current implementation, then you may not be a candidate for the Data Vault model and methodology.
Caveat-Emptor Part 2 – Clarifications & Follow up
My previous post was not extremely clear, and for that I apologize to all the customers, consultants, and friends of the Data Vault. This post I will try my best to clarify who’s who, and what’s what. There ARE some firms, and individuals that we do trust, and we do believe in for consulting efforts. I also explore the process of “Authorized Trainer” along with the “value” of what all this means to you as a customer.
Comments Off
#dvseminar – Data Vault Seminar Smashing Success
#dvseminar was fantastic, As an informal way of gathering information, if you’d really like to attend next year, please leave a comment at the end of this post with your name and email. We can put you on the notification list for next year! This post covers some highlights (from my perspective), I’d love to hear your perspective, so leave me a comment!
Comments Off
Code Generation for Data Vault, not as easy as you think!
A short discussion about the inputs you should be using to generate ETL / ELT and Data Vault Models. If your current vendor isn’t there yet, that’s ok – just ask them when they will, and why they haven’t yet gotten there.
Opportunity, DV Consulting, US-Wash DC
I have a potential opportunity for consultants, or a team of implementation consultants interested in working for one of my prospective clients. The gig is just now being specified, could be several months long. It’s in the US, Washington DC area. I need 3 to 4 CERTIFIED Data Vault consultants who may be interested, or a company who may be interested in sending in a team. You would work directly for the customer, I would be on project management and oversight. If you are interested in submitting your name and finding out more, please drop me an email before the end of business tomorrow. (Today if possible). OR contact me using the contact form here on my site.
How do YOU define Staging Out?
There is a lot of talk these days about what Staging Out means, what Business Data Vault Means, even what the term Data Mart means. In this entry I want to hear from you. Please enter a comment on this post, and tell me what you think “staging out” really means within the context of a Data Vault Methodology / Implementation…
Hard and Soft Business Rules
In this video, I briefly introduce and describe the nature of hard and soft business rules.
Data Vault Methodology – Introduction
A short video introduction to defining the Data Vault Methodology.
Comments Off
Clarification: Training, Standards, Certification
This is a clarification post about the standards, certification, and offering licensed training in the market place.
Comments Off
Data Vault: About the Standards And Methodology
A personal take on the state of the Data Vault Standards – model and Methodology, and the groups out there trying to “take over and make changes”…
Differences between DV and 3NF
A short high level view of the business intelligence world of differences between Data Vault and 3rd Normal Form.
Data Vault Vs Dimensional – Part 3
I begin to examine why the star schema or dimensional modeling technique doesn’t really meet the true needs of enterprise data warehousing. If you’ve succeeded with a dimensional model at an enterprise level, please add your comments, I’d love to hear from you.
Thought Provoking Data Vault?
A short entry on the ability of a Data Warehouse using a Data Vault to automatically adapt it’s structures to the content that it’s being fed, thus becomming a “smart system” over time.
Comments Off
Q&A:Additional tables impacting existing ETL jobs
Here we discuss the impact of “additional tables” on ETL jobs. It really is negligable, but in this case – it would be good for you to read this entry.
Comments Off
