Web-Based Batik Sales System Uses Locking Mechanism to Prevent Race Condition

Hassan Wirayuda; Ari Usman

Penulis

Hassan Wirayuda Universitas Harapan Penulis
Ari Usman Universitas Harapan Penulis

Kata Kunci:

E-Commerce, Race condition, Locking mechanism, Batik, Web

Abstrak

The development of information technology is driving digital transformation in various sectors, including trade. This research aims to design and build a web-based batik sales system equipped with a locking mechanism to address race conditions, which occur when multiple users access data simultaneously, which can lead to data inconsistencies. The system was developed using PHP and MySQL, focusing on online transaction management and real-time stock updates. The results show that the system is capable of handling concurrent transactions well. The application of the locking mechanism to critical processes successfully maintains data consistency and prevents conflicts due to simultaneous access. Black-box testing proves that all system functions operate as required. This research is expected to provide practical solutions for batik MSMEs and serve as an academic reference regarding concurrent transaction management and data integrity.

Referensi

S. Fitriani and H. Kurniawan, "Permasalahan Race condition dalam Sistem Informasi," Jurnal Ilmiah Informatika, 2022.

D. Herawati and B. Santosa, "Race condition pada Sistem E-commerce," Jurnal Teknologi Informasi, 2021.

A. Prasetyo and R. Sari, "Penerapan Locking mechanism pada Sistem Basis Data," Jurnal Sistem Informasi, 2020.

I. Zahra and Y. Permana, "Pessimistic Locking dalam Transaksi Online," Jurnal Rekayasa Perangkat Lunak, 2023.

R. Banerjee, "Exploring concurrency control techniques in multi-user database systems: a comprehensive review", International Journal for Multidisciplinary Research, vol. 6, no. 3, 2024. https://doi.org/10.36948/ijfmr.2024.v06i03.23286

A. Fekete, "Technical perspective: allocating isolation levels to transactions in a multiversion setting", Acm Sigmod Record, vol. 53, no. 1, p. 15-15, 2024. https://doi.org/10.1145/3665252.3665256

D. William, "Rancang bangun sistem informasi transaksi berbasis web studi kasus kopi bar depok", jetcom, vol. 3, no. 2, p. 20-29, 2024. https://doi.org/10.63893/jetcom.v3i2.234

H. Basyiri, "Helmet sales information system web based on studio shop jakarta custom helmet", Jurnal Manajemen Informatika Medicom (Jmi), vol. 12, no. 1, p. 1-5, 2024. https://doi.org/10.35335/jmi.v12i1.40

M. R. Wayahdi and S. Guntur, “Website-Based Village Information System Design (Case Study: Ujung Batu III Village)”, jmp, vol. 14, no. 1, pp. 38-44, Mar. 2025. https://doi.org/10.33395/jmp.v14i1.14621

F. Ardiansyah and R. Maharani, “Development of a Web-Based Decision Support System for Academic Program Selection Using the Weighted Product Method”, JOTECHCOM, vol. 2, no. 2, pp. 109–113, May 2025, Accessed: Aug. 23, 2025.