Snowflake’s Elastic Data Warehouse as a Service: Favorite Features

Since I am currently working with Snowflake Elastic Datawarehouse (see http://www.snowflakecomputing.com), and excited about what experts regard as it’s game-changing innovations (for a summary, see http://www.snowflake.net/blog/top-10-cool-things-i-like-about-snowflake/  ), I want to take a moment and describe my own personal favorite features.  But first, some quick background:  Snowflake is a built-for-cloud, MPP column-oriented, **ANSI-SQL-COMPLIANT** data warehouse service… Read More

Universal Data Vault: Hyper-Generalized Data Vault — Review of John Giles’ Case Study

I recently came across an interesting data-modeling case study.  John Giles, who wrote it, is also the author of the insightful and — for us data geeks — entertaining book, ‘The Nimble Elephant’.  In this UDV case study, John combined his strategy of applying, and establishing variations from, universal data-modeling patterns to Dan Linstedt’s Data Vault EDW methodology, with very practical results in a challenging… Read More

Lean Data Warehouse via Data Vault

Today, businesses want a data warehouse to be Lean.  In contrast to many traditional data warehouses, a Lean Data Warehouse is simple, fast to deliver, automatable, free of over-complex dependencies,  adaptive to business change, and thus quickly profitable.  Data Vault is an outstanding logical architecture for a just such a Lean Data Warehouse. With a conceptual overview and a few medium-dive examples, this original article points the way forward. To… Read More