dwhtesting's profile picture.

Srikanth Reddy

@dwhtesting

ROLAP Disadvantages :- Poor query performance. Some limitations Front end tool Specialized SQL Servers


ROLAP Advantages :- servers are highly scalable. Existing RDBMS. No zero facts can be stored. Do not use pre-calculated data cubes.


Relational OLAP Architecture

dwhtesting's tweet image. Relational OLAP Architecture

Relational OLAP Architecture :- Database Server ROLAP Server


OLAP Operations :- Roll-up Drill-down Slice and dice Pivot (rotate)


Types of OLAP Servers :- Relational OLAP(ROLAP) Multidimensional OLAP (MOLAP) Hybrid OLAP (HOLAP)


Bottom Tier :- The bottom tier of the architecture is the data warehouse database server.It is the relational database system


3.Hybrid OLAP (HOLAP)- is a combination of ROLAP and MOLAP. which are other possible implementations of OLAP


2.Multidimensional OLAP (MOLAP)-which directly implements multidimensional data and operations.


1.Relational OLAP (ROLAP) - which is an extended relational database management system.


Middle Tier :- Middle tier we have OLAP Server.


Top-Tier :-This tier is the front-end client layer.This layer hold the query tools and reporting tool, analysis tools and data mining tools.


Data Warehouse Architecture ( Three-Tier Arch ):- Top-Tier Middle Tier Bottom Tier

dwhtesting's tweet image. Data Warehouse Architecture ( Three-Tier Arch ):-

Top-Tier 
Middle Tier
Bottom Tier

DWH Architecture:- we are having 3 kinds of architecture for DWH. 1.Centralized Architecture 2.Fedarated Arch 3.Tiered Arch


Enterprise Warehouse:-The enterprise warehouse collects all the information all the subjects spanning the entire organization.


Data mart:- Data mart contains the subset of organization-wide data.


Virtual Warehouse :- The view over a operational data warehouse is known as virtual warehouse. It is easy to built the virtual warehouse.


Data Warehouse Models :- Virtual Warehouse Data mart Enterprise Warehouse


Why we need DWH :- Integrate Data From Multiple Diverse Source Allow for Analysis of data over time Provide ad-hoc Querying, Reporting


هذا الحساب ليس لديه متابعون بعد

United States الاتجاهات

Loading...

Something went wrong.


Something went wrong.