Archives of the TeradataForum

Message Posted: Mon, 08 Jan 2001 @ 22:11:46 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>