Re: Expect to work with terrabytes.. now what?

On Thu, 27 May 1999 09:18:19 GMT, Dante <dnotari_at_my-deja.com> wrote:
>Ferdinand,
> You should use BITMAP index

Why?

>
> Once you have figured out how you will structure your data
> you will need to know what are the most likely queries
> and distribute your datafiles over different disks/media
>
> You should enable the STAR_TRANSFORMATION.
>
> And there is much more ;-)
>
>Regards
>Dante
>
>In article <7ieald$vlj_at_guust.incore.xs4all.nl>,
> "Ferdinand Swaters" <ferd_at_incore.xs4all.NO_SPAM.nl> wrote:
>> Hi All,
>>
>> I am currently on a project where the data in my database is going to
>run
>> into the 1-10 Terabyte range. I have no experience with these sizes
>of data
>> in a DBMS, and I am wondering what new pitfalls I might run into.
>>
>> The system will do almost no updates on the data, most is storage and
>then
>> delete after a while. There won't be many queries on the data, but the
>> queries will be large. It is much like a data warehouse situation.
>The DBMS
>> will be oracle.
>>
>> I don't have a good idea on what questions to ask first, because I'm
>mainly
>> concerned about the things I might forget now, and run into when the
>beast
>> is operational. One thing that I would like to know is if there is a
>way I
>> could compress the data while it is in the database. That would reduce
>> storage space required by a huge factor.
>>
>> Anyone has some experience they wish to share?
>>
>> advTHANKSance,
>>
>> Ferd.
>>
>>
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---

-- 
These opinions are my own. 
http://ourworld.compuserve.com/homepages/joel_garry   Remove nospam to reply.  
mailto:joel-garry_at_nospam.home.com                        Oracle and unix guy.