MongoDB chief: It will be mixed SQL-NoSQL world

Summary:MongoDB's chief developer and 10gen CEO Dwight Merriman said NoSQL technologies are very agile and scalable but is no substitute for SQL when doing complex transactions, reporting and BI. And he added that he did not coin and does not like the term NoSQL

MongoDB's chief developer and 10gen CEO said NoSQL is very agile and scalable but is no substitute for SQL when doing complex transactions, reporting and BI.

During his keynote at OSCON 2011 today, 10gen CEO Dwight Merriman said enterprise customers will probably adopt a mixed bag of database technologies -- both SQL and NoSQL -- for different workloads.

And he took exception to the term NoSQL, which has become widely used to describe his MondoDB's document-oriented storage solution.

"It's not a one siz fits all anymore," Merriman said during his keynote at the Portland, Oregon conference, which was streamed live over the Internet today. "One will use multiple technologies. If I were a CTO, I'd want to use NoSQL for scalable high performance operational data access, lots of reads and writes at high speed and [for] semi real-time and low latency for end users," he said. "And you need another for reporting and BI. These [NoSQL] technologies are not optimal for that. In general, a classic data warhouse is a good solution for those things."

He did not coin the term NoSQL and he doesn't seem to like it.  The point of MongoDB is to address massive scale out needs of document-oriented storage -- and making development in this space better.

"Making development easier and more elegant is just a big a property [to MongoDB to gain as scale out," said Merriman, the former DoubleClick founder.

Merriman did predict that some of the holes in MongoDB and other so-called NoSQL solutions will be addressed -- but he pushed the notion that it will be a mixed SQL/noSQL world for some time to come.
"Over time, the way we do aggregation is improving ... with Hive and other higher level abstraction layers," he said. 'If there is a gap, it'll go away or be smaller. But reporting is something you'll miss today."

Topics: Enterprise Software, CXO

About

Paula Rooney has covered the software and technology industry for more than 20 years, starting with semiconductor design and mini-computer systems at EDN News and later focused on PC software companies including Microsoft, Lotus, Oracle, Red Hat, Novell and other open source and commercial software companies for CRN and PCWeek. She receiv... Full Bio

Contact Disclosure

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Related Stories

The best of ZDNet, delivered

You have been successfully signed up. To sign up for more newsletters or to manage your account, visit the Newsletter Subscription Center.
Subscription failed.