Home > Learn > Discussions
7 Replies Latest reply: Jan 9, 2014 11:24 AM by Erich Schneider RSS

HANA - Row Store and Column Store

prathyusha rudraraju Newbie
Currently Being Moderated

Hi Experts,

 

Can you please help me to understand the exact difference between the Row Store and Column Store in HANA.

 

Thanks in Advance!

 

Regards,

Prathyusha.

  • Re: HANA - Row Store and Column Store
    Rajnesh Dharmat Newbie
    Currently Being Moderated

    Hi,

     

    Column Store: which tables are using for Analytic purpose like Dimension, Cubes, because for grouping and column functions.

     

    Row Store: it is actually OLTP purpose and like common RDBS tables for the purpose of OTLP transactions.

    Rajnesh

     

  • Re: HANA - Row Store and Column Store
    Ashok R K Newbie
    Currently Being Moderated

    Hi,

     

    Tables can be represented in row-order or column-order.   

    In row-order, table data is stored as a sequence of records. Whereas in column-order, the entries of a column are stored in contiguous memory locations.

     

    Colum-store supports parallel processing in HANA with it multi-core processors. Each core can handle a column or a single column can be processed by multiple cores. Columnar data storage allows high compression of data and is much faster in computing.

     

    Regards,

    KoasH

     

     

  • Re: HANA - Row Store and Column Store
    Newbie
    Currently Being Moderated

    In Traditional Computing you use the Row store..

     

    In HANA - In Memory Computing,

    95% Column Store.

    5% Row Store.

  • Re: HANA - Row Store and Column Store
    prathyusha rudraraju Newbie
    Currently Being Moderated

    When we are migrating the SAP system - from Oracle database to HANA Data Base then the table's of SAP will be replicated to HANA Database, so at that time how should we decide that a particular table to be stored as a "Column Store" or "Row Store"?

  • Re: HANA - Row Store and Column Store
    Newbie
    Currently Being Moderated

    Hi ,

     

    Conceptually, a database table is a two-dimensional data structure where the cells are organised in Rows and Columns. However as Computer memory is organized as a linear structure. To store a table in linear memory, two options exist, a row oriented storage stores a table as a sequence of records, each of which contain the fields of one row. Conversely, in a column store the entries of a column are stored in contiguous memory locations.

     

     

     

    Row Store

    It is good for Write operations and if we want to do reporting on all the columns then the row store is more suitable because reconstructing the complete row is one of the most expensive column store operations.

     

     

     

    Column Store

     

     

    It is good for Read operations and if we want to fill the table with huge amounts of data, that should be aggregated and analysed then a column store is more suitable.

     

  • Re: HANA - Row Store and Column Store
    Erich Schneider SAP Employee
    Currently Being Moderated

    Prathyusha,

     

    additional information you might find useful, is being discussed in this blog, and explained in Hasso Plattner's comments

    HANA, Columns, and OLTP

     

    thank you

    erich

More Like This

  • Retrieving data ...

Legend

  • Correct Answers - 4 points
  • Helpful Answers - 2 points

Contact Us

SAP Experts are here to help.

Ask SAP HANA

Our website has a rich support section designed to help you get the highest quality answers quickly and easily. Please take a look at the options below to get you answers from the SAP experts.

If you have technical questions:

If you're looking for training materials or have training questions:

If you have certification questions:

Χ