VoltDB Steps Up In-Memory Analytics - 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.

IoT
IoT
Data Management // Big Data Analytics
News
1/29/2014
02:22 PM
Connect Directly
Google+
LinkedIn
Twitter
RSS
E-Mail
50%
50%

VoltDB Steps Up In-Memory Analytics

VoltDB 4.0 release brings speedier SQL queries to a scalable in-memory transactions platform.

VoltDB has high-scale, high-speed transaction processing down pat thanks to its highly distributed, in-memory architecture, but on Wednesday the company announced a 4.0 upgrade said to dramatically improve the analytical capabilities of its database management system (DBMS).

VoltDB is one of those NewSQL DBMSs first introduced as an open-source product in 2010. VoltDB, the company, introduced subscription-based commercial support in 2011, and it now reports that more than 300 customers -- concentrated in telecommunications, financial services, and utilities -- rely on the product's fast, all-in-memory performance.

What the company learned leading to this week's upgrade is that its customers are as interested in analytics as they are high-scale, high-speed transaction processing. "We were telling our customers that they were doing transactions, but they came back to us and said, 'yes, there's the transaction, but the value is in the analytics that go into the transaction decisions,' " said Ryan Betts, VoltDB's CTO, in a phone interview with InformationWeek.

[Want insight on NewSQL vs. NoSQL? Read NewSQL Vendor MemSQL Takes On MongoDB.]

Many of VoltDB's customers are software vendors who embed VoltDB into their applications. Openet, for example, offers billing and policy administration software used by telcos such as Verizon and AT&T. Powered by the DBMS, the application lets telcos make transactional decisions about Internet quality or pricing based on device, time, service level, volume of users, or other variables. But the app also gathers and analyzes the data to determine service usage and optimize the transactional decisions. And based on the transactional patterns with individual customers, Openet's software can also trigger service promotions -- another analytical use of the application.

The analytical upgrades in VoltDB 4.0 include a tenfold increase in query throughput -- from roughly 1,000 queries per second to 10,000 to 20,000 per second, according to Betts. This was accompanied by an increase in the number of concurrent users the DBMS can support. In addition, the upgrade supports deeper support for SQL analytics, particularly in the area of time-series analysis.

On the operational side, VoltDB 4.0 can be scaled up while online with an "elastic cluster" capability to add nodes to a running cluster. The upgrade also introduces new integrations, including support for cloud-based management with New Relic monitoring utilities. For those moving from MySQL, there's a new migration tool called Voltify.

VoltDB's competitors include the incumbent in-memory databases, Oracle TimesTen and IBM solidDB, in the telco arena, and Microsoft SQL Server and MySQL more generally across other categories. VoltDB is winning against the latter because the demand for high-scale, in-memory performance is on the upswing, according to Betts.

"There are a lot of companies out there with infrastructure that is getting commoditized, so they're trying to get value out of the goldmine of data that they're sitting on top of," Betts said.

A VoltDB customer that provides WiFi hot spots for retailers, for example, has plenty of service-provider competition, Betts explained. But what if it could make use of data on people tapping into the hot spots, providing insight on how long they linger in a store, what's known about their profile, and whether customer traffic patterns are changing by store location?

"When you can collect, organize, analyze, and decision in real time, all of a sudden that data has incredible value," Betts said.

Doug Henschen is executive editor of InformationWeek, where he covers the intersection of enterprise applications with information management, business intelligence, big data, and analytics. He previously served as editor-in-chief of Intelligent Enterprise, editor-in-chief of Transform magazine, and executive editor at DM News.

Solid state alone can't solve your volume and performance problem. Think scale-out, virtualization, and cloud. Find out more about the 2014 State of Enterprise Storage Survey results in the new issue of InformationWeek Tech Digest.

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
Comments
Newest First  |  Oldest First  |  Threaded View
saidec16
50%
50%
saidec16,
User Rank: Apprentice
6/6/2014 | 9:16:38 AM
Re: in-memory db
Hiya - here are few points based on what i've looked at from the Net:

 

1. IBM Solid DB and Oracle's tent times ten eliminate/alleviate the hotspot related to buffer management but it's still disk-based as this is easier to write, they've have add  this enhancement.

where as real in-memory row-store for high-velocity data has different design goals:

totally in-memory with  durability provided by command logging (like that of Voltdb)

replication/partioning provided that of VoltDb

concurrency approaches that are different from disk-based db like IBM, Microsoft, Oracle etc.,

 

also, i believe, Fkey is not provided and one needs to partitioin/repartition if usage changes though based on use-cases.   Also, throughput or latency is the question.  Voltd harps on throughput but Yahoo's PNUTS have a different take and provides master-master (across clusters) and uses time-line consistency.  

 

From  my perspective, in future, big-firms might catch-up assuming barries to entry diminishes from  the design engineering standpoint provided they do a rewrite and reuse parts of  code that can be reused for the  NEWSQL world.

 

Note: I'm a hands-on Solutions architect  and i happened to research more on this and VoltDb is something i'd used to compare it against other ones.  I don't   work for VoltDb nor do i endorse them.
Lorna Garey
50%
50%
Lorna Garey,
User Rank: Author
1/30/2014 | 10:48:33 AM
Re: In-memory blurs lines.
Doug, Are all the in-memory offerings roughly equal in terms of the type of memory hardware they use, and thus the differentiator is the DBMS' optimization and efficiency? Or, do you see variations in the actual main memory?
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
1/30/2014 | 9:43:50 AM
In-memory blurs lines.
If it's in-memory technology, people tend to assume that SAP Hana is the competition, but that platform didn't come up in my discussion with VoltDB. The NewSQL camp and incumbents are largely trolling in different waters, even as press releases and PR pitches proclaim "Why Oracle and SAP are getting it wrong" -- an appeal I saw today from one NewSQL vendor.
Slideshows
Top-Paying U.S. Cities for Data Scientists and Data Analysts
Cynthia Harvey, Freelance Journalist, InformationWeek,  11/5/2019
Slideshows
10 Strategic Technology Trends for 2020
Jessica Davis, Senior Editor, Enterprise Apps,  11/1/2019
Commentary
Study Proposes 5 Primary Traits of Innovation Leaders
Joao-Pierre S. Ruth, Senior Writer,  11/8/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Getting Started With Emerging Technologies
Looking to help your enterprise IT team ease the stress of putting new/emerging technologies such as AI, machine learning and IoT to work for their organizations? There are a few ways to get off on the right foot. In this report we share some expert advice on how to approach some of these seemingly daunting tech challenges.
Slideshows
Flash Poll