Distributed Database Implementation in Point of Sale System with Method Synchronous Replication

(Case Study SBS Endang Buah)

  • Sri Wulandari University Of Technology Yogyakarta
  • Galuh Son Adji University of Technology Yogyakarta
Keywords: Sales, Distributed Database, Synchronous Replication

Abstract

This SBS Endang Buah is a trading agency that sells various kinds of products fruit. Initially SBS Endang Buah only had one shop with increase in customers then open a branch store to deal with customers which increases. But data that is not distributed quickly result in data delays and make it difficult for the agency to manage sales data at branch stores and central stores. Therefore all data from branches and central stores must be distributed to each other and a base system is made distributed data on the sales system to make it easier for the agency processing sales data. And remembering these data is very important, of course requires data backup to anticipate data loss. Process database distribution will be created in real-time using replication synchronous. Where the master database residing in the central store will be replicated to the branch store slave database and vice versa, replication is carried out in both directions, so that data delays for processing sales data can be resolved as well as with the existence of two databases can anticipate data loss from things technical and non-technical.

References

Darmawan, M.H., Isnawaty dan Subardin (2018), Perancangan dan Implementasi Sistem Replikasi Database Terdistribusi pada Fakultas Teknik Universitas Halu Oleo, semanTIK, 4(2), 91–98.

Samosir, O.R. dan Silitonga, P.D.P. (2019), Implementasi Fragmentasi Horizontal Basis Data Terdistribusi, , 04, 153–160.

Fathansyah (2015), Sistem Basis Data, Bandung: Informatika.

Rizaldi, R., Anggraeni, D. dan Zikra Syah, A. (2018), Tips Dan Trik Membangun Relationship Dan Query Dalam Database, Jurdimas (Jurnal Pengabdian Kepada Masyarakat) Royal, 1(2), 45–50.

Submitted
2021-11-19
Accepted
2021-12-31
How to Cite
Sri Wulandari, & Adji , G. S. (2021). Distributed Database Implementation in Point of Sale System with Method Synchronous Replication: (Case Study SBS Endang Buah). International Journal of Engineering Technology and Natural Sciences, 3(2), 47 - 51. https://doi.org/10.46923/ijets.v3i2.118