Data Warehousing

 Jayanth Kumar
1st Sem BCA, NCMS

Data warehousing is the process of constructing and using a data warehouse. A data warehouse is constructed by integrating data from multiple heterogeneous sources that support analytical reporting, structured and decision making. Data warehousing is the electronic storage of a large amount of information by a business or organization.

Tools:-

            * Amazon Redshift

            *Microsoft Azure

            * Google Big Query

            *Snowflake

            *Teradata

Types:-

            1.Enterprise data warehouse.

            2.Offline Data Warehouse.

            3.Real time data warehouse.

            4.Integrated data warehouse.

Advantages:-

            *Speedy data retrieving

            *Error Identification and correction

            * Easy integrations

Disadvantages:-

*Time consuming preparation

*Difficulty in compatibility

* Maintenance Costs.

Steps to Data warehousing

1. Determine Business Objectives

2. Collect and Analysis Information

3. Identify core Business processes

4. Set Tracking Duration

5. Implement the plan