How Does Sap Hana Support Massively Parallel Processing?

1.	How Does Sap Hana Support Massively Parallel Processing?
Answer» With availability of Multi-Core CPUs, higher CPU execution speeds can be achieved. Also, HANA Column-based storage makes it easy to EXECUTE operations in PARALLEL using multiple processor cores. In a column store data is already vertically partitioned. This means that operations on different columns can easily be processed in parallel. If multiple columns NEED to be SEARCHED or aggregated, each of these operations can be assigned to a different processor core. In addition, operations on ONE column can be parallelized by partitioning the column into multiple sections that can be processed by different processor cores. With the SAP HANA database, queries can be executed rapidly and in parallel.

Answer»

With availability of Multi-Core CPUs, higher CPU execution speeds can be achieved.
Also, HANA Column-based storage makes it easy to EXECUTE operations in PARALLEL using multiple processor cores.
In a column store data is already vertically partitioned. This means that operations on different columns can easily be processed in parallel. If multiple columns NEED to be SEARCHED or aggregated, each of these operations can be assigned to a different processor core.
In addition, operations on ONE column can be parallelized by partitioning the column into multiple sections that can be processed by different processor cores. With the SAP HANA database, queries can be executed rapidly and in parallel.

Discussion