A performance analysis of the DBMS - MySQL vs PostgreSQL

被引：0
作者：
Andjelic, Svetlana [1 ]
Obradovic, Slobodan [2 ]
Gacesa, Branislav [3 ]
机构：
[1] Railway College of Vocational Studies, Belgrade
[2] Megatrend University, Belgrade
[3] Telekom. Srpske A. D., SRJ Internet Srpske, Banja Luka
来源：
Communications - Scientific Letters of the University of Žilina | 2008年 / 10卷 / 04期
关键词：
ACID; MySQL; Open source DBMS; PostgreSQL;
D O I：
10.26552/com.c.2008.4.53-57
中图分类号：
学科分类号：
摘要：
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.
引用
收藏
页码：53 / 57
页数：4
相关论文
共 50 条
  • [31] Performance Comparison between NoSQL (RethinkDB) and MySQL Database Replication from Master to Slave in Big Data
    Hussain, Dildar
    Omar, Mohammad
    Ahmad, Khairol Amalfi
    Adnan, Ja'afar
    Ahmad, Khaleel
    JURNAL KEJURUTERAAN, 2021, 4 (02): : 65 - 69
  • [32] Performance comparison of web backend and database: A case study of node.js, golang and mysql, mongo db
    Effendy F.
    Taufik
    Adhilaksono B.
    Recent Advances in Computer Science and Communications, 2021, 14 (06) : 1955 - 1961
  • [33] Improving Penalty Function of R-Tree over Generalized Index Search Tree Possible way to advance performance of PostgreSQL cube extension
    Borodin, Andrey
    Mirvoda, Sergey
    Porshnev, Sergey
    Bakhterev, Mikhail
    2017 IEEE 2ND INTERNATIONAL CONFERENCE ON BIG DATA ANALYSIS (ICBDA), 2017, : 135 - 138
  • [34] Enhancing Query Performance of Library Information Systems using NoSQL DBMS: Case Study on Library Information Systems of Universitas Indonesia
    Hermansyah
    Ruldeviyani, Yova
    Aji, Rizal Fathoni
    2016 INTERNATIONAL WORKSHOP ON BIG DATA AND INFORMATION SECURITY (IWBIS), 2016, : 41 - 46
  • [35] A systematic analysis of DMTMM vs EDC/NHS for ligation of amines to Hyaluronan in water
    D'Este, Matteo
    Eglin, David
    Alini, Mauro
    CARBOHYDRATE POLYMERS, 2014, 108 : 239 - 246
  • [36] Performance Analysis of Multiple Sequence Alignment Tools
    Reddy, Bharath
    Fields, Richard
    PROCEEDINGS OF THE 2024 ACM SOUTHEAST CONFERENCE, ACMSE 2024, 2024, : 167 - 174
  • [37] Nano-patterned SERS substrate: Application for protein analysis vs. temperature
    Das, Gobind
    Mecarini, Federico
    Gentile, Francesco
    De Angelis, Francesco
    Kumar, Mohan H. G.
    Candeloro, Patrizio
    Liberale, Carlo
    Cuda, Giovanni
    Di Fabrizio, Enzo
    BIOSENSORS & BIOELECTRONICS, 2009, 24 (06) : 1693 - 1699
  • [38] Significance of membrane bioreactor design on the biocatalytic performance of glucose oxidase and catalase: Free vs. immobilized enzyme systems
    Morthensen, Sofie T.
    Meyer, Anne S.
    Jorgensen, Henning
    Pinelo, Manuel
    BIOCHEMICAL ENGINEERING JOURNAL, 2017, 117 : 41 - 47
  • [39] Effects of processing methods (rolling vs. pelleting vs. steam-flaking) of cool-season adapted oats on dairy cattle production performance and metabolic characteristics compared with barley
    Tosta, Marcela R.
    Prates, Luciana L.
    Christensen, David A.
    Yu, Peiqiang
    JOURNAL OF DAIRY SCIENCE, 2019, 102 (12) : 10916 - 10924
  • [40] Catalytic performance of Metal-Organic-Frameworks vs. extra-large pore zeolite UTL in condensation reactions
    Shamzhy, Mariya
    Opanasenko, Maksym
    Shvets, Oleksiy
    Cejka, Jiri
    FRONTIERS IN CHEMISTRY, 2013, 1
12345