IMPLEMENTATION OF STREAMLINE REALTIME STOCK USING AUTO-SCALING THROUGH GOOGLE CLOUD PUB/SUB AT PT XYZ

Joseph Heykel Prabawa; Adi  Nugroho

doi:10.52436/1.jutif.2024.5.4.1930

Joseph Heykel Prabawa Department of Informatics Engineering, Faculty Of Information Technology, Universitas Kristen Satya Wacana, Indonesia
Adi Nugroho Department of Informatics Engineering, Faculty Of Information Technology, Universitas Kristen Satya Wacana, Indonesia

DOI: https://doi.org/10.52436/1.jutif.2024.5.4.1930

Keywords: auto-scaling, Google Cloud Platform, pub/sub, real-time, stock

Abstract

Shortening the updating and inputting of accurate and real-time stock data is crucial for smooth retail business operations at PT XYZ. The existing system had low availability, lacked scalability, and incurred high costs in managing inventory in real time. Implementing real-time stock streamline with automatic scaling and Google Cloud Pub/Sub can help achieve this goal. This system utilizes Google Cloud Pub/Sub as a message delivery platform to distribute stock information from sender to receiver in real-time. Auto-scaling is used to automatically increase or decrease the number of servers processing stock data based on demand. The system is designed using Python and integrated through libraries with the Google Cloud Platform. The results of this research prove that the system is capable of providing optimal performance and scalability with high availability, good security, and cost savings.

Downloads

Download data is not yet available.

References

G. Schumy and Y. A. Susetyo, “Rancang Bangun Sistem Sinkronisasi Data Menggunakan Google Cloud Pub/Sub Dan Flask Di PT XYZ,” in Jurnal MNEMONIC, 2022, vol 5, no. 2, pp 85-92, 2022, doi: 10.36040/mnemonic.v5i2.4645.

S. L. Gutiérrez and Y. P. Vera, “A Cloud Pub/Sub Architecture to Integrate Google Big Query with Elasticsearch using Cloud Functions,” International Journal of Computing, vol. 21, no. 3, pp. 369–376, 2022, doi: 10.47839/ijc.21.3.2694.

S. K. Rout, J. V. R. Ravindra, A. Meda, S. N. Mohanty, and V. Kavididevi, “A Dynamic Scalable Auto-Scaling Model as a Load Balancer in the Cloud Computing Environment,” EAI Endorsed Transactions on Scalable Information Systems, vol. 10, no. 5, pp. 1–7, 2023, doi: 10.4108/eetsis.3356.

Google Cloud, "Instance Group", 2023. https://cloud.google.com/compute/docs/instance-groups?hl=id (accessed Nov. 1, 2023).

S. P. T. Krishnan, Jose L. Ugia Gonzalez, Building Your Next Big Thing with Google Cloud Platform. Apress Berkeley, CA.

Google Cloud, "Overview of the Pub/Sub service", 2023. https://cloud.google.com/pubsub/docs/pubsub-basics (accessed Nov. 1, 2023).

Google Cloud, "Event-driven architecture with Pub/Sub", 2023. https://cloud.google.com/solutions/event-driven-architecture-pubsub (accessed Nov. 1, 2023).

Google Cloud, "Autoscaling groups of instances", 2023. https://cloud.google.com/compute/docs/autoscaler (accessed Nov. 5, 2023).

D. Gustian, Y. Fitrisia, S. Purwantoro ESGS, W. Novayani, P. Caltex Riau, and J. Umbansari No, “Implementasi Automation Deployment pada Google Cloud Compute VM menggunakan Terraform,” Jurnal Inovtek Polbeng, vol. 8, no. 2, pp. 50–62, 2023.

A. A. Wibowo Putri and Y. A. Susetyo, “Implementation Of Flask For Stock Checking In Distribution Center & Store On Monitoring Stock Application In PT. XYZ,” Jurnal Teknik Informatika (Jutif), vol. 3, no. 5, pp. 1265–1274, Oct. 2022, doi: 10.20884/1.jutif.2022.3.5.334.

B. P. Putra and Y. A. Susetyo, “IMPLEMENTASI API MASTER STORE MENGGUNAKAN FLASK, REST DAN ORM DI PT XYZ,” Jurnal Sistem Informasi (SISTEMASI), vol. 9, no. 3, pp. 543-556, 2020, doi: 10.32520/stmsi.v9i3.89.

R. Bayu, A. Pradana, and A. Bhawiyuga, “Pengembangan Platform IoT Cloud berbasis Layanan Komputasi Serverless Google Cloud Platform (GCP),” Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, vol. 6, no. 4, April. 2022.

A. A. Wibowo Putri and Y. A. Susetyo, “Implementation Of Flask For Stock Checking In Distribution Center & Store On Monitoring Stock Application In PT. XYZ,” Jurnal Teknik Informatika (Jutif), vol. 3, no. 5, pp. 1265–1274, Oct. 2022, doi: 10.20884/1.jutif.2022.3.5.334.

M. C. Silva Filho, C. C. Monteiro, P. R. M. Inácio, and M. M. Freire, “A Distributed Virtual-Machine Placement and Migration Approach Based on Modern Portfolio Theory,” Journal of Network and Systems Management, vol. 32, no. 1, Mar. 2024, doi: 10.1007/s10922-023-09775-8.

S. L. Gutiérrez and Y. P. Vera, “A Cloud Pub/Sub Architecture to Integrate Google Big Query with Elasticsearch using Cloud Functions,” International Journal of Computing, vol. 21, no. 3, pp. 369–376, 2022, doi: 10.47839/ijc.21.3.2694.

C. Mustafa Mohammed and S. R. M Zeebaree, “Sufficient Comparison Among Cloud Computing Services: IaaS, PaaS, and SaaS: A Review,” International Journal of Science and Business, vol. 5, no. 2, pp. 17–30, 2021, doi: 10.5281/zenodo.4450129.

A. J. Budianto, P. Ocsa, and N. Saian, “Pengembangan Modul Inventory Management pada Aplikasi Master Distribution Centre System Menggunakan Framework Flask di PT XYZ,” Jurnal Teknologi Informasi dan Komunikasi), vol. 7, no. 2, pp. 201–207, 2023, doi: 10.35870/jti.

J. Nam, Y. Jun, and M. Choi, “High Performance IoT Cloud Computing Framework Using Pub/Sub Techniques,” Applied Sciences (Switzerland), vol. 12, no. 21, Nov. 2022, doi: 10.3390/app122111009.

P. M. Tobing, M. Ariance, and I. Pakereng, “Migrasi Aplikasi Stock Opname Platform Desktop Ke Android Menggunakan Kivy Framework (Studi Kasus Di PT Sumber Alfaria Trijaya Tbk),” Indonesian Journal on Computer and Information Technology, 2020, vol. 6, no. 2, pp. 151-159. Nov. 2021.

F. V. L. Dewangga and P. O. Nugraha Saian, “Automatic Git Repository Deployer In Ubuntu Using Python, Jenkins And Cloud Firestore At PT XYZ,” Jurnal Teknik Informatika (Jutif), vol. 4, no. 6, pp. 1313–1325, Dec. 2023, doi: 10.52436/1.jutif.2023.4.6.1062.

A. R. Nasution, F. Dewanta, and B. Aditya, “AUTO SCALING DATABASE SERVICE WITH MICRO KUBERNETES CLUSTER,” Jurnal Teknik Informatika (Jutif), vol. 3, no. 4, pp. 923–927, Aug. 2022, doi: 10.20884/1.jutif.2022.3.4.484.