which database to choose as data warehouse?

So the company you worked has decided to have a data warehouse.The big question is to choose the right database.Although there are numerous databases in market the choice depend on various factors.

1. Price : If you are planning to have huge data warehouse the best choice is to have database like teradata which can handle huge amount of data with ease.The concern here will be price.Teradata comes with its own hardware so total cost builds up.

2. Ease of use: Db2 and Oracle are the most user friendly databases available.The amount of computer professionals and tech support avialable for these databases is huge.

3. ETL features : If you choose certain tools like informatica for ETL it is good choice to have oracle as database.

So far in my career I had seen these databases used mostly
1. DB2
2. Oracle
3. Teradata
4. Sybase

Please post your comment as it encourages me to write more.


Offbeat topic : What is google page rank