Implementasi Metode Indexing dan Penggunaan Subquery untuk Optimalisasi Database Rawat Jalan Rumah Sakit Menggunakan Mysql

Wilsen Grivin Mokodaser; Monica  Dwijayanti; Samidi Samidi

doi:10.31154/cogito.v8i2.415.335-345

Authors

Wilsen Grivin Mokodaser Universitas Budi Luhur
Monica Dwijayanti Universitas Budi Luhur
Samidi Samidi Universitas Budi Luhur

DOI:

https://doi.org/10.31154/cogito.v8i2.415.335-345

Keywords:

Subquery, Exist, IN, Btree Indexing.

Abstract

The need for outpatient hospital services that can be accessed quickly by the community is a very important aspect. By looking at the downturn caused by the Covid-19 pandemic that has hit the world since 2019 and has an impact on various economic aspects including hospital services, digitizing the hospital system must be implemented to be a solution in providing fast services for patients who come for treatment. The information system is not without problems, as the amount of data increases so that the selection of the right database including the use of appropriate queries can help provide accurate and fast output. indexing method can be applied to tables with a large number of databases. the use of subqueries as with previous research shows an increase in data access performance.

References

Reny Nugraheni and Yoanita Indra Kumalasari, 2020, “Evaluasi Sistem Informasi Pendaftaran Pasien Rwat Jalan di Rumah Sakit X Kota Kediri”, Jurnal Kesehatan, vol. 8, no. 2, Hal 96-105.

David Laksamana Caesar, 2019, “Studi Evaluasi Sistem Informasi Pendaftaran di Rumah sakit Umum Daerah dr. Loekmono Hadi Kudus”, Jurnal Kesehatan Masyarakat., vol. 7, no. 1, Hal 74-88.

Robnah and Adi Widodo, 2022, “Tinjauan Sistem Informasi Pendaftaran Pasien Rawat Jalan di RSUD Tebet Jakarta Selatan”, Indonesian Journal of Health Information Management (IJHIM), vol. 2, no. 1.

M. N. Y. Utomo, A. Bastian, and A. Winursito, 2020, “Optimasi Performa Kecepatan Query Select Random pada SQL Database”, INTEK J. Penelit., vol. 7, no. 1, Hal 26.

Ellya Helmud, 2021, “Optimasi Basis Data Oracle Menggunakan Complex View Studi Kasus : PT. Berkat Opmimis Sejahtera (PT.BOS) Pangkalpinang”, Jurnal Informanika, vol. , no. 1.

A. J. C., A. V. C., and N. S. E., 2018, “Design and Implementation of a Hospital Database Management System (HDMS) for Medical Doctors”, Int. J. Comput. Theory Eng, vol. 10, no. 1, hal 1–6.

O. M. I. Tavares, S. M. Rangkoly, S. B. D. Bawan, K. B. Ahmad, E. Utami, and M. S. Mustafa, 2021, “Analysis of Query Restructuration Models in Optimizing Data Execution Response Time on Mysql Php 7.2.27 Relational Databases”, J. Komput. dan Inform., vol. 9, no. 1, hal 1–10.

S. Samidi, D. Andharu, and F. Widyarto, 2022. “Optimasi Database Menggunakan SQL Kueri Klausa IN dan EXIST pada Database Oracle 12c. Studi Kasus pada Aplikasi di Badan Nasional Pencarian dan Pertolongan (BASARNAS, J. Pendidik. Tambusai, vol. 6, no. 1, hal. 2297–2306.

P. Noviyanti, A. Deolika, S. Hartinah, C. A. Haris, T. Maryana, and N. D. Sari, 2018, “Perbandingan Query Response Time pada Model Query View dan Cross Product Comparison of Query Response Time in the Query View and Cross Product”, e-Jurnal JUSITI, vol. 7, no. 2, hal. 131–141.

E. Witono, 2022, “Perbandingan Response Time Penggunaan Index , Views , dan Materialized Views Database Mysql”, Jurnal Sains Komputer & Informatika, vol. 6, hal 499–506.

T. Oktavia and S. Sujarwo, 2014, “Evaluation of sub query performance in SQL server, EPJ Web Conf”, vol. 68, hal 1–5.

Diva Putri Anasya, 2022, “Optimasi Hasil Query Pada Fitur Pencarian Platform Marketplace Penjualan dan Seea Menyewa Buku Online”, Seminar Nasional & Call Paper Fakultas Sains dan Teknologi (SENASAINS), Sidoarjo, 2 Juni.

Dike Pradana Putra, 2015, “Implementasi Fulltext Indexing pada Dokumen Elektronik dengan Algoritma B-Tree”, e-Prodeeding of Enginering, Vol 2, hal 1119.

R. Pamungkas, 2018, “Optimalisasi Query Dalam Basis Data Mysql Menggunakan Index”, Res. Comput. Inf. Syst. Technol. Manag., vol. 1, no. 1, hal. 27.

Indra Warman and Wildani, 2021, “Analisa Kinerja Query Stored Procedure Pada Database management System (DBMS) MYSQL”, Jurnal Sains dan Teknologi, vol. 21, no. 1.