Articles and other data-related links
Unstructured Data Modeling
Listen to Sybase PowerDesigner Webinar on Unstructured Data
Industry Data Models
Leveraging the Industry Logical Data Model, Teradata White Paper, January 2007
Industry Data Models - Are they right for your enterprise?, Teradata Magazine, November 2006.
Data Model Scorecard
What's the Data Model Scorecard?, TDAN, April 2006.
The Data Model Scorecard Category
1 of 10:
How well does the model capture the requirements?, TDAN,
July 2006.
The Data Model Scorecard Category 2 of 10:
How complete is the model?,
TDAN, October 2006.
The Data Model Scorecard Category 3 of 10:
How structurally sound is the model?,
TDAN, January 2007.
The Data Model Scorecard Category 4 of 10:
How well does the model leverage generic structures?,
TDAN, April 2007.
The Data Model Scorecard Category
5 of 10:
How well does the model follow naming standards?,
TDAN, July 2007.
The Data Model Scorecard Category
6 of 10:
How well has the model been arranged for readability?,
TDAN, October 2007.
The Data Model Scorecard Category
7 of 10:
How good are the definitions?,
TDAN, March 2008.
Subject Area Modeling
Get down to business, one page at a time, Teradata Magazine, 2Q 2002.
Physical Data Modeling
The Importance of Data Modeling as a Foundation for Business Insight. This is a white paper I coauthored with Larissa Moss for Teradata. In the first half of this paper, Larissa explores the origin and significance of data modeling, as well as the concepts and principles behind the technique. In the second half, I focus on physical data modeling by describing the various mature and proven database design options available for BI/DW databases. And, at the conclusion of this paper, a case study is presented to further underscore the concepts put forth.
The Denormalization Survival Guide - Part I, TDAN.com, Issue 20 - April 2002The Denormalization Survival Guide - Part II, TDAN.com, Issue 21 - July 2002
Other cool links
| The Data Warehousing Institute | Information about their training and if you are a member, access to some of the best business intelligence research and articles ever written |
| The Data Management Association | This is the DAMA worldwide site, and provides lots of great data links and chapter information |
| The Data Administration Newsletter | I really enjoy reading TDAN. Practical data modeling and meta data articles from the experts. |
| Data Management Review | Nice search mechanism through all of their magazines. Good place to start if you need to research a data topic |
| –Data Management Center | Great portal to lots of data modeling sites. Also expert centers, book reviews, and data management happenings. |
| Teradata | Great collection of white papers free for the taking. You don't need to work with Teradata to benefit from many of the articles. |
| Data modeling tools comparison | Barry has a comprehensive listing of modeling tool vendors along with links to their sites. |
| Time Dimension | This website not only contains a very comprehensive time dimension, it also has the data to go along with it! |