Common Data Modeling Mistakes and Their Impact
Although data modeling has been around for over 30 years, it ranks among the top areas from which database application problems arise. Moreover, the severity …
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 …