Database Reference
In-Depth Information
At the same time, PowerPivot for SharePoint allows IT professionals to monitor the
models that business users create.
Both PowerPivot for Excel and PowerPivot for SharePoint use the same in-memory
technology developed by the Analysis Services team called
xVelocity in-memory
analytical engine
(previously called
Vertipaq
).
The xVelocity in-memory analytical engine is a tabular model, meaning that instead
of working with a multidimensional model, it works with tables and relations. The in-
memory engine delivers extreme performance; customers have reported that they
have seen performance benefits of up to 100x compared to normal SQL queries.
Internally, the xVelocity engine is storing data in a columnar storage mode. Instead of
storing all the columns of a row together, it stores each column separately together
with an identifier that identifies the row it belongs to, as shown in the following
screenshot:
Search WWH ::
Custom Search