Real-Time Business Inteligence
A Technical Comparison of SAP HANA, Oracle, and SQL Server
Abstract
This article aims to analyze the technical and strategic differentials of the SAP HANA database, employed within the SAP S/4HANA system, in comparison with two major market competitors: Oracle Database and Microsoft SQL Server. The research adopted a qualitative approach with an exploratory and descriptive nature, based on a bibliographic survey conducted in recognized academic and technical repositories. The analysis considered aspects such as architecture, performance, scalability, data model, integration with analytical tools, and support for cloud computing. The results indicated that SAP HANA, by leveraging in-memory technology, outperforms traditional relational databases in terms of processing speed and real-time OLTP/OLAP integration, providing greater efficiency and analytical capability. The findings highlight that SAP S/4HANA represents a new paradigm in enterprise resource planning systems, aligned with the demands of digital transformation and the growing need for real-time business intelligence.
References
AMARASINGHE, S., QUAMRUZZAMAN, M., BILBAO, J., KO, S. BIPeC: A Combined Change-Point Analyzer to Identify Performance Regressions in Large-scale Database Systems. 2024. Disponível em: <https://arxiv.org/abs/2408.12414>. Acesso em: 21 mai. 2025.
BUCHER, T., GERTH, C., KUENG, P. Business Process Management: Theory and Applications. Berlin: Springer, 2015.
CHAUHAN, S., JAIN, S. SAP S/4HANA – An Overview and Its Implications for Businesses. International Journal of Computer Applications, v. 177, n. 19, p. 1–5, 2019.
CHUGH, R., GRANDHI, S. Examining the role of business intelligence systems in corporate sustainability. Journal of Cleaner Production, v. 279, 2021. Disponível em: https://doi.org/10.1016/j.jclepro.2020.123802. Acesso em: 16 mai. 2025.
DAVENPORT, T. H., HARRIS, J. G. Competing on Analytics: The New Science of Winning. Boston: Harvard Business Press, 2007.
DRUCKER, P. F. Management Challenges for the 21st Century. New York: HarperBusiness, 1999.
HADDAD, S., RODRIGUES FILHO, J. A evolução do SAP ERP e a importância da plataforma SAP NetWeaver. Revista de Administração e Inovação, v. 10, n. 3, p. 25–38, 2013.
KRISHNAN, R. SAP S/4HANA: An Introduction. SAP Press, Rheinwerk Publishing, 2015.
LAUDON, K. C., LAUDON, J. P. Sistemas de informação gerenciais: gerenciando a empresa digital. São Paulo: Pearson, 2021.
LENZ, C., SCHWINN, D. Data Management and Performance Optimization in SAP ERP. SAP Press, 2016.
MARR, B. Data Strategy: How to Profit from a World of Big Data, Analytics and the Internet of Things. London: Kogan Page, 2021.
McAFEE, A., BRYNJOLFSSON, E. Big data: The management revolution. Harvard Business Review, v. 90, n. 10, p. 60–68, 2012.
MINELLI, T., CHAMBERS, M., DHIRAJ, A. Big Data, Big Analytics: Emerging Business Intelligence and Analytic Trends for Today's Businesses. Hoboken: John Wiley & Sons, 2013.
MONK, E. F., WAGNER, B. J. Conceitos de sistemas ERP: com aplicações práticas no SAP. São Paulo: Cengage Learning, 2013.
PEERSPOT. Oracle Database Cloud Service vs SAP HANA vs SQL Server Comparison 2024. 2024. Disponível em: <https://www.peerspot.com/products/comparisons/oracle-database-cloud-service_vs_sap-hana_vs_sql-server>. Acesso em: 21 mai. 2025.
PENG, G. C., NUNES, M. B. Barriers to the successful implementation of ERP systems in SMEs: a critical analysis. Journal of Enterprise Information Management, v. 33, n. 1, p. 183–202, 2020
PLATTNER, H. The Impact of In-Memory Technology on Enterprise Systems: How SAP HANA Enables Business Intelligence. Springer, 2014.
_____________. Managed Query Processing within the SAP HANA Database Platform. Datenbank-Spektrum, v. 15, p. 221–227, 2015. Disponível em: <https://link.springer.com/article/10.1007/s13222-015-0185-2>. Acesso em: 21 mai. 2025.
_____________. A Course in In Memory Data Management: The Inner Mechanics of In Memory Databases. Heidelberg: Springer, 2014.
PROVOST, F., FAWCETT, T. Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking. Sebastopol: O’Reilly Media, 2013.
SAP. SAP S/4HANA Overview – Key Facts and Figures. Disponível em: <https://www.sap.com/products/s4hana.html. Acesso em: 10 mai. 2025.
___. SAP HANA Platform – Technical Overview. Disponível em: https://www.sap.com/products/technology-platform/hana.html>. Acesso em: 10 mai. 2025.
SAPEXPERT. SAP HANA vs. Traditional Databases: Performance Comparison. 2023. Disponível em: <https://sapexpert.info/2023/10/12/sap-hana-vs-traditional-databases-performance-comparison/>. Acesso em: 21 mai. 2025.
SOMERS, T. M., NELSON, K. The impact of critical success factors across the stages of enterprise resource planning implementations. Proceedings of the 34th Annual Hawaii International Conference on System Sciences, IEEE, 2001.
SQLENIUM. A comparative analysis of Oracle, SAP, and MS SQL. 2023. Disponível em: <https://www.sqlenium.com/2023/07/29/a-comparative-analysis-of-oracle-sap-and-ms-sql/>. Acesso em: 21 mai. 2025.
Direitos autorais e propriedade intelectual
Os direitos autorais dos originais aprovados serão automaticamente transferidos à InGeTec, como condição para sua publicação, e para encaminhamentos conexos junto às bases de dados de indexação de periódicos científicos.
Esta cessão passará a valer a partir da submissão dos manuscritos em formulário apropriado disponível no Sistema Eletrônico de Editoração da Revista.
A InGeTec se reservará o direito de efetuar, nos originais, alterações de ordem normativa, ortográfica e gramatical, com vistas a manter o padrão culto da língua e a credibilidade do veículo. Respeitará, no entanto, o estilo de escrever do (s) autor (es).
A InGeTec adota a Licença Creative Commons de Atribuição (CC-BY) (https://creativecommons.org/licenses/by/4.0/) em todos os trabalhos publicados, exceto quando houver indicação específica de outros detentores de direitos autorais. Em caso de dúvidas, deve-se consultar a Redação: suporteojs@fatecbarueri.com.br. Além disto, a revista pratica ações de combate ao plágio e à má conduta ética alinhadas às diretrizes do Committee on Publication Ethics (COPE).
