Chapter 12. Inside VertiPaq

In Chapter 1, “Introducing the tabular model,” you saw that the tabular model can execute a query by using an in-memory analytics engine or by translating the MDX or DAX query into one or more SQL queries. The former uses a storage engine called VertiPaq, whereas the latter uses DirectQuery. This chapter is dedicated to the internal architecture of the VertiPaq engine, which is the in-memory columnar database that stores and hosts tabular models.

Before reading this chapter, you need to be aware of the following two facts:

Image Implementation details change often. We did our best to show information at a level that is not ...

Get Tabular Modeling in Microsoft SQL Server Analysis Services, Second Edition 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.