Re: 100 Gb DB solution wanted!!!
Date: 1996/01/11
Message-ID: <30F5416E.44A8_at_nla.gov.au>#1/1
Ramesh Dwarakanath wrote:
>
> Hi,
>
> We are trying to setup a database for an application which
> will have a maximum of 100 GB of data to be queried upon at a
> time but these queries will be few and far between.... Hence
> the idea of having a database of 100 Gb size does not appeal
> too much.
If you are going to use the data so infequently then why are you using an RDBMS at all.
Could you achieve the same results by having sequential files and doing your searches against tapes/cartridges instead of disk based files.
If you do need an RDBMS and the data is static then consider using Oracle's READ ONLY tablespace capability and couple that with some automated tablespace file(s) archiving (to/from tape) mechanism. You would have to setup views to group sets of your data into manageable chunks for querrying but that's the price you pay for this sort of requirement.
Bruce... Received on Thu Jan 11 1996 - 00:00:00 CET