A data warehouse can be thought of a repository where the data GENERATED from the company’s systems and other sources is collected and stored. So a data warehouse has three-tier ARCHITECTURE:

• In the bottom tier, we have the tools which cleanse and collect the data.
• In the middle tier, we have tools which transform the data using Online Analytical Processing Server.
• In the top tier, we have different tools where data analysis and data mining is performed at the front end.

Setting up and managing a data warehouse involves a lot of money as the data in an ORGANIZATION continuously increases and the organization has to continuously upgrade their data storage servers. So here AWS RedShift comes into existence where the companies store their data in the cloud-based warehouses provided by AMAZON.

A data warehouse can be thought of a repository where the data generated from the company’s systems and other sources is collected and stored. So a data warehouse has three-tier architecture:

Setting up and managing a data warehouse involves a lot of money as the data in an organization continuously increases and the organization has to continuously upgrade their data storage servers. So here AWS RedShift comes into existence where the companies store their data in the cloud-based warehouses provided by Amazon.