Close
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Menu
eWEEK.com
Search
eWEEK.com
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database

    Oracle Defends Relational DBs Against NoSQL Competitors

    By
    CHRIS PREIMESBERGER
    -
    November 25, 2015
    Share
    Facebook
    Twitter
    Linkedin
      racle Defends Relational DBs

      Back on Oct. 26, eWEEK published a slideshow entitled “Why Relational Databases Don’t Handle Big Data Well.” It was an op-ed piece that looks at one side of the database debate and was labeled as such. This point of view was espoused by Matt Allen, senior manager of product solutions at NoSQL database specialist MarkLogic.

      Let’s be clear: MarkLogic makes and provides services for an alternative database to the big relational databases Oracle, IBM, SAP HANA, Microsoft SQL, Software AG, Teradata and others have built and refine all the time. So the article amounted to “fightin’ words” to these companies.

      MarkLogic, whose CEO, Gary Bloom, was an Oracle executive for 14 years, is one of a number of companies that produce software and offer services for NoSQL databases. Others include Couchbase, Datastax, ReThinkDB, Cassandra, MongoDB, FoundationDB, MariaDB, MarkLogic, and Basho.

      Oct. 26 Slideshow Highlighted NoSQL Attributes

      eWEEK expected a response, and sure enough, we received one from Andy Mendelsohn, executive vice president for Database Server Technologies at Oracle. We’re publishing that side of the issue in this article.
      To capsulize the key points in the article from a month ago:

      –Relational databases, the dominant technology for storing and managing data, are not designed to handle big data. They also cannot handle mixed workloads very well.

      –In fact, relational databases still look similar to the way they did more than 30 years ago when they were first introduced.

      –Businesses focused on big data no longer can rely on the one-size-fits-all relational model; they must look toward new databases better designed to handle current workloads.

      Allen’s main point was that new-gen databases are more agile, more scalable, more affordable and faster to move data than relational databases.

      Oracle’s Side of the Story

      “Number one, let me start by saying that we at Oracle have a broad array of data management products,” Mendelsohn reminded eWEEK, “including NoSQL products and several SQL (structured query language) products—such as the MySQL, Oracle DB and TimesTen. So we definitely understand the roles of NoSQL products versus the relational SQL engine very well.

      “If you go back to the beginning of time before relational databases in the ’80s, what was out there were no-SQL databases,” Mendelsohn said. “NoSQL databases are not new, they go back to the ’70s and ’80s. IBM mainframes have this product called VSAM; VSAM was a key value store. [Virtual storage access method (VSAM) is an IBM file storage access method, first used in the OS/VS1, OS/VS2].

      “People in these startups want you to think these are new technologies; these are very old technologies that predate relational databases. There’s just a new generation of them that has come out recently.”

      Customers were struggling with these “pre-relational” databases back in those days because they were very hard to write applications for, Mendelsohn said.

      “If I wanted to do a simple reporting application, I had to have a developer write pages of code to write a little report,” Mendelsohn said. “Relational databases were developed to solve this problem, because instead of writing pages and pages of what was then Cobol code, you just write a couple lines of SQL, and you could get your answers back without any developers required. You could have a business analyst do it, and later, tools came along that generated the SQL.

      “The bottom line was that SQL was created to solve a developer productivity problem.”

      Oracle Defends Relational DBs Against NoSQL Competitors

      Oracle: NoSQL Isn’t Anything New

      Moving foward to the last 10 years or so, Mendelsohn said, “the latest generation of these NoSQL products came along. They were designed just like the original NoSQL products to solve very simple problems—you can’t do things like reporting and analytics with these (NoSQL) databases. They’re very developer-intensive, very low productivity.

      “Amazon created DynamoDB, which was actually a descendant of an Oracle product called BerkeleyDB (from the Sleepycat acquisition in February 2006). Amazon and Google were big customers [of Oracle’s]. It’s an open source product; Amazon was buying a lot of support for it, and at some point they just took it because it was open source and created Dynamo around that same technology,” Mendelsohn said.

      “I don’t know if Berkeley is still in the core of DynamoDB, but that’s where Dynamo came from. It was designed for these simple data management problems, like if you were going to tell Amazon, ‘I am Andrew Mendelsohn, show me some products that I can buy, or show me a price list.’ These were not transaction processing; these were sort of data-publishing applications that were very simple key-value use cases.”

      OracleDB Does the Heavy Lifting at Amazon

      As far as all the heavy lifting at Amazon, Mendelsohn said, “they still to this day use Oracle relational databases to do all the transaction processing on the Amazon.com Website; they use Oracle DBs for all the data warehousing on the e-commerce site. All the big data, all the analytics is still done by Amazon on Oracle.”

      Certainly, Amazon could use DynamoDB for the big data workloads, Mendelsohn said, “but they don’t because SQL is a much more productive way of getting analytics out of a database that it makes no sense to use NoSQL databases.

      “The end of the story is pretty simple: NoSQL products are very good for very simple applications, where you’re pointing data back to the key, you’re getting a value back, and it can be a JSON document or whatever it is that people want. Relational SQL databases are really good when you’re trying to do more complex workloads, like getting a report back for your business and doing transaction processing,” he said.

      The bottom line, Mendelsohn said, is that NoSQL, which has been around for 40 years, is still a small niche of the market.

      “Relational databases are pretty much all of the market,” Mendelsohn said. “Relational database have the attributes to do everything; NoSQL is limited. You can believe me or not believe me, but if you look at the Gartner market share numbers, it’s pretty clear which market is big and which is small.”

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      CHRIS PREIMESBERGER - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      CHRIS PREIMESBERGER - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cybersecurity

      How Veritas Is Shining a Light Into...

      EWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Big Data and Analytics

      How NVIDIA A100 Station Brings Data Center...

      ZEUS KERRAVALA - November 18, 2020 0
      There’s little debate that graphics processor unit manufacturer NVIDIA is the de facto standard when it comes to providing silicon to power machine learning...
      Read more
      Apple

      Why iPhone 12 Pro Makes Sense for...

      WAYNE RASH - November 26, 2020 0
      If you’ve been watching the Apple commercials for the past three weeks, you already know what the company thinks will happen if you buy...
      Read more
      eWeek


      Contact Us | About | Sitemap

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Property of TechnologyAdvice.
      Terms of Service | Privacy Notice | Advertise | California - Do Not Sell My Info

      © 2020 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×