The relational databases normally use row-based data storage. But, column-based data storage may be more suitable for several business applications. Conceptually a database table is a two dimensional structure comprises of cells which are arranged in rows and columns. But the computer memory is structured linearly. So, there are two options available for the sequences of cell values stored in adjoining memory locations – Row storage and column storage.

  • Row Storage – It is the data sequence comprising the data fields in one table row.
  • Column Storage – This data sequence consists of the entries in one column.

 

The traditional database stores data simply in rows. But the SAP HANA in memory database stores data in both ways – rows and columns. Using this combination of both storage approaches SAP HANA produces high speed, performance and flexibility of the database. For in depth knowledge one should go through a proper SAP HANA training. The OLAP queries on large amounts of data take much time because every row is touched to gather the data for the query response. In the columnar tables, these information is stored physically next to each other. It increases the speed of certain data queries significantly. In this case data is compressed and takes less loading time.

Column storage technique is most effective for the OLAP queries because queries get few attributes from every data entry. But for the traditional OLTP queries, it is more beneficial to store all attributes side by side in a row tables. SAP HANA combines the benefits of both row storage and column storage tables.

To acquire more knowledge on SAP HANA contact us for SAP HANA online training. Our outstanding SAP HANA online training will make you understand the applications of HANA very easy with our unique techniques. We also provide digital study materials to our learners. Register and Join our free demo classes on SAP HANA online training.