Chapter 15. xVelocity In-Memory Technologies
With the release of SQL Server 2008 R2, Microsoft delivered massive new Business Intelligence (BI) value in the form of PowerPivot, which brought column store technology to the Microsoft BI stack. Column stores organize data in a column-oriented fashion and use advanced algorithms to compress their data. The column store and compression technologies combine to allow even very large data models to fit entirely in memory, thus allowing for lightning-fast response times for analytical queries.
PowerPivot runs on the client PC as a Microsoft Excel add-In, and that’s great. But it also runs on Microsoft SharePoint as a true server, allowing for shared analysis of data models and, by way of a few ...
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.
