Saturday 12 September 2015

Data Warehouse

                                                    DATA WAREHOUSING


Data Warehouse is a nothing but a system that is used to maintain database of various types  of sources that are for example marketing sector, sales,etc. This is also used to maintain more data that is analysed by various data sources. Data Warehouse provides flexible access to data in particular manner by which the user can access data.It is also refers to combination of databases contrast with data mart. data mart is collection for databases that provides access to particular user for there business skills in a single approach.This also provides a special historical data maintenance which is useful for newest businessmen s.
                                           


       
                                         Above  diagram in dictates about the data transmission for storing in data warehouse data sources A,B and C are connected to ETL that is stands for Extraction Transformation Loading this is placed at the middle of data warehouse and other databases this is also provides transmission, staging, interaction of data and access layer to the house.
the databases A,B and C are nothing but the operational systems.after data warehouse there is data mart & strategic mart are also connected this are access layers to get data out to user by this strategic mart & data mart data from data warehouse is get to the user after analysis in this way data warehousing is worked.