Vertica Puts Column-Oriented Database In Virtual Machine - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

06:40 PM
Connect Directly

Vertica Puts Column-Oriented Database In Virtual Machine

The software runs on commodity hardware and becomes a plug-and-play addition to a data center being built out around cloud principles.

Vertica, the startup that offers a column-oriented database system for data warehouse analytics, is now offering a version of its system that runs in a VMware virtual machine.

"This is a new way to take advantage of data stored in a private cloud," said Dave Menninger, VP of product management for the Vertica Virtualized Analytic Database. It runs on commodity hardware and becomes a plug-and-play addition to a data center being built out around cloud principles, he said in an interview. If lots of commodity hardware is available, the Virtualized Analytic Database can expand its use of CPUs and solve a knotty data warehouse problem without needing a dedicated large server, he said.

"People do things in the cloud that they never would have thought of doing before. You can do things inside the corporation that you've been doing in the cloud," said Jerry Held, executive chairman of Vertica and former senior VP of the Oracle database server unit.

Vertica is competing with database machines, a database system preloaded on a piece of hardware, by offering a column-oriented database appliance, a copy of its system optimized to run with CentOS Linux in the VMware virtual machine. (CentOS repackages a version of Red Hat Enterprise Linux 5.3 or earlier.) The analytic database is designed to be used in organizations that frequently want to deploy a data mart, have highly seasonal data leading to periods of intense usage, or have analytic databases that grow rapidly, said Menninger.

It's priced at $100,000 for a 1-TB entry-level model. Three terabytes of data would lead to a higher price, but the price per terabyte declines as the number of terabytes increases, Menninger said.

Data warehouses are typically designed to run on a large server or sets of servers because of their occasional use of many CPU cycles. With a virtualized system, additional hardware can be activated as needed and loaded with virtual machines.

"Faster, more economical virtualized analytic databases will outmode specialized, hardware-based appliances," Menninger predicted. With pricing based on the amount of data being analyzed, not CPUs on which it's running, customers can achieve high performance at a lower cost.

The basic Virtualized Analytic Database stands the usual relational database paradigm on its head. It grabs information out of the columns of a table, instead of its rows. Columnar information is all similar, such as the total sales for each member of the sales force for a given month, and can be retrieved and analyzed quickly. Row information, on the other hand, may include many pieces of information about each salesperson, with the data recorded at each step dissimilar from the one that went before it.

Located in Billerica, Mass., Vertica is used by 60 customers, including companies in telecommunications and financial services. The firm brought out its first version of the column-oriented database in September 2007.

Vertica was co-founded by former University of California at Berkeley computer science professor Michael Stonebraker, who says compressing information in columns adds a performance benefit when it comes to analyzing column information. The compression is possible because one compression scheme can be applied to all the elements of the column, unlike a row.

Believe it or not, virtualization thrives in smaller companies. InformationWeek has published an independent analysis of this topic. Download the report here (registration required).

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Get Your Enterprise Ready for 5G
Mary E. Shacklett, Mary E. Shacklett,  1/14/2020
Modern App Dev: An Enterprise Guide
Cathleen Gagne, Managing Editor, InformationWeek,  1/5/2020
9 Ways to Improve IT and Operational Efficiencies in 2020
Cynthia Harvey, Freelance Journalist, InformationWeek,  1/2/2020
White Papers
Register for InformationWeek Newsletters
State of the Cloud
State of the Cloud
Cloud has drastically changed how IT organizations consume and deploy services in the digital age. This research report will delve into public, private and hybrid cloud adoption trends, with a special focus on infrastructure as a service and its role in the enterprise. Find out the challenges organizations are experiencing, and the technologies and strategies they are using to manage and mitigate those challenges today.
Current Issue
The Cloud Gets Ready for the 20's
This IT Trend Report explores how cloud computing is being shaped for the next phase in its maturation. It will help enterprise IT decision makers and business leaders understand some of the key trends reflected emerging cloud concepts and technologies, and in enterprise cloud usage patterns. Get it today!
Flash Poll