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.