Question

Describe a business situation in which a relational database would be the better option than Hadoop and explain why (give at least three reasons)

Answer 1

So, you are basically fascinated when a relational database can be a better choice than Hadoop. For simplicity purposes, I will break this discussion in parts.

PART ONE: HADOOP VS RDBMS

Hadoop is an open-source framework that allows distributed file storage and is capable of processing huge amounts of data whereas RDBMS stands for the relational database management system. It is based on the relational model specified by F. Codd.

Hadoop supports HQL(Hive query language) while RDBMS Supports SQL.

PART TWO: WHEN RDBMS CAN PERFORM BETTER

Since every good thing has a bad side and every bad thing has a good side. Let us start our analysis with this phrase.

RDBMS and Hadoop both are a tool for solving and managing real-life problems/applications. RDBMS is a convenient tool that is being used from later times which has common elements as rows, columns, tuples, etc.

As per my analysis,

RDBMS CAN PERFORM BETTER WHERE:

* Security Concerns are more: In the HADOOP Security model, it is disabled by default due to sheer complexity. If there are chances that the servers running HADOOP are not configured after installation, there is a huge risk of security and this can't be compromised.

* HADOOP is highly vulnerable as the framework is written mostly in JAVA and that has been exploited very frequently by cybercriminals in the past.

* HADOOP is not suitable for small data applications. Due to its high capacity architecture, Hadoop Distributed File System lacks the ability to efficiently support the random reading of small files. As a result, it is not recommended for organizations with small quantities of data.

* STABILITY ISSUES: Since it is an open-source framework, it is always attached to stability issues. Organizations are strongly advised to use the latest version which becomes quite hectic after a time.

I believe these are the scenarios where HADOOP lacks and our conventional RDBMS is better even after having multiple disadvantages.

Thanks and all the best :)

Please don't forget to thumbs up if it really helped you.