Data Warehousing - RAID5 or RAID0-1

From: Surjit Sharma <surjits_at_ozemail.com.au>
Date: Fri, 5 May 2000 22:14:14 +1000
Message-Id: <10488.105038@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0030_01BFB6DF.3F342F10 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I need your thoughts on RAID0-1 vs RAID5 configuration on very large = data warehousing project. The expected data is going to be about 1 Tera = byte, 10 Giga byte Memory, Sun box E6500 , Oracle 8.1.5.

I am told that for data warehousing RAID01 (mirroring and striping) is = the good balance between RAID5 and no RAID at all. Does anyone has any = experience on this? I will be delighted to hear your thoughts.

My main consideration is to be able to load the data in the given window = (overnight) and good response time for the queries.

Thanks in advance.

Surjit=20

------=_NextPart_000_0030_01BFB6DF.3F342F10 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I need your thoughts on RAID0-1 vs =
RAID5=20
configuration on very large data warehousing project. The expected data = is going=20
to be about 1 Tera byte, 10 Giga byte Memory, Sun box E6500 , Oracle=20 8.1.5.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I am told that for data warehousing =
RAID01=20
(mirroring and striping) is the good balance between  RAID5 and no = RAID at=20
all.  Does anyone has any experience on this? I will be delighted = to hear=20
your thoughts.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>My main consideration is to be able to =
load the=20
data in the given window (overnight) and good response time for the=20 queries.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Surjit </FONT></DIV>
<DIV> </DIV></BODY></HTML>
Received on Fri May 05 2000 - 07:14:14 CDT