35 / 577
35
PUBLIC
© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ
Column “Artist”
(uncompressed)
sorted
Value ID implicity given by
sequence in which values are
stored
Value-ID sequence
One element for each row in
column
ID
Artist
Genre
Title
1
Adele
soul
Rolling In The
Deep
2
Lady Gaga
pop Born this way
3
Katy Perry
house
E.T.
4
Jason Mraz
pop
I am yours
5
Adele
soul
someone like
you
6
Lady gaga
pop
Pockerface
7
Katy Perry
pop
Part of me
8
Bruno Mars
pop
Just the Way
You Are
9
Jason Mraz
Pop
Lucky
10
Katy Perry
pop
Wide awake
Value ID
value
1
Adele
2
Bruno Mars
3
Jason Mraz
4
Katy Perry
5
Lady gaga
Dictionary
row
id
Value
id
1
1
2
5
3
4
4
3
5
1
6
5
7
4
8
2
9
3
10
4
This compression technology is called the
Dictionary Compression
. By
default, all column store data are dictionary compressed. Other
compression operations are executed on top of the dictionary
compression.
SAP HANA Technology
Dictionary Compression