 |
 |
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.
| |
