WEB BASED APPLICATION DEVELOPMENT IN DATABASE AND COMMUNICATION TO LABORATORY INSTRUMENT FOR LABORATORY INFORMATION SYSTEM AT AIRLANGGA UNIVERSITY HOSPITAL

• Main Author: Rahmatdianto Yusuf, Hafizh
• Format: Final Project
• Language: Indonesia
• Online Access: https://digilib.itb.ac.id/gdl/view/56079
• Institution: Institut Teknologi Bandung

Airlangga University Hospital (RSUA) is a healthcare institution in Surabaya and is a part of Airlangga University. One of the medical support services provided at RSUA is clinical laboratory services. The clinical laboratory at RSUA is capable of conducting examinations in the fields of hematology, clinical chemistry, immunology / serology, clinical microbiology, anatomical pathology, parasitology, and blood bank. However, the complete laboratory services at RSUA are not yet equipped with a qualified Laboratory Information System (LIS). The current laboratory information system has not been integrated with laboratory equipment so that the pre-analytic, analytic and post-analytic stages are not fully digital. In order to digitally integrate all the of the stages, an LIS has been developed for RSUA’s laboratory. This study will discuss specifically about two LIS subsystems, namely the database and API. The database subsystem has gone through four design stages which is conceptual design, DBMS selection, logical design, and physical design. The database is implemented using MySQL DBMS and has been used as database tier to LIS via Niagahoster web hosting. The API subsystem was developed in Python programming languange with three main functions, as message reciever, message parser, and messsage sender from the laboratory instrument to database and LIS. Based on the white box and black box test, the designed database managed to meet the needs of LIS. Meanwhile based on the black box test, the API can successfully simulate the integration of Sysmex XN550 laboratory instrument into the database and LIS.