Actian VectorH 6 Enables User Defined Functions, Machine Learning, Semi-Structured Data Support, and Enhancement of Workload Management Capabilities.
Actian is pleased to announce the availability of Actian VectorH 6. This release includes new features, including User Defined Functions (UDFs), JSON Support, and Workload Management.
This post provides an overview of some features that have been added to this release.
Key New Features
Workload management in database management systems (DBMSs) is the method of monitoring and managing work (i.e., database transactions) executing within a database system. Through control of work in a database, this allows the efficient use of system resources and the ability to maintain performance objectives. In VectorH 6, Actian has started to lay the groundwork for comprehensive workload management within the Vector database by enabling the control of the database access mode, limiting the row count returned by a given query, and the ability to abort queries should they reach pre-defined limits.
JSON functions in Vector enable you to combine NoSQL and relational concepts in the same database. Now you can combine classic relational columns with columns that contain documents formatted as JSON text in the same table and parse and import JSON documents in relational structures. Vector 6 provides functionality to work with JSON objects directly in the database. Bridging semi-structured data with relational databases creates a solution that is more flexible, and can handle additional use cases where the underlying data structures change more rapidly. Some examples include; working with REST APIs and working with data in Business Intelligence (BI) and Data Science tools where the structure changes.
This latest Vector release continues to develop its performance capabilities. These performance capabilities have been further refined in VectorH 6. In addition, new encryption capabilities and stability fixes are incorporated in the latest version.
Actian VectorH 6 continues to support RHEL, CentOS, SUSE Linux, Ubuntu, Cloudera, and Hortonworks. VectorH 6 is available today from esd.actian.com. Vector 6 for Linux will be available in Q2 2020, and Windows in Q3 2020.