Friday, September 28, 2007

 

Multidimensional Data Model


Multidimensional data model is to view it as a cube. The cable at the left contains detailed sales data by product, market and time. The cube on the right associates sales number (unit sold) with dimensions-product type, market and time with the unit variables organized as cell in an array.

This cube can be expended to include another array-price-which can be associates with all or only some dimensions.

As number of dimensions increases number of cubes cell increase exponentially.

Dimensions are hierarchical in nature i.e. time dimension may contain hierarchies for years, quarters, months, weak and day. GEOGRAPHY may contain country, state, city etc.





Data WareHousing

Labels:


# posted by Kunal @ 9:54 PM
  • Share It: Digg Del.icio.us Furl Reddit Netscape
    • Comments:
    Hi, all this is avneesh pandey. I am persuing btech(I.T )4th year from IPEC ghaziabad. This is really a good content
    # posted by Blogger avneesh.pandey : October 1, 2009 at 2:04 AM
     
    This comment has been removed by the author.
    # posted by Blogger Unknown : February 19, 2010 at 6:53 AM
     
    Its a good example Kunal.. keep posting a lots.. i am just now starting with those DWH concepts.. Just lemme know if i can refer any book for studying all DWH concepts.
    # posted by Blogger Unknown : February 19, 2010 at 6:54 AM
     
    hi this is kalai, the picture is correct we r expecting the more information
    # posted by Blogger Unknown : May 24, 2010 at 3:07 PM
     
    Post a Comment

    Subscribe to Post Comments [Atom]





    << Home

    This page is powered by Blogger. Isn't yours?

    Subscribe to Posts [Atom]