In Chapter 3, Building Data Models, we looked at the process of building a data model in some detail. In this section, we will revisit some of the topics we covered, along with what we have just learned about the workings of the VertiPaq engine. Using this combined knowledge, we will focus on some of the ways in which we can optimize the overall memory requirements of our data models and improve performance.
As we saw in the previous section, VertiPaq's ability to compress data is dependent on several factors. As such, there are some elements that you need to consider when building a data model that will have a direct impact on the efficiency of the compression algorithms. These include the following:
- The cardinality of values in a column. This affects VertiPaq's ability to reduce the number of bits used to store a value. If a column has...
