Pages

Thursday, March 21, 2013

Data Warehouse Architecture (Basic)

Simple architecture for a data warehouse. End users directly access data derived from several source systems through the data warehouse.


















The metadata and raw data of a traditional OLTP system is present, as is an additional type of data, summary data. Summaries are very valuable in data warehouses because they pre-compute long operations in advance. For example, a typical data warehouse query is to retrieve something like August sales.

No comments:

Post a Comment