By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics in sports industry
    Here’s How Data Analytics In Sports Is Changing The Game
    6 Min Read
    data analytics on nursing career
    Advances in Data Analytics Are Rapidly Transforming Nursing
    8 Min Read
    data analytics reveals the benefits of MBA
    Data Analytics Technology Proves Benefits of an MBA
    9 Min Read
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Death Of The Relational Database
Share
Notification Show More
Latest News
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security
ai in software development
3 AI-Based Strategies to Develop Software in Uncertain Times
Software
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Mining > Death Of The Relational Database
Data MiningData Warehousing

Death Of The Relational Database

Steve Bennett
Last updated: 2009/07/04 at 6:21 AM
Steve Bennett
7 Min Read
SHARE

A recent entry by Tony Bain in his excellent ‘Innovations in Data Management‘ blog caught me a little by surprise. In it he talks about the NoSQL movement – the group of people and organisations that say we can do without the RDBMS’s from the likes of Oracle, Microsoft and IBM. This is new to me.

In a nutshell, the argument runs as follows: Massively scalable databases exist that are not relational and they power some of the biggest sites on the internet – Amazon, Google and Facebook to name three.

For those who don’t know about NoSQL, take a look at ACM blogger Michael Stonebraker or a nice summary from Computerworld. You can’t find anything about NoSQL on wikipedia yet – that’s how new it is. Stonebraker constructs a convincing argument in favour of ‘the death of the RDBMS’:
  • For data warehouses, a column store beats a row store by approximately a factor of 50 on typical business intelligence queries. The reason is because column stores read only the columns of interest to the query and not all of them. In addition, compression is more effective in a column store. Since the legacy systems are all row stores, they are vulnerable to competition from the newer column stores.
  • For online …

More Read

What is Data Pipeline A detailed explaination

What is Data Pipeline? A Detailed Explanation

Can Data Mining Aid with Off-Page SEO Strategies?
3 Data Mining Tips for Companies Trying to Understand their Customers
5 Data Mining Tips to Leverage the Benefits of Surveys
Understanding ETL Tools as a Data-Centric Organization

A recent entry by Tony Bain in his excellent ‘Innovations in Data Management‘ blog caught me a little by surprise. In it he talks about the NoSQL movement – the group of people and organisations that say we can do without the RDBMS’s from the likes of Oracle, Microsoft and IBM. This is new to me.

In a nutshell, the argument runs as follows: Massively scalable databases exist that are not relational and they power some of the biggest sites on the internet – Amazon, Google and Facebook to name three.

For those who don’t know about NoSQL, take a look at ACM blogger Michael Stonebraker or a nice summary from Computerworld. You can’t find anything about NoSQL on wikipedia yet – that’s how new it is. Stonebraker constructs a convincing argument in favour of ‘the death of the RDBMS’:
  • For data warehouses, a column store beats a row store by approximately a factor of 50 on typical business intelligence queries. The reason is because column stores read only the columns of interest to the query and not all of them. In addition, compression is more effective in a column store. Since the legacy systems are all row stores, they are vulnerable to competition from the newer column stores.
  • For online transaction processing (OLTP), a lightweight main memory DBMS beats a row store by a factor of 50. Leveraging main memory and the fact that no DBMS application will send a message to a human user in the middle of a transaction, allows an OLTP DBMS to run transactions to completion with no resource contention or locking overhead. 
  • In XML, where the current major vendors have spent a great deal of energy extending their engines, it is claimed that specialized engines, such as Mark Logic or Tamino, run circles around the major vendors. 

The argument then runs that if you don’t want performance like this, then just get an open source RDBMS for free. I am beginning to agree (even the Cortex is MySQL) and if free is to hard for you, the price of SQLServer is good value for most organisations these days.

So what are the reasons for spending big dollars on an RDBMS? Here are the reasons I can think of for a large company:
  • Nobody every got sacked for buying Oracle or DB2.
  • The IT specialists have built their career and expertise on a specific vendor’s product line. What’s in it for them to support a change that they see as undermining that?
  • Who’s going to hire someone with Voldemort or MongoDB experience?? 
  • For most applications, the RDBMS can do the job – so what if the company spends $500,000 more on hardware to do it. Don’t forget, the hardware guys are also comfortable with running the big RDBMS on ‘their’ boxes.
  • A surprising number of data warehouse developer’s lack the skills to really understand the differences pointed out by the NoSQL people. Besides – they’re not the one’s paying for the infrastructure they use. 
I am happy to concede that none of these reasons are technical. Politics is very real in larger enterprises and you don’t stay long if you ignore this fact. In the past I have been lucky to hire some very good developers because of their frustration with life in a large corporate data shop.

Anyway, the NoSQL revolutionaries got together recently and you can read/view/listen to the presentations on Johan Oskarsson’s site (he is a developer for Last.fm in London). The presentation on the Cassandra database by Avinash Lakshman of Facebook has some interesting stats comparing Cassandra and MySQL for example.

It is curious that the NoSQL people don’t call their solutions databases. Instead they are a a “highly available key-value store” (Amazon) and a “distributed storage system for managing structured data” (Google). At least MongoDB does describe itself as “a high-performance, open source, schema-free document-oriented database.” Not exactly as snappy a label as RDBMS and I wonder why CDBMS (Columnar RDBMS) isn’t good enough.

Check out NoSQL – it could be useful to you.

Link to original post

Steve Bennett July 4, 2009
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

What is Data Pipeline A detailed explaination
Big Data

What is Data Pipeline? A Detailed Explanation

8 Min Read
data mining helps with offsite SEO
Data Mining

Can Data Mining Aid with Off-Page SEO Strategies?

10 Min Read
using data mining to learn more about customers
Big Data

3 Data Mining Tips for Companies Trying to Understand their Customers

6 Min Read
surveys data
Data Mining

5 Data Mining Tips to Leverage the Benefits of Surveys

11 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots
ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?