Archives of the TeradataForum

Message Posted: Mon, 26 Feb 2001 @ 21:55:59 GMT

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

There is not a technical reason, Teradata performs very well with Star Schemas. NCR prefers a more normalized model as it is easier to extend and enhance with new data to meet unforeseen business needs. The star schema is built with a specific set of business questions it will support. No sooner than you get it in place and the users are asking questions that requires another star schema; which basically become one set of reports per star schema.

With Teradata, the preference toward a normalized model as the infrastructure allows a DBA to build a star schema view by using join techniques , and if needed indexing techniques, in VIEW(s) that present a "star schema" design to the application.

But, physically implementing a star schema is not a problem on Teradata. There is, or used to be, a WP on the NCR external site about use of Star Schema design, by Carrie Ballinger. But I can't find it at the moment.

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