Summary about HANA Query execution and optimization - Good to know about SAP HANA

Today I am going to discuss how when a query executed in SAP HANA, How it is processed and Optimized and generated a plan and push to a engine. This concept is will help you to optimize HANA Query in latter stage.

The summary architectural diagram is given below which is provided by SAP in the below URL –

Automating SAP HANA Scale out System with Non-shared Storage

This document demonstrates the steps required to automate the installation of an SAP HANA scale out system with non-shared storage. Participating hosts have the mandatory file systems (XFS) mounted locally, such as /usr/sap, /hana/data/, and /hana/log.

For this demonstration, two nodes have been considered, but the design can be scaled up as needed. The only file system that is shared between the hosts is /hana/shared.

The generated template can be extended with other automation scripts (refer section: Extension) for provisioning the systems automatically using Terraform in AWS.

Create a XSJS application consume calculation view and sent it to Https in HANA XSA

In this section I will discuss about the create a XSJS application consume calculation view and sent it to Http response to SAPUI5 in SAP HANA XSA using WEB IDE.

Architecture:

Expose Calculation view as a service via OData in HANA XSA using Web IDE

In this blog I am going to discuss how we can  expose Calculation view as a service via OData in HANA XSA using Web IDE. Then  either you can consume it in SAPUI5 or other front end interface applications.

Before that we need to understand the architecture of HANA XSA  which is given below –

SAP HANA Cloud Document Store – Enabling JSON Document Store

Introduction

SAP HANA has well known Row and Document Stores, allowing us to store relational data in Tables and process that data using HANA’s various engines including graph and spatial

SAP HANA actually offers a third store – the JSON Document Store. With the SAP HANA Cloud Document Store (DocStore), we can store JSON Documents in Collections within HANA itself, then process that data using the same SAP HANA engines

ArcGIS on the HANA Platform – putting the pieces together

This series, we looked at how the HANA platform’s capabilities reduce technical debt and complexity by eliminating the need for ETL when integrating your SAP S/4HANA and ArcGIS Enterprise systems.

SAP HANA Cloud Document Store – HANA DocStore First Steps

Introduction

In this blog post, we’re going to walk through some of the technical details around how we interact with the SAP HANA DocStore

JSON Collections

While the Column and Row Stores use Tables to store data, the Document Store uses a JSON Collection