DIFFERENCE between Dimensional Modeling and Cube ?
3 posters
Page 1 of 1
DIFFERENCE between Dimensional Modeling and Cube ?
Isnt cube part of Dimensional Modeling (Facts and Dimensions) ?
cube99- Posts : 2
Join date : 2010-09-26
Re: DIFFERENCE between Dimensional Modeling and Cube ?
Dimensional modeling concepts are applicable wither implementing the model in a cube or a relational database. The only differences are in physical implementation.
There are limitations in a cube (multidimensional database, or MDDB) that are not an issue in a relational implementation. Cubes tend to be more focused and at a higher level of detail. Also some MDDB implementations do not allow queries against more than one cube. As such, cubes are not suitable for an integrated enterprise repository and are typically used to address departmental analytics and are usually sourced from a relational based enterprise dimensional warehouse.
There are limitations in a cube (multidimensional database, or MDDB) that are not an issue in a relational implementation. Cubes tend to be more focused and at a higher level of detail. Also some MDDB implementations do not allow queries against more than one cube. As such, cubes are not suitable for an integrated enterprise repository and are typically used to address departmental analytics and are usually sourced from a relational based enterprise dimensional warehouse.
Re: DIFFERENCE between Dimensional Modeling and Cube ?
Isn't the traditional role of a cube to be used in analysis where as reports usually come from databases? I'm simplifying because a person can create a report from a cube and perform analysis using a relational database, but the performance of a cube is usually better than the database and creating complex reports is easier from a relational database.
Also, most cubes can't handle a lot of detail so even when using a cube for analysis there may be a need to drill back into the detailed data of the relational database.
Also, most cubes can't handle a lot of detail so even when using a cube for analysis there may be a need to drill back into the detailed data of the relational database.
Jeff Smith- Posts : 471
Join date : 2009-02-03
Similar topics
» Modeling cube for monitoring a process
» Dimensional Model with different granularity to Cube
» Ad Hoc Reports Against Cube or Dimensional Model
» SAPBW and Dimensional Modeling
» Dimensional Modeling-Checklist
» Dimensional Model with different granularity to Cube
» Ad Hoc Reports Against Cube or Dimensional Model
» SAPBW and Dimensional Modeling
» Dimensional Modeling-Checklist
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum