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.
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.
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.
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.
SAP Experts are here to help.
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: