Tuesday 23 December 2014

THREE TIER DATA WAREHOUSE ARCHITECTURE

Three-Tier Data Warehouse Architecture

Generally the data warehouses adopt the three-tier architecture. Following are the three tiers of data warehouse architecture.
·         Bottom Tier - The bottom tier of the architecture is the data warehouse database server. It is the relational database system. We use the back end tools and utilities to feed data into bottom tier. These back end tools and utilities perform the Extract, Clean, Load, and refresh functions.
·         Middle Tier - In the middle tier we have OLAP Server. The OLAP Server can be implemented in either of the following ways:
o   By relational OLAP (ROLAP), which is an extended relational database management system, the ROLAP maps the operations on multidimensional data to standard relational operations.
o   By Multidimensional OLAP (MOLAP) model, which directly implements multidimensional data and operations.
·         Top-Tier - This tier is the front-end client layer. This layer holds the query tools and reporting tool, analysis tools and data mining tools.
o   Query and reporting Tools
o   Analysis Tools
o   Data Mining Tools

Following diagram explains the Three-tier Architecture of Data warehouse:

No comments:

Post a Comment