Jurnal Algoritma, Logika dan Komputasi

MySQL database schema changes are becoming more frequent than ever, Four out of five application updates (releases) require appropriate database changes, For Database schema changes are more often a repetitive task, it may be a request from the application team to add or modify a column in a table and many cases other. This study aims to measure the level of time efficiency to modify the sales transaction table schema which consists of 50000 number of records in the MySQL database with the Data Definition Language (DDL) Copy, Inplace and Instant algorithm on the MySQL database.

id.wikipedia.org, “MySQL,” id.wikipedia.org, 2022. https://id.wikipedia.org/wiki/MySQL (accessed Oct. 14, 2022).

Y. W, “Apa Itu Skema Database? Pengertian dan Contohnya Lengkap,” hostinger.co.id/, 2022. https://www.hostinger.co.id/tutorial/skema-database (accessed Oct. 10, 2022).

javatpoint.com, “MySQL CREATE TABLE,” javatpoint.com, 2021. https://www.javatpoint.com/mysql-create-table (accessed Oct. 09, 2022).

Pengertianku.net, “Pengertian Field, Record, Table, File, Data, dan Basis Data Lengkap,” pengertianku.net, 2022. https://www.pengertianku.net/2014/12/pengertian-field-record-table-file-data-dan-basis-data-lengkap.html (accessed Oct. 14, 2022).

Admin, “DATA DEFINITION LANGUAGE (DDL),” smkn1pangandaran.sch.id, 2019. https://smkn1pangandaran.sch.id/sakola/public/artikel/3/data-definition-language-ddl (accessed Oct. 14, 2022).

L. P. Jan, “Panduan Remote Database MySQL dengan SQLyog di Rumahweb,” rumahweb.com, 2020. https://www.rumahweb.com/journal/panduan-remote-database-mysql-dengan-sqlyog-di-rumahweb/ (accessed Oct. 12, 2022).

W. Akram, “An Overview of DDL Algorithm’s in MySQL ( covers MySQL 8),” mydbops.wordpress.com/, 2020. https://mydbops.wordpress.com/2020/03/04/an-overview-of-ddl-algorithms-in-mysql-covers-mysql-8/ (accessed Oct. 11, 2022).