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

Get in touch with people with dataware house/VLDB (very large DB) experience using Oracle. You can find them in IOUG or perhaps your local chapters of IOUG.

I personally have worked on DB over 700 GB. Biggest ones I have heard are in terabytes range. Yes, backup/recovery, performance are big challenges.  But they are nothing that proper db and app design and money can't solve...

When working with VLDBs, get yourself familiarized with the following: data partitioning (pre-Oracle8, use UNION views; Oracle8, native partitioning), hot backup, parallel query option, parallel server option,...

Pei

Danny Wijnschenk <openm_at_pophost.eunet.be> wrote in article <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 Mon Jan 19 1998 - 00:00:00 CST