Architecture of ROLAP

 

Doing Analysis using a tool with the RDBMS data, we call it as ROLAP

 

When a report is executed by end user the actual SQL is issued to RDBMS to get
the data. Some BI tools can even store the results set in the application server and
periodically refresh that report based on the data refreshes which happen in DW.