Home Page for the TeradataForum

Archives of the TeradataForum

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

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

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023