Full Length Article
DOI: https://doi.org/10.54216/JAIM.110205
A Smart Retail Point-of-Sale System Using Machine Learning Forecasting and Application-Level Failover
Point-of-Sale (POS) systems support retail transaction processing, inventory management, and operational decisionmaking. However, many traditional POS systems rely on a single centralized database, creating a critical point of failure during server faults, database errors, or network disruptions. Conventional POS systems may also lack intelligent forecasting capabilities, causing inventory decisions to depend on manual estimation or fixed reorder rules. These limitations can lead to operational interruption, inventory inconsistency, and inefficient stock management. This study proposes a high-availability smart POS system integrated with AI-based inventory forecasting. The framework uses a dual-database architecture consisting of a primary database and a secondary backup database. Application-level failover redirects operations automatically when the primary database becomes unavailable, while an event-driven backup mechanism synchronizes important data after critical transactions. The forecasting component was developed using the Rossmann Store Sales dataset. Several models were evaluated, including Random Forest (RF), Bagging, CatBoost, XGBoost, and KNN Regressor. Optimization algorithms including PSO, MVO, HHO, and DE were also integrated with RF. The results showed that baseline RF achieved the best overall performance, with MSE = 0.080454, RMSE = 0.283643, MAE = 0.184264, R2 = 0.919712, and WI = 0.978542. Among optimized models, PSO + RF achieved the strongest optimizer-based result, with MSE = 0.081480 and RMSE = 0.285446. The implemented system also demonstrated successful database connectivity, failover readiness, and automatic backup execution. The findings confirm that the proposed framework can support continuous retail operation while providing accurate AI-based forecasting and inventory recommendations.
Sara albuainain
visibility
49
download
15