Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

DIFFERENCE between Dimensional Modeling and Cube ?

3 posters

Go down

DIFFERENCE between Dimensional Modeling and Cube ?  Empty DIFFERENCE between Dimensional Modeling and Cube ?

Post  cube99 Sun Sep 26, 2010 3:28 pm

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

cube99

Posts : 2
Join date : 2010-09-26

Back to top Go down

DIFFERENCE between Dimensional Modeling and Cube ?  Empty Re: DIFFERENCE between Dimensional Modeling and Cube ?

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

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

http://aginity.com

Back to top Go down

DIFFERENCE between Dimensional Modeling and Cube ?  Empty Re: DIFFERENCE between Dimensional Modeling and Cube ?

Post  Jeff Smith 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

Back to top Go down

DIFFERENCE between Dimensional Modeling and Cube ?  Empty Re: DIFFERENCE between Dimensional Modeling and Cube ?

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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