A Performance Analysis of the Dbms - MYSQL Vs POSTGRESQL

Modern communications among business subjects imply an exchange of a lot of data and information. To enhance that process in all its aspects, electronic data storing and processing is mandatory and enabled by an application of a DBMS (Date Base Managment System). This paper shows the performances an...

Full description

Saved in:
Bibliographic Details
Published in:Komunikácie : vedecké listy Žilinskej univerzity = Communications : scientific letters of the University of Žilina Vol. 10; no. 4; pp. 53 - 57
Main Authors: Svetlana Andjelic, Slobodan Obradovic, Branislav Gacesa
Format: Journal Article
Language:English
Published: University of Žilina 2008
Subjects:
ISSN:1335-4205, 2585-7878
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Modern communications among business subjects imply an exchange of a lot of data and information. To enhance that process in all its aspects, electronic data storing and processing is mandatory and enabled by an application of a DBMS (Date Base Managment System). This paper shows the performances analysis of the two most popular open source DBMSs - MySQL and PostgreSQL. First, some characteristics of these DBMSs are shortly described. Then the applied procedure of the performed testing is described. That is, the query (select, insert, delete and order by) execution times were measured for the both DBMSs mentioned, and the results shown in tabular and graphical forms. The goal of this paper is to make the choice of an adequate DBMS easier for future users.
ISSN:1335-4205
2585-7878
DOI:10.26552/com.C.2008.4.53-57