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
|
|
|
Friday, January 23, 2015
Multidimensional vs Tabuar model difference(Sql server 2012)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment