What is Column based Storage in HANA database ?

Column Based Storage Databses:

Pic: Row and column-based storage


Columnar Data Storage in HANA:
The concept of columnar data storage has been used for quite some time. Historically it was mainly 
used for analytics and data warehousing where aggregate functions play an important role. Using 
column stores in OLTP applications requires a balanced approach to insertion and indexing of column 
data to minimize cache misses.
The SAP HANA database allows the developer to specify whether a table is to be stored column-wise 
or row-wise. It is also possible to alter an existing table from columnar to row-based and vice versa.

Advantages of Column based tables:
 Calculations are typically executed on single or a few columns only.
 The table is searched based on values of a few columns.
 The table has a large number of columns.
 The table has a large 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).



Tags: Columnar Data Storage in HANA, What is Column based Storage in HANA database, Row and column-based storage, Row versus column-based storage, HANA Column based tables

Share this article :

Post a Comment

 
Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved