Big Data // Software Platforms
News
9/18/2013
12:49 PM
Connect Directly
Google+
LinkedIn
Twitter
RSS
E-Mail
50%
50%

NewSQL Vendor MemSQL Takes On MongoDB

MemSQL adds JSON document handling to its high-scale, in-memory database to challenge the leading NoSQL database vendor.

Startup vendor MemSQL announced Wednesday a new release of its high-scale, in-memory database that adds JSON (Java Script Object Notation) support. The move is aimed at attracting developers who might otherwise choose the MongoDB NoSQL database.

MongoDB has the leading market share in the burgeoning NoSQL database market, and JSON document handling is that product's stock in trade. So it's no coincidence that database rivals of every description are adding JSON support. The list includes NoSQL vendor Couchbase and relational database vendors IBM DB2 and Oracle MySQL.

MemSQL is a two-year-old company in the so-called NewSQL camp -- vendors trying to blend the scalability of NoSQL databases with relational database attributes including ACID-compliant (atomic, consistent, isolated, durable) transactional performance and convenient SQL querying. Like other NewSQL options (Clustrix, FoundationDB, ScaleDB), MemSQL is a relational database, but its differentiator is the combination of in-memory (optimized for RAM) performance and scale-out massively parallel processing. Its closest competitor is VoltDB, launched in 2009.

MemSQL's JSON move in the 2.5 release is no big surprise as it was part of an earlier release candidate. Native JSON support will enable the database to consume clickstreams and event feeds expressed in JSON, as frequently encountered in high-scale Internet applications.

[ Want more on the latest NoSQL move? Read Couchbase Takes NoSQL Mobile. ]

"Support for JSON means developers can move faster by plugging JSON directly into the system and then use SQL to query, iterate, traverse and index that data," said Eric Frenkiel, CEO of MemSQL, in a phone interview with InformationWeek. "With NoSQL databases it's easy to get data in, but how do you intelligently get data out? That has been a sore point for NoSQL vendors."

In MemSQL's case, the ability to query JSON with SQL comes without the penalty of having to transform that data to a consistent structure, but that's not always the case for rivals, according to Frenkiel, who co-founded MemSQL along with fellow Facebook veteran and CTO Nikita Shamgunov.

MemSQL's 2.5 release also attempts to add NoSQL flexibility with a new online alter table feature. What NewSQL databases typically can't do is match the flexibility of NoSQL databases because they rely on predefined data models to support SQL querying. Frenkiel said the online alter table feature greatly reduces the penalty of adding new dimensions of data a MemSQL data model.

"When you add more data on a disk-based system, it becomes expensive and time consuming to alter tables, but this online alter table feature lets you add a new column to a table without downtime or locking," Frenkiel explained.

MemSQL 2.5 will reach general release in October. MemSQL claims to have "dozens" of customers, with leading lights including Zynga, Shutterstock, Comcast, CPX Interactive and Ziff Davis.

Comment  | 
Print  | 
More Insights
Comments
Oldest First  |  Newest First  |  Threaded View
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
9/18/2013 | 8:51:22 PM
re: NewSQL Vendor MemSQL Takes On MongoDB
The list of product that can handle JSON is long. The question that isn't really understood by users and clearly explained by vendors is just how easy (or not) it is to deal with that data. Rivals throw claims that the other guys have to transform the data or otherwise jump through hoops. There are also differences in loading and flexibility, with NoSQL products presumably having the edge in flexibility and ease of use. More to be learned on this front for sure.
David F. Carr
50%
50%
David F. Carr,
User Rank: Author
9/19/2013 | 5:42:24 PM
re: NewSQL Vendor MemSQL Takes On MongoDB
I think of JSON as being just a text format for passing data between applications. I take it this is something more than just storing JSON as text -- the database parses it and stores it as an object oriented data structure?
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
9/20/2013 | 8:22:57 PM
re: NewSQL Vendor MemSQL Takes On MongoDB
Yes, more than storing JSON. Database functionality lets you retreive documents that have certain fields or values. You can query the document structure and you can typically retrieve and/or update portions of documents (depending on which DB with JSON capabilities you're talking about).
In A Fever For Big Data
In A Fever For Big Data
Healthcare orgs are relentlessly accumulating data, and a growing array of tools are becoming available to manage it.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest, Dec. 9, 2014
Apps will make or break the tablet as a work device, but don't shortchange critical factors related to hardware, security, peripherals, and integration.
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of December 14, 2014. Be here for the show and for the incredible Friday Afternoon Conversation that runs beside the program.
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.