The main SAP HANA management element is thought because the index server, that contains the particular information stores and also the engines for process the info.
The index server processes incoming SQL or MDX statements within the context of genuine sessions and transactions.
The SAP HANA info has its own scripting language named SQLScript. SQLScript embeds data-intensive application logic into the info. Classical applications tend to dump solely terribly restricted practicality into the info victimization SQL.
In addition to SQLScript, SAP HANA supports a framework for the installation of specialized and optimized practical libraries, that square measure tightly integrated with totally different information engines of the index server.
2 of those practical libraries square measure the SAP HANA Business operate Library (BFL) and also the SAP HANA prophetic Analytics Library (PAL).
BFL and PAL functions may be referred to as directly from inside SQLScript. SAP HANA conjointly supports the event of programs written within the R language.
SQL and SQLScript square measure enforced employing a common infrastructure of inbuilt information engine functions that have access to numerous meta definitions, like definitions of relative tables, columns, views, and indexes, and definitions of SQLScript procedures.
This data is kept in one common catalog. The info persistence layer is to blame for the sturdiness and atomicity of transactions.
It ensures that the info may be rehabilitated to the foremost recent committed state when a restart in which transactions square measure either fully dead or fully undone.
The System design summary
An SAP HANA system contains multiple isolated databases and should contain one host or a cluster of many hosts.
An SAP HANA system is known by one system ID (SID) and contains one or additional tenant info and one system database. Databases square measure known by a SID and an info name.
From the administration perspective, there’s a distinction between tasks performed at the system level and people performed at the info level.
Info shoppers, like the HANA cockpit, hook up with specific databases.
The SAP HANA XS advanced application server may be a layer on high of SAP HANA that has the platform for running SAP HANA-based net applications.
It’s AN integral a part of the SAP HANA system. A system could contain one host or a cluster of many hosts.
This can be mentioned as a multiple-host, distributed system, or scale-out system and supports quantifiability and handiness.
The SAP HANA preparation Infrastructure provides a service that permits you to deploy info development artifacts to supposed containers.
This service includes a family of consistent design-time artifacts for all key SAP HANA platform info options that describe the target (run-time) state of HANA info artifacts, for example, tables, views, or procedures. These artifacts square measure sculpturesque, staged (uploaded), built, and deployed into SAP HANA.
The system service broker is employed to make and drop HDI instrumentations; every HDI instrumentation contains design-time instrumentation (DTC) and a run-time container (RTC).
The HDI preparation tools deploy info artifacts to AN HDI instrumentation. Design-time info objects square measure generally set within the dB/ folder of the appliance design-time hierarchy.
The preparation method populates the info run-time with the desired catalog objects.
Additionally, to info artifacts, HDI conjointly permits you to import and export table content like business configuration information and translatable texts.