3 Tier Data Warehouse Architecture Diagram. It consists of the Top, Middle and Bottom Tier. Bottom Tier: Data warehouse server Data Warehouse server fetch only relevant information based on data mining (mining a knowledge from large amount of data) request.
Business (tier) functionality is frequently exposed Three tier architecture is a concept not a step by step instructional.
Data Tier- The data tier comprises of the database/data storage system and data access layer.
If you are working with data storage and retrieval, put it. The following diagram depicts the three-tier architecture of data warehouse Data Warehouse - Fundamentals. Usually, data warehouse adapts the three-tier architecture.







