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

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_____