FlipBook

PUBLIC

SAP HANA Technology

Row Store vs. Column Store

Column Store

stores tables by column

Row Store

stores tables by row

Tuple1

Tuple2

• The application needs to

process only one single

record at one time

(many selects and /or updates of

single records).

• The application typically

needs to access the

complete record

• The columns contain mainly distinct values so

compression rate would be low

• Neither aggregations

nor fast searching are required

• The

table has a small number of rows

(for example

configuration tables)

•

Calculations are typically executed on single or few

columns only

•

The table is searched based on values of a few

columns

• The table has

a big number of columns

• The table has

a big number of rows and columnar

operations are required

(aggregate, scan, etc.)

•

High compression rates

can be achieved because the

majority of the columns contain only few distinct values

(compared to number of rows)

Att1

Att1 Att2

Att2