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
DOI: https://doi.org/10.46923/ijets.v3i2.118
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-06-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
Issue
Vol. 3 No. 2 (2021): International Journal of Engineering, Technology and Natural Sciences
Section
Articles

Copyright Notice

The Authors submitting a manuscript do so on the understanding that if accepted for publication, copyright of the article shall be assigned to journal IJETS, University Of Technology Yogyakarta as publisher of the journal, and the author also holds the copyright without restriction.

Copyright encompasses exclusive rights to reproduce and deliver the article in all form and media, including reprints, photographs, microfilms and any other similar reproductions, as well as translations. The reproduction of any part of this journal, its storage in databases and its transmission by any form or media, such as electronic, electrostatic and mechanical copies, photocopies, recordings, magnetic media, etc. , are allowed with a written permission from journal IJETS, University Of Technology Yogyakarta.

Jurnal IJETS Board, University Of Technology Yogyakarta, the Editors and the Advisory International Editorial Board make every effort to ensure that no wrong or misleading data, opinions or statements be published in the journal. In any way, the contents of the articles and advertisements published in the journal IJETS, University Of Technology Yogyakarta are sole and exclusive responsibility of their respective authors and advertisers.