DBDB.io The Encyclopedia of Database Systems · Est. 2017
Database of Databases

Database Entry

Vector


Country of Origin
NL
Former Names
Vectorwise, MonetDB/X100
Acquired By
Project Type
Commercial
Supported Languages
SQL
Derived From
MonetDB
Operating Systems
Linux, Windows
License
Proprietary

Database Entry

Vector


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.

Concurrency Control[06][07]


Data Model[04]


Foreign Keys[08]


Hardware Acceleration[09]


Vector makes use of SIMD operations on modern CPUs to accelerate query processing.

Isolation Levels[10]


Joins[11][12]


Storage Model[04][13]


Vector uses an adaptive storage model based on PAX partitions. By default, Vector stores tables in columnar model. Nullable attribute has a boolean type column which is stored together with the attribute column. However, if there exists an index where the key spans multiple attributes, these columns are grouped together and stored in the same block. For small tables, user can instruct Vector to store data in n-ary model to reduce wasted space.

Views[14]


Citations

14 sources
  1. Actian Ingres | Ingres Transactional Database actian.com
  2. Actian Vector - Wikipedia wikipedia.org
  3. Actian Vector actian.com
  4. https://www.actian.com/wp-content/uploads/2024/10/Actian-Vector-Datasheet.pdf actian.com
  5. Actian Vector actian.com
  6. Actian Vector actian.com
  7. Actian Vector actian.com
  8. Actian Vector actian.com
  9. Actian Vector actian.com Dead — Check Archive
  10. Actian Vector actian.com
  11. https://docs.actian.com/vector/4.2/index.html#page/User/Full_Sort_Merge_Node.htm# actian.com Dead — Check Archive
  12. https://docs.actian.com/vector/4.2/index.html#page/User/Hash_Join_Node.htm# actian.com Dead — Check Archive
  13. http://dare.ubvu.vu.nl/bitstream/handle/1871/39785/19953B.pdf?sequence=3 vu.nl Dead — Check Archive
  14. CREATE VIEW Statement of Ingres VectorWise actian.com
Revision #9