Abstract
Modern information systems, such as enterprise resource planning (ERP) systems, are vital for real-time decision-making, providing instant access to essential data. The rise of file-based storage engines provides valuable alternatives in information system architecture, especially for resource-constrained organizations. This study conducts comprehensive performance benchmarks across diverse database architectures, columnar file-based, in-memory, and traditional RDBMS, using standardized ERP workloads that simulate transaction processing, analytical reporting, and mixed operations with varying data volumes and concurrency levels.
Paper Type
Poster
DOI
10.62036/ISD.2025.141
Performance Improvement of Information Systems with File-based Data Storage
Modern information systems, such as enterprise resource planning (ERP) systems, are vital for real-time decision-making, providing instant access to essential data. The rise of file-based storage engines provides valuable alternatives in information system architecture, especially for resource-constrained organizations. This study conducts comprehensive performance benchmarks across diverse database architectures, columnar file-based, in-memory, and traditional RDBMS, using standardized ERP workloads that simulate transaction processing, analytical reporting, and mixed operations with varying data volumes and concurrency levels.
Recommended Citation
Pohl, M., Langisch, P., Haertel, C., Staegemann, D. & Turowski, K. (2025). Performance Improvement of Information Systems with File-based Data StorageIn I. Luković, S. Bjeladinović, B. Delibašić, D. Barać, N. Iivari, E. Insfran, M. Lang, H. Linger, & C. Schneider (Eds.), Empowering the Interdisciplinary Role of ISD in Addressing Contemporary Issues in Digital Transformation: How Data Science and Generative AI Contributes to ISD (ISD2025 Proceedings). Belgrade, Serbia: University of Gdańsk, Department of Business Informatics & University of Belgrade, Faculty of Organizational Sciences. ISBN: 978-83-972632-1-5. https://doi.org/10.62036/ISD.2025.141