Death by Spreadsheet
I suppose most of us have heard the phrase “death by PowerPoint,” referring to those occasions when the burping, animated clip…
Data Modeling News, Articles, & Education
Get a thorough Data Modeling education through TDAN’s Business Intelligence articles, news, and blogs.
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,…
Understand Relational to Understand the Secrets of Data
I don’t like talking about the relational theory of data. It is absolutely fundamental to any deep understanding of data,…
Benefits of Modeling Apply to NoSQL
Information drives businesses who make decisions based on data. Data is a corporate asset. Data modeling is critical to understanding…
Semantic Business Vocabulary and Rules (SBVR)
I. Introduction Information Systems (IS) play an important role in business because they implement the business process. However, designing, refining…