Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Difference between ROLAP and MOLAP
- Thread starter Sharma999
- Start date
AndyHiggins
Programmer
Look here for the definition.
ROLAP means that the storage type for the OLAP cube is relational. This forces the aggregations to be driven from the database itself. In general this allows for quicker cube build times, but greater query times. This also forces you to have access to the relational database to view the cube details.
MOLAP means that all of the aggregations are stored in the OLAP cube. This allows for quicker query times but slower cube builds. It also means that you can view the cube details while not connected to the DB.
A combination (hybrid) of the two, HOLAP, is also available. This allows you to utilize benefits from both of the previous types.
flex
MOLAP means that all of the aggregations are stored in the OLAP cube. This allows for quicker query times but slower cube builds. It also means that you can view the cube details while not connected to the DB.
A combination (hybrid) of the two, HOLAP, is also available. This allows you to utilize benefits from both of the previous types.
flex
- Status
Similar threads
- Locked
- Question
- Locked
- Question