Architecture of Data Warehouse in Foundation of Data Science

 Define Architecture of Data Warehouse

        Data Warehouse is the heterogeneous collection of different data sources organised under a unified scheme. There are 2 approaches for constructing Data Warehouse.

Types

• Top - Down approach
• Bottom - UP approach

Top - Down approach

Essential Components are

• External source
• Stage Area
• Data Warehouse
• Data Mart
• Data Mining

External Source

        External source is a source from where data is called irrespective of the type of data .Data can be structured  semi structured and unstructured as well.

Stage Area  

        Since the data extracted from the external sources does not follow a particular format , So there is need to validate this data to load Data warehouse. For this purpose , it is recommended to use ETL (Extract Transform Loading) .

• Extracted

               Data is extracted from external data source.

• Transform

                Data is transformed into the standard format.

• Load

                Data is loaded into data warehouse after transforming , It into the Standard format.

Data Warehouse

        After cleaning of data , It stored in the data warehouse as content responding. It actually stores  the meta data and the actual data gets stored in the data marts.

Data Marts

         Data Marts is also a part of storage components .It stores the information of a particular function. We can also say that data marts contains subset of a data stored in data warehouse.

Data Mining

       The package of analysis the big data present in data warehouse is data mining. It is used to find the hidden patterns that are present in the database or in data warehouse with the help of algorithms of data mining.  

Bottom - Up approach

             A source file are different data format they are goes into the ETL (Extract Transform  Loading) . It can be divided into various source form , it comes under the data mart into different sector. Then it will be under the Data warehouse  to cleaning, fetching the given data and goes into the Data mining process. This process is called Bottom - Up approach .