Tuesday, May 19, 2015

Chapter2 :Column Oriented database


Column Oriented database

RDBMS

C1,C2,C3 = Columns
R1,R2,R3 = Rows
C1 C2 C3
A
100
HYD
B
200
BANG
C
300
Delhi
D
400
PUNE

R1 R2 R3
A
B
C
D
100
200
300
400
HYD
BANG
Delhi
PUNE
Here rows converted into column , column converted into rows......just to understand.
Timestamp will be provided by framework for each value.The reason to store values on column basis instead is based on the assumption is for specific queries not all the values needed. This is by it is analytical database and good for storing schema.



Directly fetching values no need of sequential accessing like RDBMS











A1000






No comments:

Post a Comment