Blogs tagged columnstore

PLAYING AROUNG WITH COLUMN TABLES IN HANA USING SQLs: Important tables which hold load status of column store table:M_CS_LOADS,M_CS_UNLOADS As a continuation to my previous blog below, here are the screen prints as of how to load or unload a table... Read More »

COLUMN STORE TABLES LOAD AND UNLOADS HANA will start to trigger a column store unload as soon as HANA nodes hits peak memory based on the LRU algorithm to full fill new memory requirement.Column store tables will get unloaded .We can also make a... Read More »

SAP HANA is a in-memory data platform. With SAP HANA, you can build applications that integrate the business control logic and the database layer with unprecedented performance. As a developer, one of the key questions is how you can minimize data... Read More »

Here is an attempt to explain the row store data layout, column store data layout and the data compression technique. Row Store : Here all data connect to a row is placed next to each other. See below an example. Table 1... Read More »

As I’ve been quite busy within the last year I didn’t find much time to contribute or share any breaking new for a while – even though the lack of spare time didn’t improve much recently it’s finally time to talk about... Read More »

One of the challenges I faced when working with an older release of BW was that there were no known cases of sizing methodology which would give enough confidence to determine the sizing for a target BW7.4 on HANA solution based on a source BW2.1c... Read More »