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
References
Data warehouse architectures Wikipedia(Text) CC BY-SA