Thoughts on Semantic Debt
Semantic debt arises when an organization’s data management systems are conceptually inadequate. We often see semantic debt in source-to-target mappings…
Data Modeling News, Articles, & Education
Get a thorough Data Modeling education through TDAN’s Business Intelligence articles, news, and blogs.
Tales & Tips from the Trenches: Data Model Patterns for Agile Projects
This is the fourth column in my series about applying Agile techniques to data projects in our Tips and Tricks from the…
Tales & Tips from the Trenches: Agile Principles in Data Projects, Part 3
Data Modeling in Agile Projects This is the third in a series of columns about applying Agile techniques to data projects.…
Death by Spreadsheet
I suppose most of us have heard the phrase “death by PowerPoint,” referring to those occasions when the burping, animated clip…
The Data-Centric Revolution: The Core Model at the Heart of Your Architecture
We have taken the position that a core model is an essential part of your data centric architecture. In this…
High-level Intro to the Corepula Method of Data Modeling
Recent advances in data analytics have produced an insatiable appetite for data. Satellites, cell phones, and computers constantly churn out…
Celebrating 20 Years of TDAN.com
On June 22, 1997, The Data Administration Newsletter (TDAN.com) went live on the internet. The publication started online at stargate.net/TDAN…
Autonomics to Modernize DB Administration
There is a clear trend to automate and enable computerized tasks to streamline and optimize administrative and maintenance tasks. Many…
Recursive Queries for Hierarchical Data Retrieval
One of the most fascinating features of SQL is its ability to execute recursive queries. Like sub-queries, recursive queries save…
SQL Drawing Blanks? It’s NULL a Surprise!
Is your SQL drawing a blank? It’s NULL a surprise! The title of this post is a play on words,…