SYNCHRONIZATION OF TWO HOMOGENEOUS DATABASES USING DBFORGE

Penulis

DOI:

https://doi.org/10.31000/jika.v5i3.4976

Abstrak

Database synchronization is part of replication, which is a process to ensure that every copy of data in a database contains similar objects and data. The creation of a database with MySQL database management is made offline and due to the limited allocation of costs to the system. Database synchronization in time and cost is affordable to synchronize the database offline. The main purpose of database optimization is to make many users can access data simultaneously. Accessing this data is not problematic if all users only read data and they do not interfere with each other. But when many users access the same database simultaneously and one makes changes to the data, it can lead to inconsistency of data. From the development objectives, it can be concluded that the importance of synchronizing data to backup databases to maintain consistency. This research was conducted for database optimization using dbForge Schema Compare for MySQL. This research aims to optimize the database with a target market in organizations that have a small cost allocation. Database optimization is expected to contribute to help improve database management functionality, especially offline database management and organizations that have little cost allocation.

Biografi Penulis

  • Arif Setia Sandi A, Universitas Harapan Bangsa
    Fakultas Sains dan Teknologi

Unduhan

Diterbitkan

2021-10-11

Terbitan

Vol 5 No 3 (2021): JIKA (Jurnal Informatika)

Bagian

Articles

Lisensi

License and Copyright Agreement

In submitting the manuscript to the journal, the authors certify that:

  • They are authorized by their co-authors to enter into these arrangements.
  • That it is not under consideration for publication elsewhere,
  • That its publication has been approved by all the author(s) and by the responsible authorities – tacitly or explicitly – of the institutes where the work has been carried out.
  • They secure the right to reproduce any material that has already been published or copyrighted elsewhere.
  • They agree to the following license and copyright agreement.

Copyright

Authors who publish with International Journal of Advances in Intelligent Informatics agree to the following terms:

  1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (CC BY-SA 4.0) that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal. 
  2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
  3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.

Licensing for Data Publication

International Journal of Advances in Intelligent Informatics use a variety of waivers and licenses, that are specifically designed for and appropriate for the treatment of data:

Other data publishing licenses may be allowed as exceptions (subject to approval by the editor on a case-by-case basis) and should be justified with a written statement from the author, which will be published with the article.

Open Data and Software Publishing and Sharing

The journal strives to maximize the replicability of the research published in it. Authors are thus required to share all data, code or protocols underlying the research reported in their articles. Exceptions are permitted but have to be justified in a written public statement accompanying the article.

Datasets and software should be deposited and permanently archived inappropriate, trusted, general, or domain-specific repositories (please consult http://service.re3data.org and/or software repositories such as GitHub, GitLab, Bioinformatics.org, or equivalent). The associated persistent identifiers (e.g. DOI, or others) of the dataset(s) must be included in the data or software resources section of the article. Reference(s) to datasets and software should also be included in the reference list of the article with DOIs (where available). Where no domain-specific data repository exists, authors should deposit their datasets in a general repository such as ZENODO, Dryad, Dataverse, or others.

Small data may also be published as data files or packages supplementary to a research article, however, the authors should prefer in all cases a deposition in data repositories.