Click to Play

Internet Giants Face-off: Apple Vs...
The Federal Communications Commission is investigating Apple's decision to reject a Google Voice application for the iPhone. The commission sent letters of inquiry...

Recent Articles

Collection Of The Best SQL Related Material On The Web
The MySQL Librarian is an initiative aimed to collect links to the best MySQL-related material on the web. I asked Giuseppe Maxia, MySQL Community Team Lead, more about the initiative. MySQL Librarian is an open...

Euro Open SQL Camp Begins August 22nd
The European edition of the OpenSQLCamp 2009, will take place in Sankt Augustin (Germany) on Saturday 22nd and Sunday 23rd within the Free and Open Source Conference 2009 - the German conference now...

Ntirety Gets Into MySQL Database Administration
MySQL is now officially under Ntirety's figurative umbrella. The Massachusetts-based company has expanded its remote database services to include the relational database management system, which...

SaaS Version Of SQL Server Management Toolset...
Individuals and companies with ties to SQL Server may soon have a much easier time of things. Red Rock Consulting has released a Software as a Service (Saas) version of its RockSolid SQL Server Management toolset. RockSolid DBA Maximize is, according to Red Rock Coe...

Oracle Slated To Buy Sun
The AP is reporting that Oracle will buy Sun shares for $9.50/share, $0.10 higher than IBM's reported offer which fell through. The deal is expected to close in this summer. Oracle estimates that Sun will contribute...



08.04.09

Bridging The Gap Between RDBMS And NoSQL

By Savio Rodrigues

Reading ComputerWorld's article on the anti database movement reminded me of James Governor's "SOA flatlines: BRAIN!" post.  I always love going back to James' post when someone proclaims that Y is so much better than X, that while X is used widely, X will surely die.  Here's a choice set quotes:

"Windows- Windows is obviously dead. MacOS and Linux have killed it stone dead. Yeah 80%+ market share is a terrible place to be. And don't even get me started on IE. Because it. is. dead.

Unix is dead. Damn straight. Oh yeah don't forget the relational database. Dead. Cobol - totally dead. Hundreds of millions of lines of new code each year. That's dead right? Dead, dead, dead.

Everything is dead."

Back to the ComputerWorld article.  The article is based on a NoSQL confab held in early June which attracted 150 attendees.  The article could be viewed as NoSQL propaganda, as some comments on the post and at HackerNews have suggested.

For example:

"FaceBook, for instance, created its Cassandra data store in-house to replace its use of MySQL…"

In reality, a reader comments:

"Facebook is still MySQL backed and uses Cassandra for only specific things and that they use many different technologies where they're good (like heavy use of memcached as a key-value store to reduce load on MySQL where queries aren't needed)."

To be fair, the original quote did not suggest that Facebook has completely ditched MySQL.  Just that Cassandra, a NoSQL option, is being used for work that was previously done with MySQL.

Get a Holistic View of Your Complete IT Infrastructure - Free Trial

Or the following quote from NoSQL confab organizer Johan Oskarsson:

"Many, said Oskarsson, had even dumped the open-source MySQL database, a long-time Web 2.0 favorite, for a NoSQL alternative, because the advantages were too compelling to ignore."

Again, context is key here.  What's the value of the data in question?  What if the data isn't always consistent? User profile or deposit/withdrawal data is of higher value, with a higher requirement for consistency than voting data from a website poll.

As the MonoDB guys say,

"Databases are specializing - the "one size fits all" approach of the RDBMS no longer applies."

But this doesn't mean approach Y will completely displace approach X.  I'm reminded of the open source (Y) versus traditional software (X) argument.  Far from Y killing X, we're settling in on a software industry where both models are appropriate, depending on the use case.

Vendors that can bridge the gap between RDBMS and the NoSQL movement are going to be the winners.

The proponents of NoSQL are too early in the game, and may indeed be too heavily invested in differentiating from RDBMS, that they will pay little attention to this bridge.  Traditional RDBMS vendors would prefer that customers use RDBMS products to address these extremely high volume, low value data scenarios that the NoSQL movement is better suited.  SpringSource's Javier Soltero nails this sentiment:

"Oracle would tell you that with the right degree of hardware and the right configuration of Oracle RAC (Real Application Clusters) and other associated magic software, you can achieve the same scalability. But at what cost?"

Enterprises need to be shown that both the RDBMS and NoSQL approaches have their place and can both be applied to drive business benefit.  IBM, Oracle, Microsoft, you listening?

Comments


About the Author:
Savio Rodrigues is a product manager with IBM's WebSphere Software division. He envisions a day when open source and traditional software live in harmony. This site contains Savio's personal views. IBM does not necessarily agree with the views expressed here.
SQLproNews is brought to you by:

SecurityConfig.com NetworkingFiles.com
NetworkNewz.com WebProASP.com
DatabaseProNews.com SQLProNews.com
ITcertificationNews.com SysAdminNews.com
SQLproNews.com WirelessProNews.com
CProgrammingTrends.com SysAdminNews.com


About SQLproNews
SQLproNews is a collection of up to date tutorials and insightful articles designed to help SQL users of any skill level implement successful SQL systems and practices. SQL Strategies and Tactics for Business




-- SQLProNews is an iEntry, Inc. publication --
iEntry, Inc. 2549 Richmond Rd. Lexington KY, 40509
2009 iEntry, Inc.  All Rights Reserved  Privacy Policy  Legal

advertising info | news headlines | free newsletters | comments/feedback | submit article


SQL Strategies and Tactics for Business SQLproNews News Archives About Us Feedback SQLproNews Home Page About Article Archive News Downloads WebProWorld Forums Jayde iEntry Advertise Contact