Columnstore index vs MOLAP

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 🙂

Leave a Reply

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

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

Facebook photo

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

Connecting to %s