Re: Data Warehousing and RAID

If you can afford it, Mirroring (RAID-1 or Shadowing) is great. Heck, even better is RAID 0+1, which is striping and mirroring. This should give you decent writes and great reads.

The best value for a small DataWarehouse is (IMHO) RAID-5. If you have several hours to apply your updates at night (because writes are slower than RAID-1.) then all day long your users will have great read access. Also RAID-5 will provide some level of fault tolerance that a non-RAID system wont. Besides it only costs you one extra disk per array (as opposed to RAID-1 which doubles your disk requirement.)

-Frank

P.S. Im assuming you have a small to modest DW if you are putting it on an NT box it "can be relatively easily restored from backup."

In article <35A76822.847634B9_at_imb.com.au>,   Phil Swain <pswain_at_imb.com.au> wrote:
> This is a multi-part message in MIME format.
> --------------74088C24A632F57F461F1140
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hi,
> I would be extremely grateful for anyone's advice on using RAID
> (and which one) with Data Warehousing (DW). Obviously the main usage of
> the disk array is "bulk" loading data and then ad hoc queries which may
> well be running for many many minutes. This is not a OLTP system. If
> anyone has practical experience then this would be great. Is RAID a
> waste with DW since the data is virtually static with no updates during
> the day and which can be relatively easily restored from backup? Will
> RAID5 be slow, even when the array is external with it's own processor
> and 256Mb Cache for it's single controller? Note this is a NT system
> with Red Brick RDBMS. Thanks in advance
> Phil
>
> --------------74088C24A632F57F461F1140
> Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Phil Swain
> Content-Disposition: attachment; filename="vcard.vcf"
>
> begin: vcard
> fn: Phil Swain
> n: Swain;Phil
> org: IMB
> adr: 253-259 Crown St.;;;Wollongong;NSW;;Australia
> email;internet: pswain_at_imb.com.au
> title: Project Leader
> tel;work: 042 279108
> tel;fax: 042 279207
> note: ICQ 8216803
> x-mozilla-cpt: ;0
> x-mozilla-html: TRUE
> version: 2.1
> end: vcard
>
> --------------74088C24A632F57F461F1140--
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sun Jul 12 1998 - 00:00:00 CDT