Inner Join Query Performance: MariaDB vs PostgreSQL

Journal of Physics: Conference Series - Tập 1844 Số 1 - Trang 012021 - 2021
Ummul Hairah1, Edy Budiman1
1Informatics Department, Universitas Mulawarman, Samarinda 75119, Indonesia

Tóm tắt

Abstract Research to test the performance of inner joint queries between MariaDB and the PostgreSQL database management system. Inner joint queries have the same output in MariaDB and PostgreSQL DBMS. This study aims to provide a comparative analysis of the response time performance of MariaDB and PostgreSQL databases in the use of inner join queries. The research test was conducted with 1,050,000 records using 21 response time data collection scenarios ranging from 50,000 data to 1,050,000 data collection with multiples of 50,000 data. The PostgreSQL DBMS was found to have better response times than MariaDB in all test scenarios. The results of the regression analysis to test the effect of using the F-test show that there is a significant effect on the amount of data and the relationship together on the response time in MariaDB and PostgreSQL. Then the T-test is carried out to strengthen the results of the study that PostgreSQL has a faster response time than MariaDB, testing 1 combined relationship shows a significant difference, testing 2 combined relationships shows a significant difference and testing 3 combined relationships shows a significant difference.

Từ khóa


Tài liệu tham khảo

Gelbmann, 2020, MariaDB strengthens its position in the open source RDBMS, 5

Krocz, 2020, Perfomance analysis of relational databases MySQL, PostgreSQL, MariaDB and H2, 10.35784/jcsi.1565

Haviluddin, 2019, A database integrated system based on SOAP web service

Jung, 2016

Budiman, 2020, Bioinformatics Database Query Performance and Optimization, International Journal of Recent Technology and Engineering, 9, 581

Lee, 2018, Comparison of performance between MariaDB and PostgreSQL in terms of CPU overhead, 297

Budiman, Haviluddin 2019 Web Performance Optimization Techniques for Biodiversity Resource Portal, 1230

Budiman, 2018, 54

Tongkaw, 2017, A comparison of database performance of MariaDB and MySQL with OLTP workload

Puangsaijai, 2017, A comparative study of relational database and key-value database for big data applications, 10.1109/IEECON.2017.8075813

Budiman, 2018

Schumacker, 2013, F-Test, 10.1007/978-1-4614-6227-9_11

Brown, 2012, T Test

Peng, 2020, Comparative analysis, 135

Thông tin
Thông tin xuất bản

Journal of Physics: Conference Series

Tập 1844 Số 1

012021

Thông tin tác giả