If you can remember my last blog post , SSAS tabular has two architectures to store data either DirectQuery or In-memory mode. Today in this blog post I’m going to discuss more detail about in-memory or Vertipaq engine. In reality, SSAS tabular database engine can get requests from the client either MDX or DAX query. Inside the Tabular database it contains two layers of calculation engines, Formula Engine: Whenever a new request coming from the client despite its DAX/MDX, from Analysis services it parse and transforming them in query plans and finally execute them by formula engine. Storage Engine: To perform calculations , from formula engine it performs one or more requests to the storage engine where the data is stored, which could be either in-memory (Vertipaq) engine or external relational engine (directQuery) depending on the mode you are using to build the model. In this post I'm mainly focus on Vertipaq Engine. It has a copy of data read from the data source ...
A journey towards the AI space