INOVTEK Polbeng - Seri Informatika
Vol. 10 No. 3 (2025): November

Implementation of Concurrency Control to Prevent Race Condition in a Web-Based Billiard Table Reservation System

Hermawan, Mohammad Luthfi (Unknown)
Suharso, Wildan (Unknown)



Article Info

Publish Date
30 Nov 2025

Abstract

The development of information technology has driven the digitalization of various services, including web-based billiard table reservation systems. However, web systems that operate in real time are prone to race conditions when multiple users attempt to book the same table simultaneously, potentially leading to double booking. This study aims to implement a Concurrency Control mechanism using the Firebase Transaction feature to prevent such booking conflicts. The research method adopts a Research and Development (R&D) approach with the ADDIE model, which consists of the stages of Analysis, Design, Development, Implementation, and Evaluation. Furthermore, testing was conducted through pre-test and post-test simulations across 10 trials with concurrent users ranging from 2 to 11 individuals. In the pre-test stage, all users were able to successfully book the same resource simultaneously, resulting in 100% double booking across all trials. In the post-test stage, after implementing the Concurrency Control mechanism using Firebase Transaction, only one request was accepted out of the same 10 trials, while all other requests were automatically rejected, resulting in 0% double booking. These findings demonstrate that the applied concurrency control mechanism is effective in maintaining data consistency and preventing race conditions in the web-based billiard table reservation system.

Copyrights © 2025






Journal Info

Abbrev

ISI

Publisher

Subject

Computer Science & IT

Description

The Journal of Innovation and Technology (INOVTEK Polbeng—Seri Informatika) is a distinguished publication hosted by the State Polytechnic of Bengkalis. Dedicated to advancing the field of informatics, this scientific research journal serves as a vital platform for academics, researchers, and ...