Translate

Data warehousing Architecture

Saturday, January 26, 2013

What is a Data Warehouse

It is a central repository of data which is created by integrating data from one or more disparate sources. Data warehouses store current as well as historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons.
The data stored in the warehouse are uploaded from the operational systems (such as marketing, sales etc., shown in the figure to the right). The data may pass through an operational data store for additional operations before they are used in the Data Warehouse for reporting.

No comments:

Sign up for PayPal and start accepting credit card payments instantly.