Benchmarking of various relational database management systems

Uroš Maleš (2010) Benchmarking of various relational database management systems. EngD thesis.

PDF Download (1734Kb)

Abstract

Main objective of this thesis is benchmarking of relational database management systems (RDBMS) Oracle, MSSQL, IBM DB2, MySQL, PostgreSQL and their comparison. The observed results are intended to make it easier to determine which database management system iz better for certain purposes. Each measurement was repeated ten times. The results were then calculated from the average times of each measurement. Comparisons of gained results shows, whitch database management system is better in certain areas, according to the default configuration, usage of unoptimized tables and SQL queries. Comparison of closed source (commercial) database management systems revealed, that Oracle RDBMS was the fastest in handling SQL queires. Comparison of open source (uncommercial) RDBMS showed, the best choice is usage of PostgreSQL RDBMS. In the analysis of the measurements in addiotion to the differences between RDBMS I also encountered differences between different methods of connections. Choosing the right method of connecting to RDBMS can have a major impact on the speed of returned results from SQL execution requests. In the main part of thesis I included description of my test program, descriptions of all used connections to RDBMS, SQL querys I tested, analysis of time taken for executing each query, comparison betwen each connection and selected RDBMS and the conclusion, where all observations are summarized. In addition I added suggestions for further testings. Anyone who plans to use a any particular RDBMS, should first determine, how a selected RDBMS works and justify their selecion.

Actions (login required)