Archives of the TeradataForum
Message Posted: Mon, 26 Feb 2001 @ 21:55:59 GMT
| Subj: || || Re: Why not use star schema |
| From: || || James Judge |
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.