Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Hardware requirements for large data sets

RE: Hardware requirements for large data sets

From: Gary Weber <gweber_at_charlesjones.com>
Date: Thu, 02 May 2002 13:37:17 -0800
Message-ID: <F001.00456E10.20020502133717@fatcity.com>


Tim,

Good description. Hence, my original statement for not needing RDBMS. I'm leaning towards calling this monstrosity a data parking of a sort. Just trying to figure out the best way to build the parking lot.

Gary Weber

-----Original Message-----
Sent: Thursday, May 02, 2002 5:07 PM
To: Multiple recipients of list ORACLE-L

What you have is a database that only supports full table scans and only allows "cold" full database backups and "cold" full database restores. Hopefully, you're never just seeking anything less than a full file, there are no referential-integrity issues between the files, and the availability requirements allow the data to be completely quiesced (no updates at all, just reads) while those cold backups are running. Even with a week between individual cycles, adding more load/update cycles can really make a week disappear...

Good luck!

>
> No need for query as we know it. Strictly bulk data collection/delivery.
> There may be a need for some cleansing. We've had a limited exposure to
> Informatica and believe it would meet our light needs in that respect.
>
> Gary Weber
>
> -----Original Message-----
> Sent: Thursday, May 02, 2002 3:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Shouldn't there be another "goal" like "query the data"? How about "query
> the data while refresh is running"?
>
> If you're on UNIX, I'm guessing that "dd" and "grep" should do just about
> everything for you...
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, May 02, 2002 1:29 PM
>
>
> >
> > 1-3 terabytes of raw data. ASCII format. Flat files. No requirement for
> > RDBMS
> >
> > Goal: to be able to "refresh" weekly from tapes/cds/other sources.
> >
> > What kinds of software/hardware may be needed to tackle this?
> >
> > Gary Weber
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Gary Weber
> > INET: gweber_at_charlesjones.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
> > 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: Tim Gorman
> INET: Tim_at_SageLogix.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
> 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: Gary Weber
> INET: gweber_at_charlesjones.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
> 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: Tim Gorman
  INET: Tim_at_SageLogix.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
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: Gary Weber
  INET: gweber_at_charlesjones.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
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).
Received on Thu May 02 2002 - 16:37:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US