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.
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.