Perancangan Data Warehouse Rumah Sakit Berbasis Online Analytical Processing (OLAP)

Penulis

Joko Purwanto, Renny Renny

Abstrak

Pemanfaatan teknologi informasi sangat penting bagi rumah sakit, karena berpengaruh pula terhadap kualitas pelayanan kesehatan yang secara manual diubah menjadi digital dengan menggunakan teknologi informasi.Dalam penelitian ini penulis menggunakan metodologi Nine step sebagai acuan dalam merancang suatu data warehouse, untuk pemodelan menggunakan skema konstelasi fakta dengan 3 tabel fakta dan 11 tabel dimensi. Perbedaan penelitian ini dengan penelitian sebelumnya terletak pada sumber data yang diekstrak langsung dari database SIMRS yang digunakan rumah sakit, sehingga tidak ada ekstraksi data secara manual.Penelitian ini bertujuan untuk menghasilkan desain data warehouse berbasis Online Analytical Processing (OLAP) sebagai sarana penunjang kualitas pelayanan kesehatan rumah sakit. OLAP yang dihasilkan akan berupa desain data warehouse dengan berbagai dimensi yang akan menghasilkan tampilan informasi berupa Chart maupun Grafik sehingga informasinya mudah dibaca dan dipahami oleh berbagai pihak.

 

Abtract

The use of information technology is very important for hospitals, because it also affects the quality of health services, which manualy changed to digital using information technology. In this study, the authors used the Nine step methodology as a reference in designing a data warehouse for modeling using a fact constellation schema with 3 fact tables and 11 dimension tables. the different in this study from previous research is that the data source was taken directly from the SIMRS database used by the hospital, so there is no manual data extraction.The aim of this research is to be able to produce a Data Warehouse design based on Online Analytical Processing (OLAP) as a means of supporting the quality of hospital health services. The resulting OLAP will be a data warehouse design with various dimensions will produce the displays information in the form of a graph or chart so that the information is easy to read and understand by various parties.

 


Teks Lengkap:

PDF

Referensi


ABAI, NUR HANI ZULKIFLI, JAMAIAH H. YAHAYA, & AZIZ DERAMAN. 2013. “User Requirement Analysis in Data warehouseDesign: A Review.” Procedia Technology11 (Iceei). Elsevier B.V.: 801–6. https://doi.org/10.1016/j.protcy.2013.12.261.

AHMAD, I. 2000. Data Warehousing in Construction Organizations. Construction Congress VI : Building Together for a Better Tomorrow in an Increasingly Complex World. Orlando: American Society of Civil Engineers.

BALLARD, CHUCK, FARREL, M. DANIEL. 2006, Dimensional Modelling : In a Business Intelligence Environment, IBM RedBooks, USA

CHANDRA, A. 2010. Perancangan Data Warehouse pada Software Laboratory Center (Jurnal). Jakarta : Fakultas Ilmu Komputer Universitas Bina Nusantara.

CONNOLLY, T. & CAROLYN B. 2005. Database Systems : A Practical Approach to Design, Implementation, and Management. Addison Wesley.

GOLFARELLI, M., HILL, M.G., & RIZZI, S. Data Warehouse Design, Modern Principles and Methodologies. Mc Graw Hill.

INMON, W.H. 2005. Building the Data warehouse, Fourth Edition. Wiley Publishing.

KIMBALL, R.; & CASERTA, J. 2004. The Data Warehouse ETL Toolkit : Practical Techniques for Extracting,Cleaning, Conforming, and Delivering Data. Indianapolis. Wiley.

KIMBALL, R. & MARGY R. 2013. The Data Warehouse Toolkit : The Definitive Guide to Dimensional Modeling, Third Edition. John Wiley & Sons.

MADYATMADJA, E.D, M. AWAN W, SUCIPTO A, & GUSTI A.D.V. 2012. Manfaat Data Warehouse pada Rumah Sakit ABC (Jurnal). Jakarta : School of Information System Universitas Bina Nusantara.

MAKIANI. 2013. RSUD Palembang Bari. (Online).

Tersedia:http://rsudpbari.palembang.go.id/ark/id/76 (28 Mei 2020)

NUR ARDISTA. 2016. Design and Implementation of Data Warehouse for Reporting and Analysis Data of Outpatient Visits at Airlangga University Hospital based on Online Analytical Processing (OLAP).

PONNIAH, P. 2001. Data Warehousing Fundamentals : A Comprehensive Guide for IT Profesionals. John Wiley & Sons.

REDDY, G. S., SRINIVASU, R., RAO, M. P., & RIKKULA, S.R. 2010. Data Warehousing, Data Mining, OLAP and OLTP Technologies are Essential Elements to Support Decision-Making Process in Industries. International Journal on Computer Science and Engineering , 2 (9), 2865-2873.

SHETA, O.E. DAN AHMED N.E. 2013. The Technology of Using A Data Warehouse to Support Decision-Making in Health Care. International Journal of Database Management Systems Volume 5 Nomor 3 Tahun 2013.

SUZANA, M. 2013. Analisis dan Perancangan Data Warehouse Rumah Sakit Umum Daerah Palembang Bari. Palembang : Fakultas Ilmu Komputer Universitas Bina Darma.

TURBAN, E., RAINER, R. K., & POTTER, R. E. 2005. Introduction to Information Technology. Canada: John Wiley & Sons.

WILLIAM, C. AMO. Microsoft SQL ServerOLAP Developer's Guide. Foster City,CA : IDG Books Worldwide, 2000.

VASSILIADIS, P., SIMITSIS, A., & SKIADOPOULUS, S. 2002. Conceptual Modeling for ETL Processes.




DOI: http://dx.doi.org/10.25126/jtiik.2021854232