×

Related Topics

☰ Related Topics

Data Warehouse Architecture

Data warehouses and their architectures vary depending upon the situation:-


1. Three-Tier Data Warehouse Architecture


Data warehouses often adopt a three – tier architecture,

1 Bottom tier

2 Middle tier

3 Top tier

Data Warehouse Architecture in Data Mining : last night study

Data Warehouse Architecture

1 Bottom tier

The bottom tier of the architecture is the data warehouse database server.It is the relational database system. Data is feed into bottom tier by some back-end tools and utilities.

Function performed by back end tools and utilities are:-

1 Data Extraction

2 Data Cleaning

3 Data Transformation

4 Load

5 Refresh

2 Middle tier

The middle tier is an OLAP server present user a multidimensional data from data warehouse.Middle tier is an OLAP server can be implemented using either relational OLAP (ROLAP) model or multidimensional OLAP (MOLAP) model.

Relational OLAP (ROLAP) model:-

ROLAP is an extended relational database management system. The ROLAP maps the operations on multidimensional data to standard relational operations.

Multidimensional OLAP (MOLAP) model:-

MOLAP directly implements multidimensional data and operations.

3 Top tier

The top tier is a front-end client layer.

The top tier layer holds following tool:-

Query and Reporting tools - Production reporting tool.

Analysis tools - Prepare charts based on analysis.

Data mining tools - Discover hidden knowledge, pattern.


2. A Business Analysis Framework


Data warehouse provide critical information to business analyst to measure performance of business and help in the process of decision-making.With data warehouse business productivity can be enhance because business analyst can quickly gather information that describes the organization.

Data warehouse provide customers view which help to improve customer relationship.Data warehouse can also help in cost reduction by tracking trends and patterns.

Different data warehouse views:-

Top-down view

Top-down view allow the selection of the relevant information necessary for the data warehouse.

Data source view

Data source view presents information being captured, stored, and managed by operational systems.This information may be documented at various levels of detail and accuracy, from individual data source tables to integrated data source tables.

Data warehouse view

Data warehouse view includes fact tables and dimension tables.This view represents the information that is stored inside the data warehouse.

Business query view

Business query view is view of data in the data warehouse from the viewpoint of the end user.


Related Topics

What is Data Warehouse

Data Warehouse Feature

Differences between Operational Database Systems and Data Warehouses

Was this answer helpful?

Yes
No

- - END - -

Next Topics

Next Topics