Re: Load and Query question

Hi,

> . would you rather have a relational model which would help really large
> load
> volumes and get the data out there faster or go with a totally
> denormalized structure
> and don't care about when the data is delivered ?

I would definitively postpone the processing of descriptions in the presentation layer (in this case the join argument is IMO not very valid; I assume here the dimension considered here are more or less statically as in the currency example).

In case of slowly changing dimensions (SCD) the demoralisation could be useful but again I would consider primarily the denormalization of other dimension keys related with the SCD rather then the denormalization of descriptions (e.g. storing in the fact table redundantly to customer identification also the customer segment valid to the time of the transaction). The motivation to do so needn't be the pure "join cost to much" argument. The tricky part could be simple to find the right version of the SCD to be joined.

only my .02

Regards

Jaromir

• Original Message ----- From: "Shreeni" <shreeni_at_sbcglobal.net> To: "'Oracle Discussion List'" <oracle-l_at_freelists.org> Sent: Thursday, April 27, 2006 5:24 PM Subject: Load and Query question

> Hi List,
>
> I have a semantic question in a DWH environment. At the current place I
> work, the tables have been de-normalized to such an extent that they may
> not
> get qualified as 2NF even. Sure there are PK but they are there more to
> provide a security implementation rather than follow the relational
> priciples. Out of 200+ tables there is not one dimension or a fact or even
> one referential key. Each table has about 130+ columns out of which equal
> quantities are codes and descriptions.
>
> The argument in favor the current design is that joins are expensive.
> However from a DBA's perspective would you rather have a relational model
> which would help really large load volumes and get the data out there
> faster
> or go with a totally denormalized structure and don't care about when the
> data is delivered ?
>
> On an average day, the load takes more than 10+ hours and volumes are
> presently at 8mil+ rows everyday. The env is Solaris 9, Oracle 10.2.0.1.0
>
> Thanks
>
> Shreeni
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l