Difference between RDBMS table and column - oriented data store

We all know how data is stored in any RDBMS table. It looks like this:

ID

Column_1

Column_2

Column_3

Column_4

1

A

11

P

XX

2

B

12

Q

YY

3

C

13

R

ZZ

4

D

14

S

XX1

 

The column ID is used as a unique/primary key of the table to access data from other columns of the table. But in a column-oriented data store like HBase, the same table is divided into key and value and is stored like this:

Key Value
Row Column Column Value
1 Column_1 A
1 Column_2 11
1 Column_3 P
1 Column_4 XX
2 Column_1 B
2 Column_2 12
2 Column_3 Q
2 Column_4 YY
3 Column_1 C
3 Column_2 13
3 Column_3 R
3 Column_4 ZZ

In HBase, ...

Get Modern Big Data Processing with Hadoop now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.