Re: PUBLIC:Re: Has anyone developed applications with DB's over 100GB?

Oracle can easily handle up to a Terabyte or more of information. NASDAQ runs on Oracle servers if I am correct, as well as the CIA computers. Anyway the key to making it all work is I/O. Since it is not feasible to do sorting and such in RAM, the bottleneck becomes I/O. More disks is better than fewer disks. RAID is almost essential because more disks brings along the higher possibility of disk failure. Partition key tables(Oracle 8 will help this tremendously). Manage storage and rebuild indexes frequently if this is an OLTP database. If OLAP then rebuild after every data load. A sound DB design will do wonders for databases of this size.

Derek Licciardi
dlicciardi_at_tcipro.com

Danny Wijnschenk wrote in message <34BF59AB.3630_at_pophost.eunet.be>...
>Eugen Nyffeler wrote:
>>
>> Marc Jacobson wrote:
>> >
>> > I have never heard of a database so enormous. But I would think the
 only
>> > common database that might be capable would be DB2.
>> >
>>
>> Welcome to the world of Oracle.
>> I've worked with DB's in this size and larger on Oracle under Unix.
>> One problemarea was the backup/restore of this DB's due to 7*24h
>> availability , also sometimes the queries over tables with 30Million
>> rows (and up), wrong joined or queries which coudn't use indexes.
>> The most importend part is a sound DB design.
>>
>> if i'm right Oracle is also used on DB's in the tera byte area.
>>
>> rgds
>> eugen
>
>..And welcome to the world of Cache' where we have lots of sites that
>deal with +100Gb of data.
>We can do concurrent backup to solve the 7*24h availability : the users
>can work while the backup is going one. Another way is to use a shadow
>server that is replicating the main database, and can be put 'off-line'
>to do a backup. When it is put on-line again, it will replicate the data
>that was changed in the mean time.
>
>
>
> Danny Wijnschenk
> Sales Engineer
>
> InterSystems (Belgium)
> Babelomstraat 29
> B-3320 Hoegaarden
> tel. +32 (0)16 76.08.12 _______
> fax. +32 (0)16 76.08.13 ( )
> ( DADA ! )
>email Danny_Wijnschenk_at_intersys.com (__ ____)
>or Belgium_at_intersys.com
>web www.intersys.com o
> www.intersys.com/benelux
>chat www.intersys.com/benelux/local/cafe.htm o
> /|||\
> ( Q Q )
>__________________________________________oOOO__(_)__OOOo_____
Received on Sun Jan 18 1998 - 00:00:00 CST