ANALISIS PERBANDINGAN KINERJA QUERY DATABASE MANAGEMENT SYSTEM (DBMS) ANTARA MySQL 5.7.16 DAN MARIADB 10.1

Jurnal TeknoIf

View Publication Info
 
 
Field Value
 
Title ANALISIS PERBANDINGAN KINERJA QUERY DATABASE MANAGEMENT SYSTEM (DBMS) ANTARA MySQL 5.7.16 DAN MARIADB 10.1
 
Creator Warman, Indra; Institut Teknologi Padang
Ramdaniansyah, Rizki; Institut Teknologi Padang
 
Subject MySQL; MariaDB; Query; Record; Stored Procedure; Trigger
 
Description Dalam penelitian ini dilakukan pengujian kinerja query antara database MySQL dan MariaDB dengan jumlah record data (50, 100, 500, 1000, 5000, 10000, 100000). Query yang diujiadalah : DML (Data Manipulation Language) terdiri dari insert, update, select. Agregat function terdiri dari average, count, max, min, sum. Operator penghubung (Operator AND OR). Stored Procedure dan Trigger. Penelitian ini bertujuan untuk memberikan analisis perbandingan kinerja antara MySQL dan MariaDB.Database MySQL dan MariaDB mempunyai kecepatan waktu yang berbeda dalam perbandingan kinerja query dengan jumlah record data dari 50 record hingga 100000 record data. Database MySQL terbukti memiliki keunggulan kecepatan waktu dibanding MariaDB pada pengujian stored procedure. Perbedaan yang sangat signifikan terjadi pada jumlah 100000 recorddata. Pada pengujian Trigger Event Insert MariaDB lebih unggul dibandingkan dengan MySQL, perbedaan yang signifikan terjadi pada pengujian100000 recorddata. Pengujian Trigger Event Update MariaDB lebih unggul dibanding dengan MySQL, perbedaan yang sangat signifikan terjadi pada pengujian 10000 record data.
 
Publisher ITP Press - Institut Teknologi Padang
 
Contributor
 
Date 2018-04-27
 
Type info:eu-repo/semantics/article
info:eu-repo/semantics/publishedVersion
Peer-reviewed Article
 
Format application/pdf
 
Identifier https://ejournal.itp.ac.id/index.php/tinformatika/article/view/957
10.21063/jtif.2018.V6.1.32-41
 
Source Jurnal Teknoif; Vol 6, No 1 (2018): TEKNOIF APRIL 2018; 32-41
Jurnal Teknoif - ISSN 2338-2724; Vol 6, No 1 (2018): TEKNOIF APRIL 2018; 32-41
2598-9197
2338-2724
10.21063/jtif.2018.V6.1
 
Language eng
 
Relation https://ejournal.itp.ac.id/index.php/tinformatika/article/view/957/634
10.21063/jtif.2018.V6.1.32-41
 
Rights Authors contributing to the TEKNOIF Journal agree to the following requirements:The author owns the copyright and gives the first publication rights journal with the work simultaneously licensed under the Creative Commons Attribution 4.0 International License which allows others to share the work with the acknowledgment of the authorship of the work and the initial publication in the TEKNOIF JournalThe author may enter into separate additional contractual agreements for the non-exclusive distribution of the published journal version of the work (for example, post it to an institutional repository or publish it in a book), with recognition of its initial publication in the TEKNOIF JournalAuthors are permitted and supported to post their work online (e.g., in institutional repositories or on their website) before and during the submission process, as this can lead to productive exchanges, as well as earlier and larger quotations from published works
 

Contact Us

The PKP Index is an initiative of the Public Knowledge Project.

For PKP Publishing Services please use the PKP|PS contact form.

For support with PKP software we encourage users to consult our wiki for documentation and search our support forums.

For any other correspondence feel free to contact us using the PKP contact form.

Find Us

Twitter

Copyright © 2015-2018 Simon Fraser University Library