An early look at Actian VectorWise 1.5

Share

IVW Splash Screen

Earlier today we posted an early drop of Actian VectorWise 1.5 here.   I suspect that the timing for this drop was chosen so that those of us who have a bit of down-time over the holidays can play with the new features in this release.

We, the emerging technologies team,  have been working with this release for a while now and we’re in the process of certifying third party BI solutions against IVW 1.5 – a process that’s going far smoother than one would expect from a version 1.5 product.  We’re also busy helping to get Actian VectorWise ported to 64-bit Windows, and I know that there are a number of you anxious to get your hands on that as soon as you can – stay tuned, and I’ll let you know when it drops.

For those of you who are curious about what’s been added since we launched Actian VectorWise 1.0 in the summer, I’ve cut and pasted the blurb on the new features below:

Transfer data between traditional Actian and Actian VectorWise

Data from traditional Actian tables can be transferred into VectorWise tables (and the reverse) using INSERT…SELECT or CREATE TABLE AS SELECT. This feature lets you easily migrate a traditional Actian-based application to Actian VectorWise, easily share data between VectorWise-based tables and Actian-based tables, and use OLTP and data warehousing applications in a single installation.

Fast loader

The iivwfastload utility allows faster loading of data from data files into VectorWise tables.

Add and Drop Column

A column can be added to a table or dropped from a table. The ALTER TABLE…ADD COLUMN and the ALTER TABLE…DROP COLUMN statements are supported.

Improved DML

Transaction enhancements

Transaction management is supported through the COMMIT and ROLLBACK statements. Also, multiple concurrent transactions are supported.
Note: If you are changing the same rows in two different concurrent transactions, only one will be able to commit.

Parallel CREATE TABLE AS SELECT

Temporary tables

Temporary tables are supported through the DECLARE GLOBAL TEMPORARY TABLE statement. Temporary tables can be used to organize data derived from queries into new tables, which can then be queried repeatedly during a session. This feature improves query performance.

Parallel query

Parallel query execution (using multiple cores to execute one query) is supported. You can enable it by modifying the max_parallelism_level option in the configuration file. This feature allows significant performance improvements on queries that access large volumes of data.

Storage improvements

Storage is improved as follows:
Database size is now unlimited. When the database is filled up (the default is 128 GB), the file grows. This feature makes the columnspace_size configuration parameter obsolete.
Performance is significantly improved when making multiple small updates to a table, using COPY, INSERT, DELETE, or UPDATE statements. Data is appended to the last previously written blocks, which reduces storage space and improves query performance.
A table can use the VECTORWISE_ROW storage structure, which stores data in rows rather than columns. Such storage is a more efficient use of disk space and is especially useful if you have thousands of tables or tables with a very large number (over 10,000) of columns.

Support for Large Pages

The “huge pages” (Linux) or “large pages” (Windows) feature of modern CPUs is supported. This feature limits memory fragmentation, which improves database performance.

If you want to download the Alpha release of Actian VectorWise 1.5 you’ll find it here

About Emma McGrattan

As SVP of Engineering at Actian, Emma leads development for the Actian Vector team, including the Ingres and X100 components, and the Actian Matrix Planner team. A leading authority in DBMS technologies, Emma is celebrating 20 years in Ingres and Actian Engineering.

View all posts by Emma McGrattan →

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>