Oracle vs. Hadoop

Posted by tib on April 16th, 2019

Although Hadoop and big data (whatever that is) are the new kids on the block, don’t be too fast to write off relational database technology. In this article, the differences (and benefits) of both solutions.

Hadoop is not a Database!

As much because the marketing plus would have us believe, Hadoop isn't a database, however a collection of open-source software that runs as a distributed storage framework (HDFS) to manage very large information sets. Its primary purpose is that the storage, management, and delivery of data for analytical functions. It’s hard to talk regarding Hadoop without getting into keywords and jargon (for example, Impala, YARN, Parquet, and Spark), so start by explaining the basics.

Hadoop could be a totally different reasonably Animal

It’s impossible to really understand Hadoop without understanding its underlying hardware architecture, which gives it 2 of its biggest strengths, its measurability and large data processing (MPP) capability.

To illustrate the distinction, the diagram below illustrates a typical database design during which a user executes SQL queries against one massive database server. DespiteOracle Training in Marathahalli refined caching techniques, the largest bottleneck for many Business Intelligence applications remains the power to fetch information from disk into memory for processing. This limits each the system process and its ability to scale — to quickly grow to affect increasing information volumes.

As there’s one server, it also needs expensive redundant hardware to ensure availability. This can embody dual redundant power supplies, network connections and disk mirroring that, on very massive platforms will build this an expensive system to create and maintain.

Compare this with the Hadoop Distributed design below. In this resolution, the user executes SQL queries against a cluster of commodity servers, and also the entire method is run in parallel. As effort is distributed across many machines, the disk bottleneck is less of a problem, and as information volumes grow, the answer is extended with further servers to hundreds or even thousands of nodes.

Hadoop has automatic recovery in-built such that if one server becomes unavailable, the work is automatically redistributed among the extant nodes, that avoids the large value overhead of an expensive standby system. This may result in a large advantage in availability, as one machine is taken down for service, maintenance or an operating system upgrade with zero overall system time period.

The 3 Vs and the Cloud

Hadoop has many alternative potential benefits over traditional RDBMS most often explained by the 3 (and increasing) Vs.

  • Volume — it’s distributed MPP architecture makes it ideal for dealing with large data volumes.
  • Variety — not like an RDBMS wherever you would like to define the structure of your information before loading it, in HDFS, loading information is as easy as repetition a file – which can be in any format. This means Hadoop will just as simply manage, store and integrate data from a database extract, a free text document or maybe JSON or XML documents and digital photos or emails.
  • Velocity — once more the MPP architecture and powerful in-memory tools (including Spark, Storm, and Kafka), which kind part of the Hadoop framework, build it a perfect solution to deal with real or near-real-time streaming feeds that arrive at velocity. This suggests you can use it to deliver analytics-based solutions in real time. As an example, using prophetic analytics to advocate choices to a client.

The advent of The Cloud ends up in a fair larger advantage (although not another “V” during this case) — physical property.

That’s the ability to supply on-demand scalability using cloud-based servers to affect unexpected or unpredictable workloads. This means entire networks of machines will spin up as needed to deal with huge data processing challenges whereas hardware prices are restrained by a pay-as-you-go model. Of course, in a extremely regulated business (e.g. monetary Services) with highly sensitive information, the cloud may well be treated with suspicion, in which case you may need to consider an "On-Premises Cloud"-based resolution to secure your data.

Column based Storage

As if the hardware benefits weren't already compelling, Hadoop may also natively column based storage which gives analytic queries a massive performance and compression advantage. This technique has been adopted a number an information Warehouse databases including the incredibly quick Vertical.

Bigger, Faster, Cheaper: What’s the Catch?

To start, you would like to choose the right tool for the job. Throughout this text, I’ve repeatedly talked about Analytics, information warehousing, and Business Intelligence. That’s as a result of Hadoop isn't a standard information, and isn't appropriate for dealings Oracle Training in Marathahalli with Placement process tasks — as a back-end information store for screen-based dealings systems.

This is as a result of Hadoop and HDFS don't seem to be ACID compliant. This means:

  • A — Atomic: once change information, all elements of the modification can complete or none at all. as an example, an update touching each client and their SALES history will be committed along. Not thus on HDFS.

•C — Consistent: once dealing completes, all information are going to be left in an exceedingly consistent state.

•I — Isolation: Changes made by other users are proscribed in isolation that in Oracle implies browse consistency — any given user can see an even read of the information at that time in time.

•D — Durable: when a change is applied it'll be durable, and if the system fails mid-way through a change, the partial changes will be rolled-back throughout system recovery.

In fact, Hadoop sacrifices ACID compliance in favor of turnout. It’s additionally designed to trot out massive data volumes, and also the smallest typical unit of work is around 128Mb.


The fact is, Oracle isn't reaching to depart any time before long. It’s been the core enterprise information platform for over thirty years, and that’s not reaching to modification long.

Like it? Share it!


About the Author

Joined: April 4th, 2019
Articles Posted: 35

More by this author