If you don't know what Data Vault is, this blog post is not for you.
If you are considering using it in your business, here is my reaction:
Data Vault 2.0, as advanced in the major work Building a Scalable Data Warehouse with Data Vault 2.0 by Dan Linstedt (with a forward by none other than Bill Inmon) is a major investment for any business. If you thought the Inmon method was over-engineered, you ain't seen nothing yet.
Data Vault basically replaces your ODS layer providing an even more complicated data storage solution, which attempts to keep a record of literally everything (all data, regardless of how clean it is) that ever gets sent to your database. Data proceeds from the Data Vault through your ETL solution to your presentation layer, where your Star and Snowflake schemas are based.
For the vast, vast majority of businesses, Data Vault is the wrong route to go down. It will seriously complicate your ETL. It will be hard to hard to find developers who are familiar with the methodology. It will slow down the development of your data solutions.
For a select few businesses, who have a need to store almost everything that ever gets sent to their database, Data Vault is a breakthrough methodology that will help you out in a big way.
If you are considering using it in your business, here is my reaction:
Data Vault 2.0, as advanced in the major work Building a Scalable Data Warehouse with Data Vault 2.0 by Dan Linstedt (with a forward by none other than Bill Inmon) is a major investment for any business. If you thought the Inmon method was over-engineered, you ain't seen nothing yet.
Data Vault basically replaces your ODS layer providing an even more complicated data storage solution, which attempts to keep a record of literally everything (all data, regardless of how clean it is) that ever gets sent to your database. Data proceeds from the Data Vault through your ETL solution to your presentation layer, where your Star and Snowflake schemas are based.
For the vast, vast majority of businesses, Data Vault is the wrong route to go down. It will seriously complicate your ETL. It will be hard to hard to find developers who are familiar with the methodology. It will slow down the development of your data solutions.
For a select few businesses, who have a need to store almost everything that ever gets sent to their database, Data Vault is a breakthrough methodology that will help you out in a big way.
No comments:
Post a Comment