Scribd
Upload
46 views2 pages

RDBMS vs HBase: Key Differences

RDBMS is a row-oriented database requiring SQL and has a fixed schema, while HBase is a column-oriented database that does not require SQL and allows dynamic schema changes. RDBMS follows ACID properties and is static in nature, whereas HBase adheres to the CAP theorem, supports various data types, and is dynamic. HBase can handle sparse data and scale horizontally, unlike RDBMS which is limited by server configuration and primarily supports small tables.

Uploaded by

suj37874
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
46 views2 pages

RDBMS vs HBase: Key Differences

RDBMS is a row-oriented database requiring SQL and has a fixed schema, while HBase is a column-oriented database that does not require SQL and allows dynamic schema changes. RDBMS follows ACID properties and is static in nature, whereas HBase adheres to the CAP theorem, supports various data types, and is dynamic. HBase can handle sparse data and scale horizontally, unlike RDBMS which is limited by server configuration and primarily supports small tables.

Uploaded by

suj37874
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Difference between RDBMS and HBase:

S.
No. Parameters RDBMS HBase

It requires SQL (Structured Query SQL is not required in


1. SQL
Language). HBase.

It does not have a fixed


schema and allows for the
2. Schema It has a fixed schema.
addition of columns on the
fly.

Database It is a column-oriented
3. It is a row-oriented database
Type database.

RDBMS allows for scaling up.


Scale-out is possible using
That implies, that rather than
HBase. It means that, while
adding new servers, we should
we require extra memory
upgrade the current server to a
4. Scalability and disc space, we must add
more capable server whenever
new servers to the cluster
there is a requirement for more
rather than upgrade the
memory, processing power, and
existing ones.
disc space.

5. Nature It is static in nature Dynamic in nature

Data In RDBMS, slower retrieval of In HBase, faster retrieval of


6.
retrieval data. data.

It follows the ACID (Atomicity, It follows CAP


7. Rule Consistency, Isolation, and (Consistency, Availability,
Durability) property. Partition-tolerance) theorem.

It can handle structured,


8. Type of data It can handle structured data. unstructured as well as semi-
structured data.
S.
No. Parameters RDBMS HBase

9. Sparse data It cannot handle sparse data. It can handle sparse data.

In HBase, the .amount of


The amount of data in RDBMS is
Volume of data depends on the number
10. determined by the server’s
data of machines deployed rather
configuration.
than on a single machine.

In RDBMS, mostly there is a In HBase, there is no such


Transaction
11. guarantee associated with guarantee associated with
Integrity
transaction integrity. the transaction integrity.

When it comes to referential


Referential Referential integrity is supported
12. integrity, no built-in support
Integrity by RDBMS.
is available.

The data in HBase is not


normalized, which means
In RDBMS, you can normalize the there is no logical
13. Normalize
data. relationship or connection
between distinct tables of
data.

It is designed to
It is designed to accommodate accommodate large tables.
14. Table size
small tables.. Scaling is difficult. HBase may scale
horizontally.

You might also like