Data Management // Software Platforms
12:49 PM
Connect Directly
Core System Testing: How to Achieve Success
Oct 06, 2016
Property and Casualty Insurers have been investing in modernizing their core systems to provide fl ...Read More>>

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
Oldest First  |  Newest First  |  Threaded View
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.
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/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
Top IT Trends to Watch in Financial Services
IT pros at banks, investment houses, insurance companies, and other financial services organizations are focused on a range of issues, from peer-to-peer lending to cybersecurity to performance, agility, and compliance. It all matters.
Twitter Feed
InformationWeek Radio
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.