Performance Improvement of Information Systems with File-based Data Storage

Kurzfassung

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.