Re: Hardware requirements for large data sets

2002-05-02 Thread Jared . Still
ED] 05/02/2002 01:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Hardware requirements for large data sets or processing time requirements?? I suggest Perl. ;-) -Joe --- Tim Gorman <[

RE: Hardware requirements for large data sets

2002-05-02 Thread Gary Weber
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: Multi

Re: Hardware requirements for large data sets

2002-05-02 Thread Tim Gorman
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 req

Re: Hardware requirements for large data sets

2002-05-02 Thread Joe Raube
or processing time requirements?? I suggest Perl. ;-) -Joe --- Tim Gorman <[EMAIL PROTECTED]> wrote: > 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 > a

RE: Hardware requirements for large data sets

2002-05-02 Thread Gary Weber
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:

Re: Hardware requirements for large data sets

2002-05-02 Thread Tim Gorman
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" <[EMAIL PROTECTED

Re: OT: Hardware requirements for large data sets

2002-05-02 Thread Jared . Still
[EMAIL PROTECTED]> cc: Subject: OT: Hardware requirements for large data sets 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 need