xVelocity for Analysis: PowerPivot and SSAS Tabular Models

In the last section we focused pretty heavily on the inner workings of xVelocity column store and compression technology. In this section, we will move away from that level of discussion, and discuss the specially purposed analytical database technology that xVelocity also supports. Rest assured that the same clever technology is there, under the covers, but the specifics of it are less important. Instead, the extra capabilities and features that result are important.

As we mentioned earlier, PowerPivot is based on SSAS. But instead of using the conventional SSAS multidimensional storage and execution engine, PowerPivot uses xVelocity in-memory technologies to enable a new column store ...

Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.