Friday, January 23, 2015

Multidimensional vs Tabuar model difference(Sql server 2012)


Tabular
Multidimensional
In memory technology
Pre aggregated data
Can store large amount of data
Can store very large amount of data
No agreegation, column based storage
Uses agreegate to increase performance
Data compression 10X
Data compression 3x
Tablular will be faster at low Granularity
Its faster since aggregated
Data is less in gb
Data in terra bytes
Far less time to develop
Requires lot of planning
No dimensional modeling required
Dimensional modeling required
 
Upgrade from a power pivot
No upgrade path
Hierarchy creation is easy
Duplicate attribute key- create a key column
 
 

No comments:

Post a Comment