SAP HANA: Main Concepts

 

1.     Column Store

a.     Tuple = basically a record

b.     Row store = best for write

c.  Column store = best for read

2.     Compression

3.     Partitioning

4.     Insert only on Delta

a.     Main Store (read-optimized, sorted columns)

b.     Delta Stores (write-optimized, non-sorted columns or rows)

a.  Delta 1 Store

b.  Delta 2 Store

c.   Delta Merge = merged Delta Stores into Main Store

1.     Minimum Memory Required

2.     current main + future main + current delta + additional memory