Oracle-L: RE: RE: RE: RE: Manager decrees "his" data warehouse design.

From: Cunningham, Gerald <Gerald.Cunningham_at_usi.net>
Date: Thu, 28 Feb 2002 09:03:26 -0800
Message-ID: <F001.0041B442.20020228090326@fatcity.com>

Actually, they're different.

SAN = faster, more $$$ (e.g. EMC)
NAS = slower, less $$$ (e.g. Network Appliance)

-JC

-----Original Message-----

Sent: Thursday, February 28, 2002 9:38 AM To: Multiple recipients of list ORACLE-L

Patrice,

They are synonyms for each other as far as I understand.

Dick Goulet

____________________Reply Separator____________________
Author: "Boivin; Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>
Date:       2/28/2002 3:38 AM

I guess the reverse of SAME is EMAS, where Everything Makes Absolute Sense.

: )

NAS, is that the same thing as a SAN?
Network - Attached Storage
Storage Area Network

Here we have a couple of "SANs", but I think they also fit the description you gave of an NAS.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-----Original Message-----
Sent: Wednesday, February 27, 2002 6:53 PM To: Multiple recipients of list ORACLE-L

S.A.M.E, Stripe And Mirror Everything. It's a concept that came from an individual at Oracle with a significant pile of alphabet soup after his name who has lost most of his credibility anywhere.

He was speaking though of Network Attached Storage (NAS) stuff where you really don't have to worry about the mount point/drive letter where you put the datafile(s). These neato devices do make some of the DBA's tasks of IO balancing meaningless since they do stripe data across multiple disks and run hardware mirroring in the background. In turn they retrieve your data from the most efficient place possible & buffer your writes in cache memory that 'guarantees' that it will absolutely make it to disk.

What I think has happen is that some of his idea was taken out of context, though not out of quote, and made meaningless. You should still have logical database design and multiple tablespaces/datafiles. It's just that you really don't care is everything is on drive H.

Dick Goulet
PS: I've not implemented such an idea & have no intention thereof in the near future. Reason, NAS storage is not here.

____________________Reply Separator____________________
Author: "Michael Cupp" <michaelcupp_at_SHONAC.com>
Date:       2/27/2002 1:20 PM

S.A.M.E.?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------


To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------


To REMOVE yourself from this mailing list, send an E-Mail message

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------


To REMOVE yourself from this mailing list, send an E-Mail message