Design Tips for Getting the Most Out of HANA

  • by Abhishek Gundala, Manager, Capgemini
  • Bharath Nagaraj, Senior Consultant, Capgemini SAP Service
  • July 7, 2014
Learn how to get the best out of your SAP Business Suite on HANA with these step-by-step guidelines. A comparison of five methods of reporting shows how to take advantage of the in-memory database in ABAP applications.
Learning Objectives

Reading this article, you will learn how to:

  • Run traces to identify performance-intensive code segments
  • Identify potential code segments that can be moved from the ABAP layer to the database layer
  • Transform ABAP code into attribute views, analytic views, calculation views, and database procedures and then compare the performance improvements
Key Concept

Upgrading to SAP Business Suite on HANA makes your existing applications run faster compared with the traditional disk-based database with row-based data storage. On a high level, SAP HANA is similar to any other database, only faster because of its in-memory functionality with column-based data storage. It understands SQL and has Java Database Connectivity (JDBC) and Open Database Connectivity (ODBC) libraries. After making the switch to the SAP HANA database, you can run all your existing applications without making any changes. However, to leverage the full potential of the SAP HANA database, some design changes are needed.

SAP HANA is a lot more than just a database. It offers a full-blown application development platform. This presents a radical paradigm shift from traditional SAP application development where all the data is fetched from the database layer, and logic resides in the application layer to do computations and analysis. In this new paradigm, all the data-intensive operations can be pushed to the database layer and only the results are passed back to the application layer. This eliminates the need to transfer huge amounts of data from the database layer to the application layer and also takes advantage of the built-in parallel processing capabilities of SAP HANA. This results in a significant performance boost.

However, existing applications do need some redesign to take full advantage of the capabilities of SAP HANA. We show how to leverage the different capabilities of SAP HANA and transform an ABAP application designed and developed to run on a traditional database into an application that uses all the potential of SAP HANA.

Abhishek Gundala

Abhishek Gundala is a manager at Capgemini and has more than 10 years of experience in SAP CRM and ECC. He has strong expertise in CRM WebClient UI, Object Oriented ABAP, and HANA. His experience includes multiple full life-cycle SAP implementations including upgrades to HANA spanning the Media, Services, and Defense industries. Over the years, he played multiple roles as a developer, team lead, technical architect, and project manager.
 
 

See more by this author

Bharath Nagaraj

Bharath Nagaraj is a senior consultant with Capgemini SAP Service line. Bharath has been working as an SAP CRM consultant for the past seven years. His areas of expertise are SAP CRM Marketing, Sales and Service, and CRM Web Client UI. He is knowledgeable about ABAP on HANA, HANA modeling, UI5, and SAP FIORI.

See more by this author


Comments

7/10/2017 5:57:08 PM
Bryan Pierce

There is no coding example for ZHANA_DEMO.

Please log in to post a comment.

To learn more about subscription access to premium content, click here.