Tales & Tips from the Trenches: A Tool for Agile Data Transformation (MDOX)
Data Transformation is usually thought of in the context of database ETL (Extraction, Transformation, and Loading)— i.e. moving data wholesale between …
Databases Do Not Build Themselves
Unfortunately, a lot of databases start as a gleam in someone’s eye. Maybe it consists of a couple of tables needed to store some data for an …
Improve Data Governance in Your Data Models
The practice of improving data governance in data models is inefficient and can cause a potentially dangerous situation. This practice poses certain challenges …
The Book Look: Achieving Buzzword Compliance
Come back in time with me to 1999. What a year for both movies and data! You probably can guess three good movies released in 1999 just based on these quotes: …
Applying Top-down, Big-Picture Models to Data Vault Part 2
Data Vaults have enormous potential to deliver value, but to do so, we’ve got to turn the spotlight off the technology. Sure, we absolutely need some …
Data Governance is a Hot Topic (Data Modeling Too)
Data governance is a hot topic lately. Companies are trying to devise and implement governance programs to provide some structure around how they manage and …
Applying Top-Down, Big-Picture Models to a Data Vault Part 1
Data Vaults have enormous potential to deliver value, but to do so, we’ve got to turn the spotlight off the technology. Sure, we absolutely need some …
How to Do Top-Down, Big-Picture Modeling – Part 2
This paper forms the second part of a big-picture top-down data modeling trilogy. The first paper on why to take this approach can be found in two parts here …
When You Wish Upon a Star Schema
If there was ever a time when I was uncertain about the future of data, it’s now. I am not concerned about progress and not even remotely worried that …
Why Do Top-Down Big-Picture Modeling? Part 2
The preceding article in this series looks at some real-world case studies that suggest that starting with an enterprise-wide, top-down model can— at least …