Abstract

This study compares MySQL and MongoDB regarding performance, scalability, and data model in the context of regional case management. The study was conducted as a comparative experiment using an AI-generated synthetic dataset based on metadata and data volumes from public web registers. The dataset was tested in six sizes, ranging from 21 000 to 790 000 cases, using nine context specific user stories translated into functionally equivalent queries.

The results show that MongoDB had lower execution times for writing operations, while MySQL had lower execution times for simple lookups, filtering, range searches, aggregation and relation-based operations. The study shows that the choice of database management system should be based on query type, data model, and user context. Under the conditions of this study, MySQL appears to be the more suitable choice for regional case management systems where lookups, filtering and case follow-up are central functions.