IMPLEMENTASI BASIS DATA TERDISTRIBUSI DENGAN METODE HETEROGENOUS DISTRIBUTED DATABASE SYSTEM PADA SISTEM INFORMASI BARANG REDSHIT DISTRO

Database technology and computer network which develops currently are able to make a company developing its performance and productivity, especially the company that has branches or subsidiary, such as Redshit Distro. Redshit Distro is a store that sells any kinds of cloths and accessories from several local original brands which come from Yogyakarta and Bandung. Redshit Distro has three stores, the main store is Redshit Distro Pati. While another branches are Redshit Distro Kudus and Redshit Distro Jepara. Previous database system centralized technology starts to turn into distributed database system with its various benefits. Distributed database is a database system which is saved on more than one computer at different location and each local is connected with computer network. Distributed database gives several benefits. Its benefits are such as capability in solving the increasing and extension data volume and available data, and autonomy in data processing to each local. While Heterogenous Distributed Database System is a distributed database system if DBMS that handles data for every server is diverse or also called as data base multi-system. Distributed database implementation on Redshit Distro’s product information system uses Heterogenous Distributed Database System method. The implementation was done by using four servers, three servers are redshit distro server, that is Redshit Pati Server, Redshit Kudus, and Redshi Jepara which use DBMS Oracle XE 11g, and one Backup Redshit Server which uses DBMS MySQL utilized for backup server from those another three servers. The distribution of data was done by applying replication and synchronization. Replication is a backup in real time from three redshit servers to backup servers, in order when redshit server is down, the system is able to run with backup server. While synchronization is a data adaptation of three redshit server with backup server, in order every server has up to date data