ActivePivot is a distributed, in-memory DBMS designed for HTAP workloads. It uses a columnar storage architecture with dictionary compression and binary representation of Java objects.
ActivePivot supports queries through Multidimensional Expressions (MDX) either through ActiveUI or any another MDX-compliant interface.
Multi-version Concurrency Control (MVCC)
The system allows for multiple versions of a database. For example, there can be one version that continuously gathers incoming data, and another version from an earlier point in time for analysis.
Decomposition Storage Model (Columnar)
Data is stored in columns with no additional row-based storage.
ActivePivot uses bitmap indexing which can support upwards of 100 dimensions.
All servers act independently and do not have access to the information contained on other servers. Data can be distributed between servers based on the values of a given attribute. For example, if one of the attributes is city then the data can be distributed based on geographic regions.
Activepivot uses both dictionary encoding and Java primitives for compression.
Dictionary Compression: When there is a small number of distinct values for an attribute, the attributes can be encoded into an integer from 1 to N where N denotes the total number of distinct values by using a dictionary that stores the distinct values.
Java Primitives: Instead of storing integers as Java Integer objects, ActivePivot stores these as primitives. The number of bits stored for each number is based on the range of possible values. For example, if the values in a column are given to be between 0 and 256 then the system would only store 8 bits per number. This form of compression can be combined with dictionary compression
When a server receives a query, it also sends the query out to the other servers. Once it receives a response from all the servers it aggregates all of the information and returns the result.