Data Warehousing - Relational OLAP



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

ROLAP includes the following.

  • implementation of aggregation navigation logic.

  • optimization for each DBMS back end.

  • additional tools and services.

Note: The ROLAP servers are highly scalable.

Points to remember

  • The ROLAP tools need to analyze large volume of data across multiple dimensions.

  • The ROLAP tools need to store and analyze highly volatile and changeable data.

Relational OLAP Architecture

The ROLAP includes the following.

  • Database Server

  • ROLAP Server

  • Front end tool


  • The ROLAP servers are highly scalable.

  • They can be easily used with the existing RDBMS.

  • Data Can be stored efficiently since no zero facts can be stored.

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

  • DSS server of microstrategy adopts the ROLAP approach.


  • Poor query performance.

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