|
|
Posted by --CELKO-- on 04/06/06 00:43
>> I got a 1TB reporting DB in this situation. It nests views about 5 layers deep. The system has had this design for nearly 4 years now and has gotten out of hand.<<
I am a believer in the "Rule of Five" -- humans cannot easily process
more than five things.
>> Avoid transformations in the views <<
But this can be a handy way to assure that everyone converts English
units to Metric, etc. the same way. I picked that example because I
had a problem where one guy did his conversions to 2 decimal places,
another guy did it to 3, another guy to 4, etc. all the way out to 8
decimals and one usign FLOAT. The result was that sometimes we
destroyed inventory (okay, call it shrinkage, spoilage, or waste) but
sometimes we created inventory. Scary when you are dealing with food
products.
>> Create a view refresh process. Create a table driven procedure that refreshes the views in the correct order. <<
Amen.
Navigation:
[Reply to this message]
|