NewSQL Vendor MemSQL Takes On MongoDB - InformationWeek
Data Management // Software Platforms
12:49 PM
Connect Directly

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.

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
Newest First  |  Oldest First  |  Threaded View
D. Henschen
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).
David F. Carr
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
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.
Register for InformationWeek Newsletters
Current Issue
The Next Generation of IT Support
The workforce is changing as businesses become global and technology erodes geographical and physical barriers.IT organizations are critical to enabling this transition and can utilize next-generation tools and strategies to provide world-class support regardless of location, platform or device
White Papers
Twitter Feed
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.
Flash Poll