Relational OLAP

Posted By on March 20, 2016

Download PDF
OLAP and OLAP Servers
Multidimensional OLAP

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 includes the following:

  • Implementation of aggregation navigation logic
  • Optimization for each DBMS back-end
  • Additional tools and services

Points to Remember

  • ROLAP servers are highly scalable.
  • ROLAP tools analyze large volumes of data across multiple dimensions.
  • ROLAP tools store and analyze highly volatile and changeable data.

Relational OLAP Architecture

ROLAP includes the following components:

  • Database server
  • ROLAP server
  • Front-end tool.

Rolap Architecture


  • ROLAP servers can be easily used with 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 micro-strategy adopts the ROLAP approach.


  • Poor query performance.
  • Some limitations of scalability depending on the technology architecture that is utilized.
OLAP and OLAP Servers
Multidimensional OLAP

Download PDF

Posted by Virat Fichadiya