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

I have worked with Terabyte sized databases. My shop had a datawarehouse in a single database nearly 1TB. We also had hundreds (literaly) of operational databases distributed nationally. In total, I managed about 3+ TB. We used Informix Dynamic Server on all our Unix servers, primarily Sun Enterprise Servers.

All the major DB vendors offer a good solution, including Oracle, Informix, Sybase, and IBM's DB2. The choice of vendor is a difficult decision that can be based on many factors. Consider such selection criteria such as vendor viability, vendor support, packaged applications available to run on specific databases, scalability, ease of maintenance and DBA support required, performance requirements, TP vs DSS performance, availability of support personnel - DBA's and application developers, UNIX versus NT requirements, vendor preferences and relations, and many more depending upon your environment.

Eric Margheim <ericm_at_socket.net> wrote in article <34bd383f.0_at_news.socket.net>...
> We are about to start development of an application that will potentially
> have a database size of over 100GB. We are trying to decide what
 platform,
> O/S, and database to use.
>
> If anyone has experience in development with a database of this size, I'd
 be
> interested in hearing you opinions on what has worked and not worked for
> you.
>
> Thanks
>
> Eric Margheim
> ericm_at_socket.net
>
>
>
Received on Thu Jan 15 1998 - 00:00:00 CST