NoSQL

Relational vs Non-Relational data bases – Part 3

In the first and second part of this blog series, we saw some basic differences between the scalability of Relational and Non-Relational Databases. In this post, I will show you how to use these databases correctly, and also tell you about some well-known companies that use these databases.

Relational Database

In the first part of this blog series, I talked about ACID properties. These properties are important to maintain a tight transactional integration. There are some industries like banking, retail, etc., where each transaction requires ACID properties. In bank transactions, if one account is credited, another should be debited. The partial update is never allowed, as it will affect the data integrity — Oracle, SQL Server, MySQL, and other RDBMS are used in this scenario.

Non-Relational Database (NoSQL DB)

In the first part of this blog series, I also talked about BASE properties. These are important to keep data consistent across all nodes in a database. Any information that does not require strict data integrity can be stored in a NoSQL DB. For instance, contents of a Search Engine System can be stored in a non-relational database, because it is easy to retrieve information quickly. A good example of a search engine system is Google. Google usually stores its cached web pages in a web layer that is refreshed periodically. These databases can store terabytes of historical data (say credit card transactions of a bank, for the past 5 years) in a distributed environment. It is easy to do analyze and mine data in a NoSQL DB using SQL-Like HIVE data warehouse software. NoSQL DBs can be used to store massive volumes of unstructured data and are suitable for text analysis too.

I have listed some top organizations who use these databases:

Relational Databases

SQL Server: LG Electronics, MySpace, Hilton Hotels.

ORACLE: British Telecom, MasterCard, Reliance Ltd.

MySQL: Facebook, Twitter, LinkedIn. Facebook uses MySQL to store user interaction like status updates, shares, likes, etc.

Non-Relational Databases

CouchBase: LinkedIn, AdAction.

Cassandra: Facebook, Twitter, Digg.

MongoDB: LinkedIn, Pearson.

Neo4j: Cisco, eBay, etc.

As you have seen, companies like Facebook, Twitter, and LinkedIn use both Relational and Non-Relational Databases, based on their requirements.

Now let me return to the first part of this series, and answer the following questions:

Are relational databases capable of handling big data?

Are relational databases scalable?

Are relational databases suited for the modern age data requirements? Such as Real-time analytics, dealing with unstructured data?

The answer to all these questions is a vehement “YES”. Relational databases are not going away in this social world. Based on the nature and complexity of the data set, the right database should be used. Both Relational and Non-Relational Databases have their own advantages and disadvantages. The correct environment set up can make use of relational and non-relational databases in a proper way like how Facebook, Twitter, and LinkedIn have done it.

11 Comments
  1. Enhance Lip 3 months ago
    Reply

    Hey there, I think your website might be having browser compatibility
    issues. When I look at your blog site in Chrome, it looks fine but when opening in Internet Explorer,
    it has some overlapping. I just wanted to give you a quick heads up!
    Other then that, amazing blog!

  2. table builder 2 months ago
    Reply

    Very nice article, just what I needed.

  3. Pretty part of content. I simply stumbled upon your website and
    in accession capital to say that I acquire in fact loved account your blog posts.
    Any way I will be subscribing on your augment and even I
    success you get entry to persistently rapidly.

  4. Way cool! Some extremely valid points! I appreciate you penning this article plus the rest of the site is also
    really good.

  5. esta 2 months ago
    Reply

    WOW just what I was searching for. Came here by searching for esta

  6. event planning 1 month ago
    Reply

    That is very interesting, You’re a very professional blogger.
    I have joined your feed and stay up for looking for more of
    your fantastic post. Also, I’ve shared your website in my social networks

  7. I couldn’t refrain from commenting. Perfectly written!

  8. white feminism 1 week ago
    Reply

    Thanks designed for sharing such a good thinking, post
    is fastidious, thats why i have read it completely

  9. white feminism 1 week ago
    Reply

    I am sure this piece of writing has touched all the internet
    viewers, its really really pleasant post on building up
    new blog.

  10. Hi my friend! I wish to say that this post is awesome, nice written and include approximately all significant infos.
    I would like to see more posts like this .

  11. Thanks for sharing such a good idea, paragraph is fastidious,
    thats why i have read it entirely

Leave a Comment

Your email address will not be published.

You may also like

Pin It on Pinterest