Article Per Year (5 Year)
p-Index From 2019 - 2024
6.184
P-Index
This Author published in this journals
All Journal International Journal of Electrical and Computer Engineering IAES International Journal of Artificial Intelligence (IJ-AI) IJCCS (Indonesian Journal of Computing and Cybernetics Systems) Jurnal Ilmu Komputer MATICS : Jurnal Ilmu Komputer dan Teknologi Informasi (Journal of Computer Science and Information Technology) Perfecting a Video Game with Game Metrics Indonesian Journal of Electrical Engineering and Informatics (IJEEI) Jurnal Ilmiah Kursor International Journal of Local Economic Governance Journal of Enviromental Engineering and Sustainable Technology Jurnal Teknologi Informasi dan Ilmu Komputer Jurnal Edukasi dan Penelitian Informatika (JEPIN) International Journal of Advances in Intelligent Informatics Scientific Journal of Informatics Journal of Information Systems Engineering and Business Intelligence KLIK (Kumpulan jurnaL Ilmu Komputer) (e-Journal) Journal of Information Technology and Computer Science Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer Jurnal Ilmiah Teknologi Informasi Asia Knowledge Engineering and Data Science Indonesian Journal of Electrical Engineering and Computer Science Indexia : Informatics and Computational Intelligent Journal Prosiding Seminar Nasional Teknik Elektro, Sistem Informasi, dan Teknik Informatika (SNESTIK) Bulletin of Culinary Art and Hospitality Bulletin of Social Informatics Theory and Application
Wayan Firdaus Mahmudy
Brawijaya University
Agriculture, Biological Sciences & Forestry Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Economics, Econometrics & Finance Education Electrical & Electronics Engineering Engineering Environmental Science Health Professions Languange, Linguistic, Communication & Media Library & Information Science Social Sciences

Published : 139 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search
Journal : Bulletin of Social Informatics Theory and Application

 1 
Database optimization for improved system performance and response time of hospital management information system Bayu Rahayudi; Nurizal Dwi Priandani; Buce Trias Hanggara; Wayan Firdaus Mahmudy
Bulletin of Social Informatics Theory and Application Vol. 5 No. 2 (2021)
Publisher : Association for Scientific Computing Electrical and Engineering

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31763/businta.v5i2.491

Abstract

A Regional Hospital in East Java has implemented a Hospital Management Information System, namely SIMRS, in their data management system but has experienced problems in the form of slow system response when accessed by many users, was experienced in the last years when the system had been running for four years since 2016. The system’s slow response causes hospital services to be disrupted and also the quality of service to decline. So, an analysis to the existing database system is carried out, which includes an analysis of the system‘s database performance. Since many SIMRS use database servers on their data processing, then their applications will be based on executing queries and stored procedures (most of the queries are stored in stored procedures). So that, analysis of those queries will be carried out. The optimization process will include analyzing and mapping the database’s queries, profiling, and analyzing the Actual Execution Plan. By doing so, it is known which parts of the query are causing a decrease in performance and time system response. Based on the analysis results, recommendations are given for improving and rewriting several stored procedures and query statements, and the system response time is getting better.
Co-Authors A.N. Afandi Abdul Latief Abadi Achmad Arwan Achmad Basuki Achmad Ridok Adyan Nur Alfiyatin Adyan Nur Alfiyatin Agung Mustika Rizki Agung Mustika Rizki Agung Mustika Rizki Agung Mustika Rizki, Agung Mustika Agung Setia Budi Agus Naba Agus Wahyu Widodo Agus Wahyu Widodo Ahmad Afif Supianto Ahmad Afif Supianto Ahmad Afif Supianto Aji Prasetya Wibawa Alfiani Fitri Alfita Rakhmandasari Amalia Kartika Ariyani Amalia Kartika Ariyani Amalia Kartika Ariyani Anam, Syaiful Anantha Yullian Sukmadewa Andi Hamdianah Andi Maulidinnawati A K Parewe Andi Maulidinnawati A. K. Parewe Andreas Nugroho Sihananto Andreas Pardede Andreas Patuan G. Pardede Angga Vidianto Aprilia Nur Fauziyah Aprilia Nur Fauziyah Arief Andy Soebroto Arinda Hapsari Achnas Arviananda Bahtiar Asyrofa Rahmi Asyrofa Rahmi Asyrofa Rahmi Asyrofa Rahmi Asyrofa Rahmi, Asyrofa Bagus Priambodo Bagus Priambodo Bayu Rahayudi Binti Robiyatul Musanah Buce Trias Hanggara Budi Darma Setiawan Candra Dewi Candra Fajri Ananda Cleoputri Yusainy Dea Widya Hutami Diah Anggraeni Pitaloka Dinda Novitasari Diny Melsye Nurul Fajri Dita Sundarningsih Diva Kurnianingtyas Durrotul Fakhiroh Dyan Putri Mahardika Edy Santoso Edy Santoso Eko Widaryanto Elta Sonalitha Ervin Yohannes Ervin Yohannes, Ervin Evi Nur Azizah Fais Al Huda Faiz Alqorni Farid Jauhari Fatchurrochman Fatchurrochman Fatwa Ramdani, Fatwa Fauziatul Munawaroh Fendy Yulianto Fita Lathifatul Mu’asyaroh Fitra A. Bachtiar Fitra A. Bachtiar Fitri Anggarsari Fitria Dwi Nurhayati Garsinia Ely Riani Gayatri Dwi Santika Ghenniy Rachmansyah Ghozali Maski Grady Davinsyah Gusti Ahmad Fanshuri Alfarisy Gusti Ahmad Fanshuri Alfarisy Gusti Eka Yuliastuti Hafidz Ubaidillah Herman Tolle Herman Tolle Hilman Nuril Hadi Ida Wahyuni Imada Nur Afifah Imam Cholisoddin Imam Cholissodin Imam Cholissodin Indriati Indriati Irvi Oktanisa Irvi Oktanisa Ishardita Pambudi Tama Ismiarta Aknuranda Kuncahyo Setyo Nugroho Kuncahyo Setyo Nugroho Luh Putu Ratna Sundari Luthfi Hidayat M Chandra Cahyo Utomo M Shochibul Burhan M. Chandra Cahyo Utomo M. Shochibul Burhan M. Zainal Arifin M.Shochibul Burhan Mabafasa Al Khuluqi Mar'i, Farhanna Marji Marji Mayang Anglingsari Putri Mochammad Anshori Moh. Zoqi Sarwani Mohammad Zoqi Sarwani Mohammad Zoqi Sarwani Mohammad Zoqi Sarwani Muh Arif Rahman Muh. Arif Rahman Muhaimin Rifa’i Muhammad Ardhian Megatama Muhammad Faris Mas'ud Muhammad Halim Natsir Muhammad Isradi Azhar Muhammad Khaerul Ardi Muhammad Noor Taufiq Muhammad Rivai Muhammad Rofiq Mukhammad Wildan Alauddin Nadia Roosmalita Sari Nadia Roosmalita Sari Nadia Roosmalita Sari Nadya Oktavia Rahardiani Nashi Widodo Nindynar Rikatsih Nindynar Rikatsih Novi Nur Putriwijaya Nurizal Dwi Priandani Philip Faster Eka Adipraja Prayudi Lestantyo Purnomo Budi Santoso Putra, Firnanda Al Islama Achyunda Putu Bagus Arya Putu Indah Ciptayani Qoirul Kotimah Rafiuddin Rody Rani Kurnia Rayandra Yala Pratama Reiza Adi Cahya Retno Dewi Anissa Ria Febriyana Rifki Setya Armanda Rinda Wahyuni Rizal Setya Perdana Rizdania Dermawi Rizka Suhana Rizki Ramadhan Ruth Ema Febrita Ryan Iriany S, M Zaki Samaher . Santika, Gayatri Dwi Saragih, Triando Hamonangan Sari, Nadia Roosmalita Sari, Nadia Roosmalita Selly Kurnia Sari Sudarto Sudarto Sutrisno . Sutrisno Sutrisno Syafrial Syafrial Syafrial Syafrial Syandri, Hafrijal Tirana Noor Fatyanosa Titiek Yulianti Titiek Yulianti Titiek Yulianti Tomi Yahya Christyawan Tri Halomoan Simanjuntak Ullump Pratiwi Utaminingrum, Fitri Vitara Nindya Putri Hasan Vivi Nur Wijayaningrum Vivi Nur Wijayaningrum Wahyuni, Ida Widdia Lesmawati Windi Artha Setyowati Yeni Herawati Yogi Pinanda Yogie Susdyastama Putra Yudha Alif Aulia Yudha Alif Auliya Yulia Trianandi Yusuf Priyo Anggodo Yusuf Priyo Anggodo Yusuf Priyo Anggodo Yusuf Priyo Anggodo