A Comparative Study on the Performance of the Top DBMS Systems

TL;DR

This paper compares the performance of leading DBMS systems like MS SQL Server, Oracle, IBM DB2, MySQL, and MS Access by evaluating their execution time, memory, and CPU usage across various SQL queries.

Contribution

It provides a comprehensive head-to-head performance evaluation of top DBMS systems, highlighting their strengths and weaknesses in different operational aspects.

Findings

MS SQL Server shows faster query execution for complex queries.

MySQL has lower memory usage in most tests.

Oracle and IBM DB2 demonstrate higher reliability under load.

Abstract

Database management systems are today's most reliable mean to organize data into collections that can be searched and updated. However, many DBMS systems are available on the market each having their pros and cons in terms of reliability, usability, security, and performance. This paper presents a comparative study on the performance of the top DBMS systems. They are mainly MS SQL Server 2008, Oracle 11g, IBM DB2, MySQL 5.5, and MS Access 2010. The testing is aimed at executing different SQL queries with different level of complexities over the different five DBMSs under test. This would pave the way to build a head-to-head comparative evaluation that shows the average execution time, memory usage, and CPU utilization of each DBMS after completion of the test.