Different types of engines in SAP HANA

SAP HANA Database System, there are three basic engines used to processes queries.SAP HANA hosts different types of processing engines that process and execute the models created in SAP HANA  Information Modeler. Each engine performs a specific function for a particular view in information modeling,.

Different types of Engines.

1. Join Engine
2. OLAP Engine
3. Calculation Engine

Join Engine – The join engine is used every time when an attribute view is created or used, or a join condition is applied in a native SQL command. If a calculation applies in an attribute view, the join engine along with calculation engine works to create that attribute view.

OLAP Engine – The OLAP engine is for the creation of analytical views. It is used only when attributes are used in the analytical view and no calculation is done. If operations like calculations, counters, restricted measures are used then other engines like a calculation engine is used along with the OLAP engine.

Calculation Engine – The calculation engine is for calculation along with using in other views like analytical and attribute view whenever they apply calculation. The calculation engine might also need other engines to work with it such as OLAP and join engine.