Analyzing and Designing an Evaluation Benchmark for SQL and NoSQL Database Systems for some Selected Higher Institution in Zamfara State

Abstract

This research analyzes and designs an evaluation benchmark for SQL and NoSQLdatabase systems, specifically tailored for higher institutions in Zamfara State. By benchmarking various database operations, including insert, select, update, delete, and stored procedures, we identify performance differences between the two systems. MongoDB demonstrates superior performance in handling insert, select, update, and delete operations, making it ideal for applications with high transactional demands. Conversely, MySQL excels in executing stored procedures due to its native support, which is crucial for complex procedural logic. Considering that insert, select, update, and delete operations are more common, MongoDB is generally recommended. However, for applications heavily reliant on stored procedures, MySQL remains the preferred choice. Additionally, the complexity of converting an existing MySQL database to MongoDB should be factored into the decision-making process. This study provides valuable insights and recommendations to help institutions in Zamfara State choose the most suitable database system based on their specific operational needs and performance requirements.