Implementasi Basisdata Terdistribusi Pada Sistem Kenaikan Gaji Berkala Dinas Infokom Provinsi Maluku

https://doi.org/10.22146/ijccs.2156

Anastasya Latubessy(1*), Ahmad Ashari(2)

(1) 
(2) Departemen Ilmu Komputer dan Elektronika, FMIPA UGM, Yogyakarta
(*) Corresponding Author

Abstract


Abstrak

Kemampuan socket yang bekerja pada komunikasi low level dalam melakukan transfer data antar aplikasi, diharapkan dapat diterapkan dalam sistem basis data terdistribusi. Beberapa alasan untuk membangun basis data terdistribusi adalah pemakaian bersama, kehandalan, ketersediaan, dan kecepatan pemrosesan query. Dengan pertimbangan tersebut, instansi-instansi baik pemerintah maupun swasta mulai tertarik untuk menggunakan sistem terdistribusi dalam pengelolaan pekerjaan pada instansinya. Hal ini dijadikan alasan untuk membangun sistem kenaikan gaji berkala otomatis di Dinas Informasi dan Komunikasi (Infokom) Provinsi Maluku. Selain itu, belum adanya sistem terkomputerisasi yang menangani sistem ini. Sistem kenaikan gaji berkala merupakan sistem yang bersifat kritis atau penting karena berhubungan dengan masalah uang, sehingga diperlukan juga sebuah sistem yang fault tolerant.

Arsitektur sistem dibangun dengan metode client server yang memanfaatkan socket sebagai middleware dalam proses komunikasi pada jaringan. Menggunakan pendekatan full replica dengan pendekatan file replication using a group untuk menjamin konsistensi data. SQL Statement yang dikirimkan client akan diubah kedalam format XML yang kemudian akan dikirimkan ke kedua basisdata server menggunakan socket. Model redundansi data dan rendundansi proses diatur oleh middleware socket.

Hasil yang diperoleh dalam penelitian ini adalah aplikasi socket sebagai middleware yang menangani distribusi data dari aplikasi web client ke basisdata server yang diimplementasikan pada sistem kenaikan gaji berkala otomatis di Dinas Infokom Provinsi Maluku.

 

Kata kunci— Socket, basisdata terdistribusi, client server

 

Abstract

Sockets ability to transfer data between application  that work on the low level communication was expected to be implemented in a distributed database system. Some of the reasons for building a distributed database was data sharing, reliability, availability, and query processing speed. With these considerations, both government agencies and private sector became interested to use distributed systems to manage their job at the office. It is used as a reason to build an automated KGB system of Infokom Department in Province of Moluccas. Furthermore, there was no computerized system to handle this system before. Because of it was a critical or important system, then it was requires to build a system that has a fault tolerant capability.

The system architecture was built by client server method using sockets as middleware in the process of network communicaton. The system method was used full replica, and used file replication using a group to ensure data consistency. The SQL Statement was sent by the client would be converted into an XML format which then would be sent to the server using a socket. Data redundancy model and process redundancy model managed by socket middleware.

The results of this research was a middleware application using socket that handle the distribution of databases from client applications to database server that were implemented on a periodic system of automatic salary increases in the Office of Information and Communication in Province of Moluccas.

 

Keywords— Socket, distributed database, replication

Keywords


Socket; distributed database; replication

Full Text:

PDF


References

[1] Silberschatz, A., Korth, H.F. dan Sudarshan, S., 2002, Database System Concept, 4th ed,

McGrow-Hill, Singapore.

[2] Weigle, M., 2004, Client/Server Computing & Socket Programming,.

http://www.cs.clemson.edu/~mweigle/courses/cpsc826, diakses tanggal 27 Desember

2011.

[3] Özsu, T.M. dan Valduriez, P., 2011, Principles of Distributed Database System, 3th ed,

Springer.

[4] Tanenbaum, A. S., dan Steen, M. V., 2002, Distributed Systems Principles and

Paradigms, Prentice-Hall.

[5] Davenport, T, 1993, Process Innovation: Reengineering work through information

technology. Harvard Business School Press, Boston.

[6] Drake, S., Hu, W,. McInnis, D. M., Skold, M., Srivastava, A., Thalmann, L., Tikkanen, M.,

Tobjornsen, O., Wolski, A., 2005, Architecture of Highly Available Database, Springer-

Verlag.



DOI: https://doi.org/10.22146/ijccs.2156

Article Metrics

Abstract views : 7407 | views : 5031

Refbacks

  • There are currently no refbacks.




Copyright (c) 2013 IJCCS - Indonesian Journal of Computing and Cybernetics Systems

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.



Copyright of :
IJCCS (Indonesian Journal of Computing and Cybernetics Systems)
ISSN 1978-1520 (print); ISSN 2460-7258 (online)
is a scientific journal the results of Computing
and Cybernetics Systems
A publication of IndoCEISS.
Gedung S1 Ruang 416 FMIPA UGM, Sekip Utara, Yogyakarta 55281
Fax: +62274 555133
email:ijccs.mipa@ugm.ac.id | http://jurnal.ugm.ac.id/ijccs



View My Stats1
View My Stats2