Performance analysis of selected database systems: MySQL, MS SQL, PostgerSQL in the context of web applications
Article Sidebar
Open full text
Published:
Mar 30, 2020
Issue Vol. 14 (2020)
Articles
-
Perfomance analysis of relational databases MySQL, PostgreSQL, MariaDB and H2
Katarzyna Krocz, Oleksandra Kizun, Maria Skublewska-Paszkowska1-7
-
Applications supporting utilization of agile methods in software development process
Tomasz Bławucki, Siarhei Ramanovich, Maria Skublewska-Paszkowska8-13
-
An assessment of portal to learn foreign languages
Marek Szmit, Paweł Wojtaszko, Grzegorz Kozieł14-18
-
Functional and performance analysis of selected message brokers in a distributed application
Tobiasz Kaciuczyk, Tomasz Korga, Jakub Smołka19-25
-
Comparative analysis of Windows Presentation Foundation and Windows Forms
Michał Pasztaleniec, Maria Skublewska-Paszkowska26-30
-
Impact of the cloud application programming language on the performance of its implementation in selected serverless environments
Krzysztof Bezrąk, Sławomir Przyłucki31-36
-
Application of support vector machine in a traffic lights control
Artur Całuch, Adam Cieślikowski, Małgorzata Plechawska-Wójcik37-42
-
Comparison of GreenDao and Room ORM Systems
Maciej Lewiński43-47
-
An Assessment of IT Students' Awareness in the Field of Instant Messengers Security
Paweł Stręciwilk, Grzegorz Kozieł48-54
-
Methods of determining indicators of similarity of 3D motion
Piotr Flisiak, Marcin Kuszyk55-58
-
Perfomance analysis of frameworks Angular and Vue.js
Roman Baida, Maksym Andriienko, Małgorzata Plechawska-Wójcik59-64
-
Possibility analysis of applying serious game to learn the first aid procedures
Klaudia Zaborek, Małgorzata Plechawska-Wójcik65-72
-
Comparison of the performance of tools for creating a SPA application interface - React and Vue.js
Krzysztof Boczkowski, Beata Pańczyk73-77
-
Comparative analysis of view technologies for the Spring application
Vadym Borys, Roman Slezenko, Beata Pańczyk78-81
-
Performance analysis of selected tools for building a Single Page Application
Yehor Timanovskyi, Małgorzata Plechawska-Wójcik82-87
-
Analysis of selected usability assessment methods in the process of creating web applications
Krzysztof Nowak, Daniel Samolej88-93
-
Performance analysis of selected database systems: MySQL, MS SQL, PostgerSQL in the context of web applications
Katarzyna Lachewicz94-100
-
Methods of creating realistic spaces – 3D scanning and 3D modelling
Aleksandra Salwierz, Tomasz Szymczyk101-108
Main Article Content
DOI
Authors
Katarzyna Lachewicz
katarzyna.lachewicz@pollub.edu.pl
Lublin University of Technology, Poland
Abstract
The main purpose of this article is to check which database: MySQL, MS SQL, PostgerSQL is the most efficient for Internet applications. This work contains information about the databases used, but the most important part of this article is database performance research. They are based on an application whose main task was database queries. The program was created based on new technologies, such as the Spring framework, the Hibernate library and JDBC Interface.
Keywords:
MySQL; MS SQL; PostgreSQL; database performance
References
[1] Marek Miłosz (red.): Aplikacje internetowe – od teorii do praktyki, 2018.
[2] Lokesh Kumar, dr. Shalini Rajawat, Krati Joshi: Comparative analysis of NoSQL (MongoDB) with MySQL Database, 2015.
[3] Sudhanshu Kulshrestha, Shelly Sachdeva, Performance comparison for data storage - Db4o and MySQL databases, 2014.
[4] Roopak K.E., Swati Rao K.S., Ritesh S., Satyadhyan: Performance Comparison of Relational Database with Object Database (DB4o), 2013
[5] Min-Gyue Jung, Seon-A Youn, Jayon Bae, Yong-Lak Choi: A Study on Data Input and Output Performance Comparison of MongoDB and PostgreSQL in the Big Data Environment, 2015.
[6] Grzegorz Dziewit, Jakub Korczyński, Maria Skublewska-Paszkowska: Analiza wydajności relacyjnych baz danych Oracle oraz MSSQL na podstawie aplikacji desktopowe, 2018.
[7] Diogo Augusto Pereira, Wagner Ourique de Morais, Edison Pignaton de Freitas: NoSQL real-time database performance comparison, 2017.
[8] Aaron Nichie, Heung-Seo Koo: A Comparison of Performance Between MSSQL Server and MongoDB for Telco Subscriber Data Management, 2016.
[9] Ken Ka-Yin Lee, Wai-Choi Tang, Kup-Sze Choi: Alternatives to relational database: Comparison of NoSQL and XML approaches for clinical data storage, 2013.
[10] Megha Katkar, Shah and Anchor Kutchhi: Performance Analysis for NoSQL and SQL, 2015.
[11] MySQL, http://vavatech.pl/technologie/bazy-danych/mysql [30.08.2019].
[12] Adam Pelikant, MS SQL Server. Zaawansowane metody programowania, 2014.
[13] PostgreSQL, http://vavatech.pl/technologie/bazy-danych/postgresql [30.08.2019].
[14] PostgreSQL 12 Released!, https://www.postgresql.org/docs/11/release-11-5.html [30.09.2019].
[15] Porównanie relacyjnych SZBD: SQLite, MySQL, PostgreSQL, https://hostovita.pl/blog/porownanie-relacyjnych-systemow-zarzadzania-bazami-danych-sqlite-mysql-postgresql/ [30.08.2019].
[16] JMeter – narzędzie testera, http://2016.testwarez.pl/jmeter-narzedzie-testera/ [ 10.09.2019].
[2] Lokesh Kumar, dr. Shalini Rajawat, Krati Joshi: Comparative analysis of NoSQL (MongoDB) with MySQL Database, 2015.
[3] Sudhanshu Kulshrestha, Shelly Sachdeva, Performance comparison for data storage - Db4o and MySQL databases, 2014.
[4] Roopak K.E., Swati Rao K.S., Ritesh S., Satyadhyan: Performance Comparison of Relational Database with Object Database (DB4o), 2013
[5] Min-Gyue Jung, Seon-A Youn, Jayon Bae, Yong-Lak Choi: A Study on Data Input and Output Performance Comparison of MongoDB and PostgreSQL in the Big Data Environment, 2015.
[6] Grzegorz Dziewit, Jakub Korczyński, Maria Skublewska-Paszkowska: Analiza wydajności relacyjnych baz danych Oracle oraz MSSQL na podstawie aplikacji desktopowe, 2018.
[7] Diogo Augusto Pereira, Wagner Ourique de Morais, Edison Pignaton de Freitas: NoSQL real-time database performance comparison, 2017.
[8] Aaron Nichie, Heung-Seo Koo: A Comparison of Performance Between MSSQL Server and MongoDB for Telco Subscriber Data Management, 2016.
[9] Ken Ka-Yin Lee, Wai-Choi Tang, Kup-Sze Choi: Alternatives to relational database: Comparison of NoSQL and XML approaches for clinical data storage, 2013.
[10] Megha Katkar, Shah and Anchor Kutchhi: Performance Analysis for NoSQL and SQL, 2015.
[11] MySQL, http://vavatech.pl/technologie/bazy-danych/mysql [30.08.2019].
[12] Adam Pelikant, MS SQL Server. Zaawansowane metody programowania, 2014.
[13] PostgreSQL, http://vavatech.pl/technologie/bazy-danych/postgresql [30.08.2019].
[14] PostgreSQL 12 Released!, https://www.postgresql.org/docs/11/release-11-5.html [30.09.2019].
[15] Porównanie relacyjnych SZBD: SQLite, MySQL, PostgreSQL, https://hostovita.pl/blog/porownanie-relacyjnych-systemow-zarzadzania-bazami-danych-sqlite-mysql-postgresql/ [30.08.2019].
[16] JMeter – narzędzie testera, http://2016.testwarez.pl/jmeter-narzedzie-testera/ [ 10.09.2019].
Article Details
Lachewicz, K. (2020). Performance analysis of selected database systems: MySQL, MS SQL, PostgerSQL in the context of web applications. Journal of Computer Sciences Institute, 14, 94–100. https://doi.org/10.35784/jcsi.1583
Abstract views: 1652
License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
