What is Molap and Rolap?
multidimensional online analytical processing and relational online analytical processing. In MOLAP data is stored in form of multidimensional cubes. The advantages of this mode is that it provides excellent query performance and the cubes are built for fast data retrieval. All calculations are pre-generated when the cube is created and can be easily applied while querying data.In ROLAP, the data is stored in relational databases this model gives the appearance of traditional OLAPs slicing and dicing functionality. The advantages of this model is it can handle a large amount of data and can leverage all the functionalities of the relational database.