Re: Data warehouse hardware

craywa_at_yahoo.com (M. Brooks) wrote in message news:<527c8b44.0205280922.c358b6a_at_posting.google.com>...

> Our current environment:
>
> OS -> Solaris, AIX, W2K
> STORAGE -> IBM Shark, EMC
> DBMS -> Oracle, SQLServer, Sybase
>
> We are looking at hardware / database options for a data warehouse
> with an initial load size of 3 - 5TB growing to 70TB.

As I've already said, as OS platform choose the one with most skilled technical staff in your organization. I do not know demands on your DWA, but DWAs are usually quite popular systems and load can be very high. Good unix root is must have if your system will work under big pressure. So use Solaris or AIX, both of them can do a good job as platform for database.
Choice of RDBMS from this list is very easy, Oracle is the only one of these, which can perform well in terms of stability, scalability and performance. You can also use DB2, but I do not think that is a good idea to use a database, which isn't already used in you company. Sizing of server depends on your future needs and is more dependent on workload than on database size.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.