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.
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
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.