Pengembangan Basis Data Sistem Informasi Manajemen Rumah Sakit Berbasis Linguistic-based Schema Matching

Adhistya Erna Permanasari, Hayu Pradnya Satyaprabha, Addin Suwastono, Guntari Titik Mulyani

Abstract


Prof. Soeparwi veterinary hospital is one of the medical institutions focused on providing medical services for animals. In its daily operations, the flow of informations among various departments has yet to be supported by management information systems (MIS) which enables efficiency of business process and a better management of the data. Previous researches have been conducted to develop MIS, which resulted in three independent MIS for managing registration, medical records, and patient bills. Each MIS is using their own database to store the data, thus causing duplicates of information and inconsistencies, and also increasing complexity in accessing the data. The goal of this research is to re-design the said database into a single database that will be used by various MIS. Three independent databases are merged by applying a technique that uses linguistic information as the basis for the matching–called linguistic-based schema matching. This method’s accuracy is evaluated by calculating precision, recall, and F-measure–which we obtained scores of above 50% for all three indicators. Requirement analysis is performed to further develop the database for supporting further needs of the hospital. The new database system is tested using black-box technique under few test cases to see if its functionality corresponds with the specifications defined. Result of this test proves that the new database could handle valid, invalid, and redundant inputs as expected by a score of 100% success rate.

Keywords


SIMRS; Basis Data; Linguistic-based Schema Matching; Black-Box Testing

Full Text:

PDF

References


D.A. Hapsari, “Pembangunan Sistem Informasi Manajemen Rumah Sakit Hewan Prof. Soeparwi Sub-sistem Pendaftaran Pasien Menggunakan Algoritme First In First Out,” Skripsi, Universitas Gadjah Mada, Yogyakarta, Indonesia, 2016.

N.K. Sari, “Pembangunan Sistem Informasi Manajemen Rumah Sakit Hewan Prof. Soeparwi Sub-sistem Rekam Medis Menggunakan Metode Prototipe,” Skripsi, Universitas Gadjah Mada, Yogyakarta, Indonesia, 2016.

A.K. Candri, “Pengembangan Sistem Billing Konvergen di Rsh. Prof. Soeparwi Berbasis Web,” Skripsi, Universitas Gadjah Mada, Yogyakarta, Indonesia, 2017.

A.F. Winter, E. Ammenwerth, O.J. Bott, B. Brigl, A. Buchauer, S. Gräber, A. Grant, A. Häber, W. Hasselbring, R. Haux, A. Heinrich, H. Janssen, I. Kock, O.-S. Penger, H.-U. Prokosch, A. Terstappen, dan A. Winter, “Strategic Information Management Plans: The Basis for Systematic Information Management in Hospitals,” International Journal of Medical Informatics, Vol. 64, No. 2–3, hal. 99–109, 2001.

H.U. Prokosch dan J. Dudeck, Hospital Information Systems: Design and Development Characteristics, Impact and Future Architecture, Amsterdam, Netherlands: Elsevier Science Inc., 1995.

O.A. Abisoye, B.O. Abisoye, dan B.E. Ojonuba, “An Online Outpatient Database System: A Case Study of General Hospital, Minna,” Intell. Inf. Manag., Vol. 8, No. 4, hal. 103–114, 2016.

O. Olamide, E.W. Adedayo, dan O.A. Abiodun, “Design and Implementation of Hospital Management System Using Java,” IOSR J. Mob. Comput. Appl., Vol. 2, No. 1, hal. 2394–42, 2015.

G. Yadav, P. Lad, P. Pandey, dan T. Kolla, “Advanced Hospital Database Management System,” Int. J. Adv. Res. Comput. Commun. Eng., Vol. 5, No. 4, hal. 221–223, 2016.

O. Unal dan H. Afsarmanesh, “Using Linguistic Techniques for Schema Matching,” ICSOFT, 2006, hal. 115–120.

M.A.F. Rachman dan G.A.P. Saptawati, “Database Integration Based on Combination Schema Matching Approach (Case Study: Multi-Database of District Health Information System),” 2017 2nd International conferences on Information Technology, Information Systems and Electrical Engineering (ICITISEE), 2017, hal. 430–435.

E. Sutanta, R. Wardoyo, K. Mustofa, dan E. Winarko, “Seminar Nasional Aplikasi Teknologi Informasi (SNATI),” 2015, hal. 45–51.




DOI: http://dx.doi.org/10.22146/jnteti.v8i2.498

Refbacks

  • There are currently no refbacks.


Copyright (c) 2019 Jurnal Nasional Teknik Elektro dan Teknologi Informasi

JNTETI (Jurnal Nasional Teknik Elektro dan Teknologi Informasi)

Departemen Teknik Elektro dan Teknologi Informasi, Fakultas Teknik Universitas Gadjah Mada
Jl. Grafika No 2. Kampus UGM Yogyakarta 55281
+62 274 552305
jnteti@ugm.ac.id