Dwh 简明教程

Data Warehousing - Relational OLAP

关系 OLAP 服务器位于关系后端服务器和客户端前端工具之间。为了存储和管理仓库数据，关系 OLAP 使用关系或扩展关系 DBMS。

Relational OLAP servers are placed between relational back-end server and client front-end tools. To store and manage the warehouse data, the relational OLAP uses relational or extended-relational DBMS.

ROLAP 包括以下内容 -

ROLAP includes the following −

  1. Implementation of aggregation navigation logic

  2. Optimization for each DBMS back-end

  3. Additional tools and services

Points to Remember

  1. ROLAP servers are highly scalable.

  2. ROLAP tools analyze large volumes of data across multiple dimensions.

  3. ROLAP tools store and analyze highly volatile and changeable data.

Relational OLAP Architecture

ROLAP 包含以下组件 −

ROLAP includes the following components −

  1. Database server

  2. ROLAP server

  3. Front-end tool.

rolap architecture

Advantages

  1. ROLAP servers can be easily used with existing RDBMS.

  2. Data can be stored efficiently, since no zero facts can be stored.

  3. ROLAP tools do not use pre-calculated data cubes.

  4. DSS server of micro-strategy adopts the ROLAP approach.

Disadvantages

  1. Poor query performance.

  2. Some limitations of scalability depending on the technology architecture that is utilized.