Data warehouse architectures

The technical architecture of data warehouses is somewhat similar to other systems, but does have some special characteristics. There are two border areas in data warehouse architecture - the single-layer architecture and the N-layer architecture. The difference here is the number of middleware between the operational systems and the analytical tools. The data warehouse architecture described here is a high level architecture and the parts in the architectures mentioned are full bodied systems and not system-parts.

Components of Data Warehouse Architecture

° Source Data Component

 1. Production Data
 2. Internal Data
 3. Archived Data
 4. External Data

° Data Staging Component

 1. Data Extraction
 2. Data Transformation
 3. Data Loading

° Data Storage Component

° Information Deliver Component

° Metadata Component

° Management and Control Component