Inside xVelocity InMemory Engine (VertiPaq)
The xVelocity engine in SQL Server Analysis
Services 2012 Tabular is a columnar database capable of incredible performances,
both in speed and compression ratio. In this session, we will perform a deep
dive in the internals of the database architecture, discovering how Vertipaq
stores information, in order to gain better insights into the engine and
understand the best way to model your data warehouse to leverage the features
of VertiPaq. We will show common and useful techniques to increase the
compression ratio and obtain better performances from your Tabular data model.
Alberto Ferrari is a Business Intelligence consultant. Alberto helped several software houses to build complex BI solutions, from the OLTP to the final OLAP cubes, providing planning hints all over the development lifecycle. He is a book author also, having worked on "Exper Cube Development with Microsoft SQL Server 2008" with Marco Russo and Chris Webb and Microsoft PowerPivot for Excel 2010: Give Your Data Meaning with Marco Russo.
The video is not available to view online.