Links to Upcoming Courses, Articles, Great Data Places, and Yummy Desserts
Upcoming Courses
Data Modeling Master Class in San Francisco in July
Data Modelling Fundamentals 20-21 September 2010, London
Data Modelling Masterclass 22-23 September 2010, London
Articles
Data Fun
Unstructured Data
Listen to Sybase PowerDesigner Webinar on Unstructured Data
Sybase PowerDesigner White Paper on Unstructured Data
Making Sense of Unstructured Data, TDAN, January 2009.
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
Great Data Places
| The Data Modeler's Workbench | Templates from my book, The Data Modeler's Workbench |
| 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 |
| eLearningCurve | Great online training, including my Scorecard class. |
| The Data Administration Newsletter | I really enjoy reading TDAN. Practical data modeling and meta data articles from the experts. |
| Universal Data Models | Universal Patterns and Universal Data Models from Len Silverston’s company. I really enjoy Len's Data Model Resource books. |
| 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! |
Desserts
| The City Sweet Tooth |
A comic strip profiling New York City dessert spots - very cool! |