Primerjava hitrosti delovanja sistemov za upravljanje podatkovnih baz

Abstract

Keywords

Data

Language:	Slovenian
Year of publishing:	2010
Typology:	2.11 - Undergraduate Thesis
Organization:	UL FRI - Faculty of Computer and Information Science
Publisher:	[U. Maleš]
UDC:	004.65(043.2)
COBISS:	7812180
Views:	148
Downloads:	7
Average score:	0 (0 votes)
Metadata:

Other data

Secondary language:	English
Secondary title:	[Benchmarking of various relational database management systems]
Secondary 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.
Secondary keywords:	MSSQL;MySQL;PostgreSQL;Oracle;IBM DB2;SQL query;RDBMS;Windows server 2008;computer science;diploma;
File type:	application/pdf
Type (COBISS):	Undergraduate thesis
Thesis comment:	Univerza v Ljubljani, Fakulteta za računalništvo in informatiko
Pages:	VI, 127 str.
ID:	23960122