Comprehensive Performance, Functional, and Deployment Best Practices for SAP HANA: Comparing Scale Up and Scale Out Architectures in Enterprise Environments

Sankar Thambireddy; Venkata Ramana Reddy Bussu; Phani Santhosh Sivaraju

Comprehensive Performance, Functional, and Deployment Best Practices for SAP HANA: Comparing Scale Up and Scale Out Architectures in Enterprise Environments

Authors

Sankar Thambireddy

SAP America Inc, United States

Venkata Ramana Reddy Bussu

CodeTech Inc (DTE Energy), United States

Phani Santhosh Sivaraju

Amazon, United States

Keywords:

SAP HANA, in-memory databases, scale-up architecture, scale-out architecture, enterprise deployment.

Synopsis

The speed of embracing in-memory computing infrastructures has revolutionized in managing data at enterprises, and SAP HANA has become one of the most robust and highly implemented solutions to provide real-time analytics and transactional processing. Some of the most important architectural choices that organizations that undertake SAP HANA have to make are the selection of the deployment model of scale-up or scale- out. Both methods have different implications on performance optimization, cost efficiency, hardware usage, workload distribution as well as long term scalability. In this paper, the best practices, functionality, and performance aspects of SAP HANA implementation will be thoroughly analyzed, and the advantages and disadvantages of the scale-up and scale-out models in enterprise systems will be compared.
This paper is a synthesis of current theoretical and empirical results, and it explores the interaction of the in-memory columnar design of SAP HANA with the contemporary hardware infrastructures to accommodate the needs of the enterprise workloads. Recommendations on best practice are made based on assessment of deployment approaches in cloud and on-premises environments where reliability, elasticity, fault tolerance and workload optimization are the key concerns. The paper also incorporates the case-based knowledge, benchmarks, and architecture to demonstrate the ways organizations can maximize their returns on investments and remain operational at the same time.
This study will inform the decision-makers of the enterprise in terms of aligning the SAP HANA plans with the organizational needs so that the near-term efficiency and the long-term flexibility are achieved. Finally, the results are relevant to the general knowledge of enterprise data platforms and the changing status of in-memory computing as part of the digital transformation.

References

[1] Abadi, D. J., Madden, S. R., & Hachem, N. (2008). Column-stores vs. row-stores: How different are they really? Proceedings of the ACM SIGMOD International Conference on Management of Data, 967–980. https://doi.org/10.1145/1376616.1376712

[2] Al-Allawee, A., Lorenz, P., Abouaissa, A., & Abualhaj, M. M. (2023). A performance evaluation of in-memory databases operations in session initiation protocol. Network, 3(1), 1–20. https://doi.org/10.3390/network3010001

[3] Alhajj, R., & Rokne, J. (2020). Cloud-based in-memory columnar database architecture for large-scale data analytics. Journal of Information Systems, 34(3), 245–259. https://doi.org/10.2308/isys-19-060

[4] Amazon Web Services. (2021). Best practices for deploying SAP HANA on AWS. AWS Whitepaper. https://d1.awsstatic.com/whitepapers/sap-hana-on-aws-best-practices.pdf

[5] Buragohain, C., & Venkatraman, S. (2019). A1: A distributed in-memory graph database for real-time analytics. ACM Transactions on Database Systems, 44(3), 1–28. https://doi.org/10.1145/3341189

[6] Cha, S. K., & Kim, K. H. (2013). Relational OLAP on in-memory columnstore: Performance study. Proceedings of the IEEE International Conference on Big Data, 575–582. https://doi.org/10.1109/BigData.2013.6691617

[7] Diaconita, V., & Tudoran, R. (2019). Performance considerations for in-memory database deployments in the cloud. Future Generation Computer Systems, 100, 636–646. https://doi.org/10.1016/j.future.2019.05.041

[8] Ding, B., Kulkarni, K., & Xu, J. (2019). Distributed query processing on large-scale in-memory clusters. Proceedings of the ACM SIGMOD International Conference on Management of Data, 1393–1408. https://doi.org/10.1145/3299869.3319867

[9] Färber, F., & Cha, S. K. (2011). SAP HANA database — In-memory data management for business applications. ACM SIGMOD Record, 40(4), 45–51. https://doi.org/10.1145/2094114.2094126

[10] Färber, F., Cha, S. K., Primsch, J., Bornhövd, C., Sigg, S., & Lehner, W. (2012). SAP HANA database: Data management for modern business applications. ACM SIGMOD Record, 40(4), 45–51. https://doi.org/10.1145/2094114.2094126

[11] Harikrishna Madathala and BalamuralikrishnanAnbalagan, "SAP Data Migration For LargeEnterprises: Improving Efficiency in ComplexEnvironments," Webology, vol. 12, no.2,2015.[Online].Available:https://www.webology.org/data-cms/articles/20241008014927pmWEBOLOGY%2015%20(2)%20-%2029.pdf

[12] Grund, M., Krüger, J., Plattner, H., Zeier, A., Cudre-Mauroux, P., & Madden, S. (2010). HYRISE: A main memory hybrid storage engine. Proceedings of the VLDB Endowment, 4(2), 105–116. https://doi.org/10.14778/1921071.1921077

[13] Jindal, A., Madden, S., & Stonebraker, M. (2019). Performance of database systems on modern multicore processors. Proceedings of the VLDB Endowment, 12(9), 1009–1022. https://doi.org/10.14778/3329772.3329775

[14] Kabakus, A. T., & Kara, R. (2017). A performance evaluation of in-memory databases. Journal of King Saud University – Computer and Information Sciences, 29(4), 484–492. https://doi.org/10.1016/j.jksuci.2016.02.002

[15] May, N., Bumbulis, P., Grund, M., & Zeier, A. (2017). SAP HANA: Data management for modern business applications. Proceedings of the VLDB Endowment, 10(12), 1780–1781. https://doi.org/10.14778/3137765.3137815

[16] Microsoft Azure. (2021). SAP HANA scale-up and scale-out architectures on Azure. Microsoft Corporation. https://learn.microsoft.com/azure/sap/workloads/sap-hana-scale-out

[17] Müller, S., Nica, A., Butzmann, L., Klauck, S., & Plattner, H. (2015). Using object-awareness to optimize join processing in the SAP HANA aggregate cache. Proceedings of the 2015 International Conference on Extending Database Technology (EDBT), 351–362.

[18] Plattner, H. (2009). A common database approach for OLTP and OLAP using an in-memory column database. Proceedings of the 2009 ACM SIGMOD International Conference on Management of Data, 1–2. https://doi.org/10.1145/1559845.1559846

[19] Plattner, H. (2013). A course in in-memory data management: The inner mechanics of in-memory databases. Springer. https://doi.org/10.1007/978-3-642-36524-9

[20] Plattner, H. (2014). The impact of columnar in-memory databases on enterprise systems: Implications for analytics and transactions. Communications of the ACM, 57(7), 58–65. https://doi.org/10.1145/2617633

[21] Plattner, H. (2015). The impact of in-memory databases on information systems: Past, present, and future. Business & Information Systems Engineering, 57(3), 141–145. https://doi.org/10.1007/s12599-015-0379-7

[22] Harikrishna Madathala, Balaji Barmavat, Krupa Satya Prakash Karey, Balamuralikrishnan, "AI-Driven Cost Optimization in SAP Cloud Environments: A Technical Research Paper", International Journal of Science and Research (IJSR), Volume 11 Issue 4, April 2022, pp. 1404-1412, https://www.ijsr.net/getabstract.php?paperid=SR241017125233, DOI: https://www.doi.org/10.21275/SR241017125233

[23] Harikrishna Madathala, Balamuralikrishnan Anbalagan, Balaji Barmavat, Prakash Krupa Karey, "SAP S/4HANA Implementation: Reducing Errors and Optimizing Configuration", International Journal of Science and Research (IJSR), Volume 5 Issue 10,October2016,pp.1997-2007, https://www.ijsr.net/getabstract.php?paperid=SR241008091409,DOI: https://www.doi.org/10.21275/SR241008091409

[24] Sherkat, R., Florendo, C., Andrei, M., Goel, A. K., Nica, A., May, N., … Bumbulis, P. (2016). Page as you go: Piecewise columnar access in SAP HANA. Proceedings of the 2016 International Conference on Management of Data (SIGMOD), 1271–1282. https://doi.org/10.1145/2882903.2903729

[25] Sherkat, R., Florendo, C., Andrei, M., Goel, A. K., Nica, A., May, N., … Bumbulis, P. (2016). Page-loadable column techniques and data-aging in SAP HANA. Proceedings of the 2016 International Conference on Management of Data (SIGMOD), 1271–1282. https://doi.org/10.1145/2882903.2903729

[26] Sikka, V., Färber, F., Lehner, W., Peh, T., & Plattner, H. (2012). SAP HANA: The evolution from a modern main-memory database to an enterprise application platform. Proceedings of the VLDB Endowment, 6(11), 1184–1185. https://doi.org/10.14778/2536222.2536251

[27] Souza, R., Tavares, R., da Silva, V. T., & Mattoso, M. (2021). SchalaDB: A distributed in-memory database for workflow executions. PeerJ Computer Science, 7, e430. https://doi.org/10.7717/peerj-cs.430

[28] Stonebraker, M., Abadi, D., Batkin, A., Chen, X., Cherniack, M., Ferreira, M., … Zdonik, S. (2005). C-Store: A column-oriented DBMS. Proceedings of the VLDB Endowment, 33(1), 553–564. https://doi.org/10.1145/1083592.1083658

[29] Wang, R., Xia, W., Wei, J., & Chen, J. (2021). The case for distributed shared-memory databases with memory disaggregation. Proceedings of the VLDB Endowment, 14(12), 3026–3033. https://doi.org/10.14778/3476311.3476362

[30] Zhang, S., Hellerstein, J., & Franklin, M. (2015). Scalable query execution in distributed in-memory databases. IEEE Transactions on Knowledge and Data Engineering, 27(9), 2529–2542. https://doi.org/10.1109/TKDE.2015.2415476