DIFFERENCE between Dimensional Modeling and Cube ?

View previous topic View next topic Go down

DIFFERENCE between Dimensional Modeling and Cube ?

Post  cube99 on Sun Sep 26, 2010 3:28 pm

Isnt cube part of Dimensional Modeling (Facts and Dimensions) ?

cube99

Posts : 2
Join date : 2010-09-26

View user profile

Back to top Go down

Re: DIFFERENCE between Dimensional Modeling and Cube ?

Post  ngalemmo on Mon Sep 27, 2010 12:09 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: DIFFERENCE between Dimensional Modeling and Cube ?

Post  Jeff Smith on Mon Sep 27, 2010 1:56 pm

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.





Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: DIFFERENCE between Dimensional Modeling and Cube ?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum