SAP HANA Extended Application Services

Model View Controller  development architecture

 Traditional  database application use interfaces such as ODBC and JDBC with SQL to manage  and query their data.

Traditional Database 

SAP HANA incredibly broadens the conventional database server part.

SAP HANA functions as  a comprehensive platform  for the development and execution  of native -data intensive  applications  that run  efficiently in SAP HANA , taking advantage  of its in-memory
architecture and parallel execution  capabilities.

By restructuring your application  in this way , not only  do you gain  from the increased performance due to the integration with the datasource and also effectively eliminate  the overhead  of the middle-tier between user interface (the view) and the data intensive control logic.

SAP HANA Extended Application

SAP HANA Extended application services provides a comprehensive set of embedded services that provide  end to end support for web based application

This includes a lightweight web server , configurable OData support , server side JS execution and also full access to SQL and SQL script.

Read More

SAP HANA Architecture

SAP HANA Database High-Level Architecture 

A running SAP HANA system consists  of multiple communicating processes .

Traditional database application use well- defined interfaces (for example ,ODBC and JDBC ) to communicate with the database management system  functioning as a datasource , usually over a network connection.

Traditional database are often running in the context of an application server , these traditional  application use structured query language (SQL) to manage  and query the data stored in the database.

The main SAP HANA database  management component is know as index server  which contains

• the actual data stores  and the engine  for processing the data.
• the index server processes incoming SQL or MDX statements.

The SAP HANA database has its own scripting language named SQL script. SQL Script embeds data - intensive  application logic into the database.

Classical application tend to offload only very few limited functionality  into the database using SQL.

This results in extensive copying of data from and to the database and in the programs that slowly iterate over huge data loops and are hard to optimize and parallelize.

SQL Script is based on side effect free  functions that operates  on tables using SQL queries for set processing  and is therefore parallelizable over multiple processors.

SAP HANA supports a framework  for the installation of specialized  and optimized functional libraries , which are tightly integrated  with different  data engines  of the index server.

SAP HANA also supports the development of programs written in R language.

SQL and SQL Script are implemented  using a common infrastructure  of built -in data engine functions that have access to various meta data  definitions , such as definitions  of relational tables, columns views, and indexes ,and definitions of SQLScript procedures . This meta data is stored in one common catalog.

The database persistence layer is  responsible for durability and atomicity of transactions . It ensures that database can be restored to  the most recent committed state after a restart and that transactions are completely  executed  or completely undone.

The Index server  uses  the preprocessor server for analyzing the data  and extracting the information on which  the text search capabilities are  based . The name server  owns the information about the the topology  of SAP HANA system.

In a disturbed system, the name server names  where the components are running and which data is located on which server.

Read More

Introduction to SAP HANA

HANA is moving SAP into top speed so don't get left in the dust.

SAP HANA is evolving into the leading technology platform: There are more than 1,200 start-ups from 57 countries building applications on SAP HANA.

SAP HANA is an in-memory data platform that is deployable as an appliance or in the cloud.

At its core, it is an innovative in-memory relational database management system that makes full sense of the capabilities of current hardware to increase application performance, to reduce cost of ownership, and to enable new scenarios and applications that were not possible before.

With SAP HANA, you have the opportunity to build applications that integrate the business logic, control logic, and the database layer with unprecedented performance.

As a developer, one of the key questions is how you can minimize data movements. The more you can do directly on the data in memory next to the CPU's, the better the application will perform.

Read More