Expert: Peter Choi - 5/29/2009

Question
I am loading normalized structres from denormalized inputs and want high concurrency and fast load time. The foreign keys are not inherited into primary keys of children and there is no use of circular RI.  What is the best way to do this?

    I can not turn off constraints due to concurrency.  I was thinking that to load all data on pass one and update children with FK data in pass two would be better then load parents then children then grand children in seperate passes.  
   What do you recommend and do you know of any white papers on the subject?

Answer
Hi David,

Here's a great thread from Oracle guru, Tom Kyte, on what's the best way for managing large/high volumes in a data warehouse or OLTP:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:356694874047...

Here's another great in-depth presentation from a consulting company called Rittman Mead (UK): http://www.rittmanmead.com/files/dimensional_modelling_on_oracle.pdf

Disc

Hope this helps.

Peter