O'Reilly logo

Programming Microsoft® SQL Server® 2012 by Leonard Lobel and Andrew Brust

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required