Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 27 Feb 2001 @ 13:08:49 GMT

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

Subj:   Re: Why not use star schema
From:   Claybourne Barrineau

In our specific case:

We convert three 3rd normal fact tables (all with different Primary Indexes) (~200 million record, ~60 million records, ~5 million records respectively) into separate (by geography) star schema databases. Each database has an atomic table (with a new common 6 part key UPI) and 8 summary tables (built from the atomic table.) The dimension tables for each star schema are made up of data from ~50 3rd normal form supporting tables. We provide the user with ~1.1 million ways (tuples) of looking at this data with an average response time of ~15 seconds.

This design has been "blessed" by NCR as a necessary evil to support the strict response times imposed on us by the users of our application given the amount of disk space and processing power we currently have available to make "lemonade" with.

Sometimes de-normalization is necessary as a transitional solution to a larger problem.



  <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