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