MOLAP: A more traditional way of OLAP analysis. Data is persisted in a multidimensional cube in MOLAP. The storage is in proprietary formats but not in the relational database. MOLAP data cubes are built in such a way that data retrieval is faster and are optimal for dicing and slicing operations.
ROLAP: A methodology that is relied on manipulating the persisted data in the relational database, for providing an appearance of traditional OLAP’s dicing and slicing functionality. The actions of slicing and dicing are equivalent to adding the ‘WHERE’ clause in the SQL statement, is the essential part of ROLAP. The amount of data is not limited by ROLAP itself, thus able to handle large amounts of data..
ROLAP: A methodology that is relied on manipulating the persisted data in the relational database, for providing an appearance of traditional OLAP’s dicing and slicing functionality. The actions of slicing and dicing are equivalent to adding the ‘WHERE’ clause in the SQL statement, is the essential part of ROLAP. The amount of data is not limited by ROLAP itself, thus able to handle large amounts of data..
No comments:
Post a Comment