A Comparative Study on the Performance of the Top DBMS Systems
Youssef Bassil

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.
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsCloud Computing and Resource Management
