 |
 |
Archives of the TeradataForum
Message Posted: Mon, 08 Jan 2001 @ 22:11:46 GMT
Subj: | | Re: Technical Data Modelling |
|
From: | | Thomas F. Stanek |
I have to agree with Andy Blevins. When I first read your email, I thought perhaps you had inadvertently transposed 'Teradata' and 'DB2'
because every Teradata cusmomer with which I have worked has taken the normalised approach.
I think a normalized design is most appropriate to start. However, I would also very strongly suggest that you develop a Data Access
model, which would identify common and probable business questions and decomposes these questions into technical data requirements that
could then be used to determine the possible data access paths required to answer the business questions. This should identify likely join
strategies and will guide you in selecting indices and also should help in making decisions about the super-type/sub-type relationship.
Data Access modeling is a natural extension of the Business Discovery process, if you've gone through that exercise.
Regards,
Thomas F. Stanek
TFS Consulting
| |