- Developer
- Country of Origin
- NL
- Former Names
- Vectorwise, MonetDB/X100
- Acquired By
- Project Type
- Commercial
- Supported Languages
- SQL
- Derived From
- MonetDB
- License
- Proprietary
Checkpoints[03]
Vector uses blocking consistent checkpoints. The system waits for all running transactions to finish before taking a new checkpoint. Any new transaction is blocked until the checkpoint is completed.
Compression[04][05]
Vector compresses each column on a per-page basis for better compression performance. Thus different pages of the same column may be compressed using different algorithms. For the page-level naïve compression, Vector uses LZ4 to compress string values.
Hardware Acceleration[09]
Vector makes use of SIMD operations on modern CPUs to accelerate query processing.
Storage Model[04]
Because Vector targets analytical workload, Vector stores tables in columnar model by default. However, if there exists an index where the key spans multiple attributes, these columns are grouped together and stored in the same block. User can instruct Vector to store data in n-ary model.
Citations
13 sources- Actian Ingres | Ingres Transactional Database actian.com
- Actian Vector - Wikipedia wikipedia.org
- Actian Vector actian.com
- https://www.actian.com/wp-content/uploads/2024/10/Actian-Vector-Datasheet.pdf actian.com
- Actian Vector actian.com
- Actian Vector actian.com
- Actian Vector actian.com
- Actian Vector actian.com
- Actian Vector actian.com
- Actian Vector actian.com
- https://docs.actian.com/vector/4.2/index.html#page/User/Full_Sort_Merge_Node.htm# actian.com
- https://docs.actian.com/vector/4.2/index.html#page/User/Hash_Join_Node.htm# actian.com
- CREATE VIEW Statement of Ingres VectorWise actian.com