|
|
RDBMS
|
HADOOP
|
|
Data
size
|
Gigabytes
|
Petabytes
|
|
Access
|
Interactive
and batch
|
Batch
|
|
Updates
|
Read
and write many
|
Write
and read many
|
|
Structure
|
Static
schema
|
Dynamic
schema
|
|
Integrity
|
High
Normalisation
|
Low
Normalisation
|
|
Scalling
|
Non
Linear
|
Linear
|
Showing posts with label RDBMS. Show all posts
Showing posts with label RDBMS. Show all posts
Monday, 15 February 2016
What is Differences between Hadoop and RDBMS ?
What is differences between Apache Hive and RDBMS ?
What is differences between Apache Hive and RDBMS ?
Hive
|
RDBS
|
SQL
Interface
|
SQL
Interface
|
Focus
on analytics
|
May
focus on online or analytics.
|
No
transactions.
|
Transactions
usually supported.
|
Partition
adds, no random INSERTs. In‐Place
updates not natively supported
(but
are possible).
|
Random
INSERT and UPDATE supported.
|
Distributed
processing via map/reduce.
|
Distributed
processing varies by vendor
(if available).
|
Scales
to hundreds of nodes
|
Seldom
scale beyond 20 nodes
|
Built
for commodity hardware
|
Often
built on proprietary hardware (especially
when scaling out).
|
Low
cost per peta byte.
|
What’s
a peta byte? J
|
Subscribe to:
Posts (Atom)