Various Datawarehousing Tools

The various tools that are used for Data Warehousing are as follows:

• Database,Hardware
• ETL (Extraction,Transformation and Load)
• OLAP
• Reporting
• Metadata

Database/Hardware :There are several factors that needs to be considered.
They are as follows:

• Scalability: The Data Warehouse system is a centralised system which is used to large amount of data.The data storage is quite enormous।The system should be selected in such a manner that it can handle large amount of data efficiently

• Parallel Processing Support: Today's powerful computers utilize multiple CPU's where in each of the process can perform apart of the task,all at the same time
  

• RDBMS/Hardware Combination: The RDBMS physically resides n the hardware platform,so the choice of the RDBMS should be based on the efficencyof the hardware to handle enormous data
  

RDBMS: Its a Relational Database Management System which stores the data in the form of related tables and they are very powerful because its requires few assumptions the way in which the data is related and they are extracted from the database

Few of the popular Relational Databases and OS platforms are listed below:

Relational Databases

• Oracle
• Microsoft Sql Server
• IBM Db2
• Teradata
• Sybase
• MySql

OS Platforms

• Linux
• FreeBSD
• Microsoft