EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

High-Performance In-Memory Computing: A Research Study on SAP S/4 HANA Database Layer

Trupti Raikar

American Journal of Technology · 2025

DOI: 10.58425/ajt.v4i2.449 ↗

Kurz gefasst

Fachartikel in der Zeitschrift American Journal of Technology, 2025. Verfasst von Trupti Raikar. Die Arbeit wurde bisher 1-mal zitiert (Crossref). Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Aim

The study aims to investigate how SAP S/4HANA’s in-memory database architecture achieves exceptionally high processing speeds by examining the HANA database layer, where most SAP system performance challenges originate. It further seeks to analyze how columnar storage, compression techniques, set-based programming, indexing, and data-partitioning strategies contribute to overall system efficiency, scalability, and real-time analytics.

Methods

The research is grounded in SAP HANA architecture documentation, S/4HANA developer manuals, and established performance-engineering literature. A practical assessment was conducted using representative SQL queries, CDS Views, and SQL Scripts executed directly on SAP HANA. Performance-analysis tools included ST05, ST12, SAT, DBACOCKPIT, and PlanViz to evaluate memory usage, indexing behavior, execution paths, and runtime performance.

Results

The study reveals that SAP S/4HANA’s columnar storage model significantly enhances selective data retrieval, while dictionary and vector-based compression reduce memory footprint and accelerate data access. Storing operational data entirely in main memory enables simultaneous execution of transactional and analytical workloads. Set-based processing through CDS Views and SQL Script is shown to outperform traditional ABAP loop-based logic, reinforcing the effectiveness of shifting computations to the database layer. Additionally, partitioning strategies such as round-robin, hash, and range partitioning enable parallel execution and even distribution of large datasets across processing threads, improving scalability and sustaining performance under heavy workloads.

Conclusion

The study concludes that SAP S/4HANA’s in-memory design combined with columnar processing, advanced compression, database-driven logic, and optimized indexing and partitioning forms the foundation of its real-time processing capability. Recommendation: To fully leverage S/4HANA’s performance potential, developers and solution architects should adopt set-based programming practices, apply appropriate indexing and partitioning strategies, and rely on database-side execution wherever possible.

Zitieren

APA

Raikar, T. (2025). High-Performance In-Memory Computing: A Research Study on SAP S/4 HANA Database Layer. American Journal of Technology. https://doi.org/10.58425/ajt.v4i2.449

Vancouver

Raikar T. High-Performance In-Memory Computing: A Research Study on SAP S/4 HANA Database Layer. American Journal of Technology. 2025. doi:10.58425/ajt.v4i2.449

BibTeX
@article{Raikar2025,
  author = {Raikar, Trupti},
  title = {High-Performance In-Memory Computing: A Research Study on SAP S/4 HANA Database Layer},
  journal = {American Journal of Technology},
  year = {2025},
  doi = {10.58425/ajt.v4i2.449}
}
Kostenlos starten →