HANA (High performance Analytical Appliance) is a new In-Memory data management appliance released by SAP which is more of separate plug-in (Software & Hardware) for faster analytical activities. This application allows processing of massive quantities of real time data in the main memory of the server to provide immediate results for analysis.
HANA is a pre-configured analytic appliance. SAP’s hardware partners provide the hardware and pre-install the SAP in-memory solution on that hardware.
Data is replicated from SAP or Non-SAP sources into HANA. For SAP Business Suite, there is a Replication Server & Agent that come along with HANA to transmit the data. For Non-SAP, Business Objects DATA Services tool can be used to replicate the data into HANA.
HANA has a Row store and Column Store for storing the data in relation and columnar format respectively. Columnar database is proven concept for high performance analytics. Introduction of calculation and aggregation engine at the database level is a huge advance in processing.
SQL and MDX processors are responsible for parsing SQL and MDX query requests and processing them.
HANA currently supports few clients like BO Explorer, Microsoft excel etc.
SAP HANA Studio is front-end which facilitates Data Modelling and administration.
HANA 1.0 doesn’t support ABAP. It supports few clients like SAP BWA (BW Accelerator), Microsoft Excel, SAP Business Object Analysis, MS Edition for Office. HANA 1.5 will support ABAP Programming/reporting which would mean that ABAP developers can write code to read/modify data in HANA Appliance.
Traditional ABAP Programming style is more inclined towards reducing the load on Database and shifting the processing to Application server. This is more to do with Data Storage models and SAP 3-tier system architecture provided another layer for data processing. This restricted ABAP developers to confine to the concept of “pulling required data to Application server and processing data in App Server” and along came the complexities of buffering.
With the introduction of HANA, data is available in volatile memory so data can be retrieved and processed in same “memory”. At first thought, this gives a feeling that ABAP OpenSQL Programming style should be changed and some of the “banned” OpenSQL statements like ‘Order By’ etc should come back in to use. Well, Hold on!! Let’s not jump into conclusions, let’s analyze some specific scenarios from HANA perspective and decide on this –
After analyzing some of the basic programming scenarios, programming with HANA seems to be a complete different world that ABAP developers should watch out for. While the database programming best practices still hold, developers will have the flexibility to utilize data processing statements which were considered expensive without HANA. Another completely new dimension to ABAP Programming will be columnar database concept which is also a part of HANA appliance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 524 | |
| 263 | |
| 238 | |
| 234 | |
| 167 | |
| 157 | |
| 152 |