ePrints.FRI - University of Ljubljana, Faculty of Computer and Information Science

Benchmarking of various relational database management systems

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

[img] PDF
Download (1734Kb)


    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.

    Item Type: Thesis (EngD thesis)
    Keywords: MSSQL MySQL PostgreSQL Oracle IBM DB2 SQL query RDBMS Windows server 2008
    Number of Pages: 127
    Language of Content: Slovenian
    Mentor / Comentors:
    Name and SurnameIDFunction
    doc. dr. Rok Rupnik279Mentor
    Link to COBISS: http://www.cobiss.si/scripts/cobiss?command=search&base=50070&select=(ID=00007812180)
    Institution: University of Ljubljana
    Department: Faculty of Computer and Information Science
    Item ID: 1137
    Date Deposited: 08 Jul 2010 08:47
    Last Modified: 13 Aug 2011 00:37
    URI: http://eprints.fri.uni-lj.si/id/eprint/1137

    Actions (login required)

    View Item