What is SAP HANA?
SAP HANA, short for "High-Performance Analytic Appliance" is an in-memory data platform developed by SAP SE. It supports massively parallel transactions. It combines row-based, column-based and object-based storage techniques to squeeze the maxim out of multicore processors, thus, enabling very fast query execution. It is integrated with custom tuned servers hardware to support real-time analytical processing and calculations.
SAP HANA is designed to replicate and ingest structured data from SAP and non-SAP relational databases quickly. The main idea is that the replicated data is stored in RAM providing near real-time analytical transactoins by applications that sit on top of HANA.
What about UI?
SAPUI5 is the best solution to deal with SAP products, it is a user interface technology used to build and adapt client applications. It is a client-side HTML5 rendering library with a rich set of standard and extension controls and a lightweight programming model. The client-side rendering library provides a rich set of controls. You can extend these controls as well as develop new custom ones. Many features are provided to enable developers to easily create and extend state-of-the-art user interfaces:
How is SAP HANA different From Competing Offerings from Oracle?
- CSS3, which allows designers to work in an effective manner.
- It is based on an extensibility concept regarding custom controls.
- It uses the open source jQuery library as a foundation
- It fully supports SAP product standards.
- It is produced in a release independent code line to enable short shipment cycles.
Oracle Exalytics is an in-memory analytic appliance created by Oracle in 2011. The main diffrence compared to SAP HANA is that Exalytics was designed to run on Sun-only hardware, the risk of vendor lock-in is high, and the cost is significantly higher than comparable HANA deployments.
What is R?
R is an open source programming language and software environment for statistical computing and graphics.
The goal of the integration of the SAP HANA database with R is to get the power of statistical and analytical functionalities from R code in SAP HANA database context. SAP HANA database allows R code to be processed in-line as part of the overall query execution plan. This allows developers to use huge set of statistical functions in SAP HANA.
The R code is embedded in SAP HANA SQL code in the form of a RLANG procedure to be processed in SAP HANA database context. This allows the application developer to elegantly embed R function definitions and calls within SQLScript and submit the entire code as part of a query to the database.