Actian Vector

Technology

The basic architecture and design principles of the X100 engine of the VectorWise database were well described in two Phd theses of VectorWise founders Marcin Żukowski: "Balancing Vectorized Query Execution with Bandwidth-Optimized Storage" and Sandor Héman: "Updating Compressed Column Stores", under supervision of another founder, professor Peter Boncz. The X100 engine was integrated with Ingres SQL front-end, allowing the database to use the Ingres SQL syntax, and Ingres set of client and database administration tools.{{cite journal | access-date = 7 February 2016 | archive-date = 3 March 2016 | archive-url = https://web.archive.org/web/20160303215147/http://www.sigmod.org/publications/sigmod-record/1109/pdfs/08.industry.inkster.pdf | url-status = dead

The query execution architecture makes use of "Vectorized Query Execution" processing in chunks of cache-fitting vectors of data. This allows to involve the principles of vector processing and single instruction, multiple data (SIMD) to perform the same operation on multiple data simultaneously and exploit data level parallelism on modern hardware. It also reduces overheads found in traditional "row-at-a-time processing" found in most RDBMSes.

The database storage is in a compressed column-oriented format, | access-date = 4 May 2012}} with scan-optimised buffer manager. In Actian Vortex in HDFS the same proprietary format is used.

Loading big amounts of data is supported through direct appends to stable storage, while small transactional updates are supported through patent-pending Positional Delta Trees (PDTs) specialized B-tree-like structures of indexed differences on top of stable storage, which are seamlessly patched during scans, and which are transparently propagated to stable storage in a background process. The method of storing differences in patch-like structures and rewriting the stable storage in bulk made it possible to work in a filesystem like HDFS, in which files are append-only.

History

A comparative Transaction Processing Performance Council TPC-H performance test of MonetDB carried out by its original creator at Centrum Wiskunde & Informatica (CWI) in 2003 showed room for improvement in its performance as an analytical database. As a result, CWI researchers proposed a new architecture using pipelined query processing ("vectorised processing") to improve the performance of analytical queries. This led to the creation of the "X100" project, with the intention of designing a new kernel for MonetDB, to be called "MonetDB/X100".

The X100 project team won the 2007 DaMoN Best Paper Award for the paper "Vectorized Data Processing on the Cell Broadband Engine" as well as the 2008 DaMoN Best Paper Award for the paper "DSM vs. NSM: CPU Performance Tradeoffs in Block-Oriented Query Processing". | access-date = 4 May 2012

In August 2009 the originators for the X100 project won the "Ten Year Best Paper Award" at the 35th International Conference on Very Large Data Bases (VLDB) for their 1999 paper "Database architecture Optimized for the new bottleneck: Memory access". It was recognised by the VLDB that the project team had made great progress in implementing the ideas contained in the paper over the previous 10 years. | access-date = 4 May 2012 The central premise of the paper is that traditional relational database systems were designed in the late 1970s and early 1980s during a time when database performance was dictated by the time required to read from and write data to hard disk. At that time available CPU was relatively slow and main memory was relatively small, so that very little data could be loaded into memory at a time. Over time hardware improved, with CPU speed and memory size doubling roughly every two years in accordance with Moore’s law, but that the design of traditional relational database systems had not adapted. The CWI research team described improvements in database code and data structures to make best use of modern hardware. | access-date = 11 December 2013 }}

In 2008 the X100 project was spun off from MonetDB as a separate project, with its own company, and renamed "VectorWise". Co-founders included Peter A. Boncz and Marcin Żukowski.

In June 2010, the VectorWise technology was officially announced by Ingres Corporation, with the release of Ingres VectorWise 1.0.

In March 2011, VectorWise 1.5 was released, publishing a record breaking result on TPC-H 100 GB benchmark. New features included parallel query execution (single query executed on multiple CPU cores), improved bulk loading and enhanced SQL support. In June 2011, VectorWise 1.6 was released, publishing record breaking results on TPC-H 100 GB, 300 GB and 1 TB non-clustered benchmark.

In December 2011, VectorWise 2.0 was released with new SQL support for analytical functions such as rank and percentile and enhanced date, time and timestamp datatypes, and support for disk spilling in hash joins and aggregation.

In June 2012, VectorWise 2.5 was released. In this release storage format was reorganized to allow storing the database in multiple location, the background update propagation mechanism from PDTs to stable storage was enhanced to allow rewriting only the changed blocks instead of full rewrites, and a new patented Predictive Buffer Manager (PBM) was introduced. | access-date = 7 February 2016 | bibcode = 2012arXiv1208.4170S

In March 2013, VectorWise 3.0 was released. New features included more efficient storage engine, support for more data types and analytical SQL functions, enhanced DDL features, and improved monitoring and profiling accessibility.

In March 2014, Actian Vector 3.5 was released, with a new rebranded and shortened name. New features included support for partitioned tables, improved disk spilling, online backup capabilities and improved SQL support - e.g. MERGE/UPSERT DML operations and FIRST_VALUE and LAST_VALUE window aggregation functions.

In June 2014, at Hadoop Summit 2014 in San Jose, Actian announced Actian Vortex clustered MPP version of Vector, with same level of SQL support working in Hadoop with storage directly in HDFS. Actian Vortex was later renamed to Actian Vector in Hadoop, and non-clustered Actian Vector releases are also updated to match. In March 2015 Actian Vector 4 was released, and Actian Vector in Hadoop 4 was released in December 2015.

In March 2019, Actian Avalanche was released as a cloud data platform, with Vector as the core engine for the Warehouse offering. In November 2023, Actian rebranded and relaunched Avalanche as Actian Data Platform, including new capabilities for Data Quality.{{cite web | url = https://www.actian.com/company/press-releases/actian-data-platform-relaunches-with-integration-as-a-service/ | title = Actian Data Platform Relaunches With Integration as a Service

Release history

Actian Vector

Actian Vector in Hadoop

In 2024, Actian decided to withdraw End of Obsolescence Support for Actian Vector in Hadoop, after discontinuing the marketing of this product line, thus making 6.0 its last release and Actian Data Platform's Cloud Data Warehouse service the only MPP implementation of Vector available.

References

References

1. (9 December 2022). "Vector 6.3 Delivers Easier Administration, Greater Automation and Better Productivity for Data Analytics".
2. "Vectorwise Enterprise". Actian Corporation.
3. "TPC-H - Top Ten Performance Results - Non-Clustered". [[Transaction Processing Performance Council]].
4. (15 February 2011). "Vectorwise Smashes TPC-H Record at Scale Factor 100 Delivering 340% of Previous Best Record". Actian Corporation.
5. (4 May 2011). "Vectorwise Breaks 300GB and 1TB TPC-H Benchmark Records Hands Down". Actian Corporation.
6. "CWI spin-off company VectorWise sold to Ingres Corporation".
7. Clarke, Gavin. (2 February 2010). "Ingres' VectorWise rises to answer Microsoft". [[The Register]].
8. Babcock, Charles. (9 June 2010). "Ingres Unveils VectorWise Database Engine". [[InformationWeek]].
9. Suleman, Khidr. (8 June 2010). "Ingres launches VectorWise database engine". V3.co.uk.
10. (2012). "Proceedings of the 2012 international conference on Management of Data - SIGMOD '12".
11. (2016-05-04). "Pssst: Want to Hear About Actian Vector 3.5?".
12. "Vector(wise) goes Hadoop".
13. "Peter Boncz - Actian Vector on Hadoop: The First Industrial-strength DBMS to Truly Leverage Hadoop".
14. Żukowski, Marcin. (11 September 2009). "Balancing vectorized query execution with bandwidth-optimized storage". [[University of Amsterdam.
15. Héman, Sandor. (2015). "Updating Compressed Column Stores". [[Vrije Universiteit Amsterdam]].
16. "Homepage of Peter Boncz".
17. "Faster database technology with MonetDB/X100". [[Centrum Wiskunde & Informatica.
18. "Third International Workshop on Data Management on New Hardware (DaMoN 2007)". [[Carnegie Mellon School of Computer Science.
19. Curt Monash. (25 April 2013). "Goodbye VectorWise, farewell ParAccel?". DBMS2.
20. "Peter Boncz". CWI.
21. "Ingres Vectorwise 1.0".
22. "An early look at Actian VectorWise 1.5".
23. "TPC-H SF100 Vectorwise 1.5".
24. "TPC-H SF100 Vectorwise 1.6".
25. "TPC-H SF300 Vectorwise 1.6".
26. "TPC-H SF1000 Vectorwise 1.6".
27. "An even faster VectorWise".
28. "Actian Releases Vectorwise 2.5 – Record-Breaking Database Is Now Even Faster".
29. "Actian Announces Availability of Vectorwise 3.0 for Getting Fast Answers from Big Data".
30. "Lifecycle Dates - Actian Vector and Vector in Hadoop".
31. "Actian Avalanche Real-Time Connected Data Warehouse adds integration".
32. "Actian Vector - New Features in Version 7.0".
33. "Actian Vector - New Features in Version 6.3".
34. "Actian Vector - New Features in Version 6.2".
35. "Actian Vector - New Features in Version 6.0".
36. "Actian Vector - New Features in Version 5.1".
37. "Actian Vector - New Features in Version 5.0".
38. "Actian Vector - New Features in Version 4.2".
39. "Actian Vector - New Features in Version 3.5".
40. "Actian Vector - New Features in Version 3.0".
41. "Actian Vector - New Features in Version 3.0 SP1".
42. "Actian Vector in Hadoop - New Features in Version 6.0".
43. "Actian Vector in Hadoop - New Features in Version 5.1".
44. "Actian Vector in Hadoop - New Features in Version 5.0".
45. "Actian Vector in Hadoop - New Features in Version 4.2".