Vertica Systems, a developer of analytic database management systems, has unveiled new version of the Vertica Analytic Database system, Vertica 3.5. The announcement was made at TDWI World Conference, San Diego, California.

Vertica Systems said that the new Vertica 3.5 comes with an enhancement in storing and processing columnar data called FlexStore. Vertica applies a variety of physical design, database storage and query execution techniques that keep the DBMS optimised for the analytic workload it’s supporting at the time.

According to Vertica Systems, the new version comes with intelligent disk utilisation technique which automates the creation of a tiered storage environment to support enterprise information lifecycle management (ILM) strategies, assigning frequently accessed data to media such as double-parity RAIDs or solid state disks (SSDs), while moving less frequently accessed data to slower disks in the cluster.

Other techniques include enhanced query execution engine; data loading and deletes; and column grouping that groups multiple columns into a single disk file.

The company said that the new version also introduces native support for MapReduce through connectivity to the standard Hadoop framework. The new Vertica 3.5 interface to Hadoop enables MapReduce developers to perform in-database analytics by allowing to store and retrieve data from the Vertica Analytic Database.

In addition, this combination of Massively parallel (MPP) analytic database and MPP compute framework enables enterprises to process large sets of structured and unstructured data and make them available to business users at web speeds.

Reportedly, Vertica 3.5 can be run on Linux servers, any VMware vSphere or VMware Server-supported hardware, or on-demand in enterprise and public clouds such as the Amazon Elastic Compute Cloud (Amazon EC2).