Data Models are a’changin! To learn about these changes, please join me Saturday, Oct 15, as I present “Lean Data Model Storming for Data Project Leaders” at the Southland Technology (SoTec) Conference 2016. To view my session abstract, click here. This premier event, underwritten by PMI, AITP, IIBA and QAI, will bring together hundreds of… Read More
Agile ModelStorming to Integrate BigData / NoSQL with RDBMS
Another published slide deck, presented in Huntington Beach at the recent SQL Saturday Event. To view the deck, click here. Viewer comments are always welcome!
Data Modeling for Integration of NoSQL with an RDBMS Data Warehouse
This post for data modelers, like a good portion of my online content, is in the form of published slides. To view them, click here. If you like them, feel free to subscribe here for the occasional new entry.
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