SDLC-Independent Python-Based Query Performance Benchmarking Approach and Practical Optimal Database Selection Guidelines

Keywords:
SQL vs NoSQL, MySQL vs MongoDB, Optimal Database Selection Guidelines, Query Performance Benchmark, Python

Abstract:
One of the critical decisions of software development teams in application development is choosing the most optimal database. Modern business conditions require software development teams to continually improve application performance, and a common dilemma is whether to transition from a relational database to a non-relational database or vice versa. Changes during the application development phase can slow down and complicate the process, so it is crucial to empirically approach data analysis and decision-making before implementing any changes. This research aims to facilitate the optimal database selection by following established practical guidelines for optimal database selection and implementing an SDLC-independent Python-based query performance benchmarking approach. This benchmarking approach is a crucial part of the optimal database selection process particularly useful in the early stages of development or when considering a migration to an existing project. The research methodology includes qualitative and quantitative methods: analytical-synthetic, experimental, comparative analysis, and hypothetical-deductive methods. The results of this research include the practical optimal database selection guidelines, the process of conducting the benchmark, and the utilization of both the guidelines and benchmark results for optimal database selection of an application where changing the initially selected MySQL database to MongoDB is being considered.

CITATION:

IEEE format

Copy to clipboard

K. Milojković, P. Spalević, N. Vasić, N. Milojković, H. Milojković, “SDLC-Independent Python-Based Query Performance Benchmarking Approach and Practical Optimal Database Selection Guidelines,” in Sinteza 2025 - International Scientific Conference on Information Technology, Computer Science, and Data Science, Belgrade, Singidunum University, Serbia, 2025, pp. 536-543. doi:10.15308/Sinteza-2025-536-543

APA format

Copy to clipboard

Milojković, K., Spalević, P., Vasić, N., Milojković, N., Milojković, H. (2025). SDLC-Independent Python-Based Query Performance Benchmarking Approach and Practical Optimal Database Selection Guidelines. Paper presented at Sinteza 2025 - International Scientific Conference on Information Technology, Computer Science, and Data Science. doi:10.15308/Sinteza-2025-536-543

BibTeX format
Download

RefWorks Tagged format
Download