Data Warehouse Architecture Case Study

1664 Words7 Pages
Introduction Data warehouse architecture is the base of data warehouse. Three major areas of data warehouse architecture are data acquisition, data storage and information delivery. Data acquisition refers to data extraction from various source systems, data transformation in data staging area and preparation for loading data in data storage. Data storage is responsible for loading data from data staging area to data warehouse. Information delivery is responsible for delivering the information to data warehouse users. There are various types of architecture such as centralised data warehouse architecture, independent data mart architecture, federated architecture, hub-and-spoke architecture, data-mart bus architecture. Choosing the right architecture…show more content…
They will also know about the various types of data warehouse architecture. 3.1.1 Data Warehouse Architecture We have already known about basic components of a data warehouse. Data Warehouse architecture is comprised of the data warehouse components, some rules, procedures and functions which assist the work flow of data warehouse and fulfil some business objectives. As shown in the figure 3.1.1, data acquisition, data storage and information delivery are three major areas in the data warehouse architecture. Figure 3.1.1: Three major areas of data warehouse architecture Data warehouse architecture must be able to provide large amount of data to users. Architecture should store data by business subjects. Architecture should support complex analysis to provide strategic information. Architecture should be flexible enough to add additional…show more content…
o Data acquisition includes extraction of data from various sources, moving of data into data staging area, cleanliness of data, transformation of data and preparation of data for loading into data warehouse. o In data acquisition, data flow starts from sources and stops at data staging area. o Data storage includes the loading process of data from data staging area to data warehouse. Data flow begins at data staging area. o Information delivery provides the data warehouse information to data warehouse users. o Data flow starts from data warehouse and data marts if top-down approach is followed by architecture. Data flow starts from set of conformed data mart if bottom-up approach is followed by architecture. o Management and control component manages and controls data acquisition, data storage and information delivery area. o The types of architecture varies in the data integration and storing process and the way data warehouse and data marts are related. o In centralised data warehouse architecture, a centralised data warehouse exists. No dependent or independen data marts are there in this type of

More about Data Warehouse Architecture Case Study

Open Document