Columnstore index vs MOLAP

By Business Intelligist in Microsoft Business Intelligence, PowerPivot on
No comments

I have been trying to wrap my brain around the various options that Microsoft offers around near real-time analytical experience for the end users.  Clearly, a semantic model is needed to isolate the end from the complexity of SQL/Relational Data Warehouse.  So I see three options to explore:

  1. traditional MOLAP model for Analysis Services
  2. New Tabular mode for Analysis Services (uses xVelocity for compression and in-memory technology)
  3. multidimensional Analysis Services in ROLAP storage mode on top of a relational set of tables that use Columnstore index for compression and in-memory technology

I am particularly intrigued by #1 vs #3.  I have a pretty good data set available for some testing.  Hoping to be able to post some early results tomorrow.

Stay tuned 🙂

Tags: , , ,

Published by Business Intelligist

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s