Enhancing SAP HANA SQL Query Framework for Faster Processing and Cost Efficiency in SAP SuccessFactors Learning

Author(s)	Pradeep Kumar
Country	United States
Abstract	SAP SuccessFactors Learning, a legacy application built on Apache Tomcat and Java, was migrated from Oracle to SAP HANA, introducing significant challenges due to the differences in database execution engines. This paper proposes a dynamic SQL Converter framework that transforms Oracle-specific SQL queries into HANA-compatible queries at runtime, supported by a multi-level caching mechanism based on the Least Recently Used (LRU) policy. Performance tests with 10,000 concurrent users and 600 hits per second demonstrated a 15.6% reduction in CPU usage, a 12.5% decrease in JVM heap size, and a 12.7% improvement in response time. Future enhancements will explore AI/ML-driven caching strategies and further optimization for specific query types to ensure scalability and cost efficiency.
Keywords	SAP HANA, Oracle Database, SQL Conversion, LRU Cache, Multi-Cloud Applications, SAP SuccessFactors Learning
Field	Engineering
Published In	Volume 1, Issue 2, September-October 2019
Published On	2019-10-03
DOI	https://doi.org/10.36948/ijfmr.2019.v01i02.35769
Short DOI	https://doi.org/g82qxd

About IJFMR Fees & Payment Current Issue Publication Archive	Submit Research Paper Track Submission Status Publication Guidelines Publication Ethics Peer Review & Plagiarism	Join as a Reviewer Editors & Reviewers Reviewer Referral Program Get Reviewer Membership Certi.	Website/Journal Policies Usage Policy Content Policies Privacy Policy

Contact Us		+91-9687-828-838	editor@ijfmr.com

International Journal For Multidisciplinary Research