Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 27 Sep 2005 @ 14:27:39 GMT


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


Subj:   Re: Design Considerations for FS-LDM/3NF model
 
From:   Lunn, Jonathan

Rishi,

You're welcome. Congratulations on sticking close to 3NF, it'll pay dividends down the road. But, be sure to put enough effort into building a presentation layer to insulate your users from having to navigate the complexities.

I did highlight paying close attention to the relationship tables earlier, choosing the primary and secondary indices is very important here. You need to find an indexing strategy that supports queries from both directions, from Event to Account as well as from Account to Event for example. You may find that using the same PI as one of the 2 tables will help out, by co-locating the relationship rows with the rows of the most frequently used entity. I would also recommend using a PPI for the Event table, assuming that you're at a release that permits them.

Good luck, let us know how it goes.


JL



     
  <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