Re: Oracle Data Warehouse

In article <43u5bt$u59_at_nic.tor.onramp.ca>, Rick Barber <RBarber_at_tor.lgs.ca> wrote:

>I am about to start a project where I will be building a data
>warehouse using Oracle. The database will ultimatly grow to about
>50Gbytes with 50 -100Mybtes being added daily and about the same being
>droped daily.
 

Try Red Brick System's VPT. It's the best relational database for data warehousing. See their Web page at http://www.redbrick.com or call 800-777-2585 for their free "10 requirements of a data warehouse".

>The hardware has not yet beed decided but it can be IBM RS/6000 model
>including the MPP with any configuration.
>
>There will be a total user population of about 50 - 100 online users
>during the day.
>
>I have woked with databases up to about 10Gbytes in the past but
>nothing this large. With the large insert and delete activity (all
>batch overnight oriented) I have a number of concerns:
>
>1) how do I perform a backup in a reasonable period of time?

Backups should be done on segments of data -- usually time-based. For example, if you update on a daily basis, the backup will be done daily, with changes being saved versus a complete backup.

>2) With all of the insert and delete activity how will I be able to do
>the reorgs that are necessary?

You will easily be able to reorg on segments of data -- this is more granular than a tablespace.

>3) how can I do the nightly batch on time?

By using a fast loader like Red Brick's that loads, checks for referential integrity and builds the indexes in one pass versus 3 like Oracle. Received on Tue Sep 26 1995 - 00:00:00 CET