Claim Missing Document
Check
Articles

Found 7 Documents
Search

Database Tuning in Hospital Applications Using Table Indexing and Query Optimization Samidi, Samidi; Iskandar, Daniel; Fachruroji, Muhamad; Septyo Wibowo, Wahyu Adi; Khaerani A, Afifah
Jurnal Pendidikan Tambusai Vol. 6 No. 1 (2022): April 2022
Publisher : LPPM Universitas Pahlawan Tuanku Tambusai, Riau, Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (653.753 KB)

Abstract

RDBMS telah menjadi kebutuhan mendasar bagi semua perusahaan dan diharapkan dapat memberikan informasi secara tepat waktu, akurat, dan andal. Sayangnya, pertumbuhan data yang eksponensial biasanya menyebabkan masalah kinerja database, yaitu waktu eksekusi kueri yang lambat sebagai salah satu masalah utama. Pilihan untuk meningkatkan kinerja database adalah dengan melakukan penyetelan database menggunakan pengindeksan tabel dan optimisasi kueri. Tujuan utama dari penelitian eksperimental ini adalah untuk membandingkan waktu respon database sebelum dan sesudah proses tuning database. Kami memilih Sistem Informasi Rumah Sakit sebagai objek kami di mana kami mengerjakan jutaan data dan mengeksekusi beberapa kueri SQL untuk melihat perbedaan waktu respons sebelum dan sesudah penyetelan basis data. Akibatnya, untuk mengambil 1.039.852 baris data Patient Care dibutuhkan 743 detik sebelum penyetelan, dan hanya 46 detik setelah penyetelan.
Database Tuning in Hospital Applications Using Table Indexing and Query Optimization Samidi, Samidi; Iskandar, Daniel; Fachruroji, Muhamad; Septyo Wibowo, Wahyu Adi; Khaerani A, Afifah
Jurnal Pendidikan Tambusai Vol. 6 No. 1 (2022): 2022
Publisher : LPPM Universitas Pahlawan Tuanku Tambusai, Riau, Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31004/jptam.v6i1.3241

Abstract

RDBMS telah menjadi kebutuhan mendasar bagi semua perusahaan dan diharapkan dapat memberikan informasi secara tepat waktu, akurat, dan andal. Sayangnya, pertumbuhan data yang eksponensial biasanya menyebabkan masalah kinerja database, yaitu waktu eksekusi kueri yang lambat sebagai salah satu masalah utama. Pilihan untuk meningkatkan kinerja database adalah dengan melakukan penyetelan database menggunakan pengindeksan tabel dan optimisasi kueri. Tujuan utama dari penelitian eksperimental ini adalah untuk membandingkan waktu respon database sebelum dan sesudah proses tuning database. Kami memilih Sistem Informasi Rumah Sakit sebagai objek kami di mana kami mengerjakan jutaan data dan mengeksekusi beberapa kueri SQL untuk melihat perbedaan waktu respons sebelum dan sesudah penyetelan basis data. Akibatnya, untuk mengambil 1.039.852 baris data Patient Care dibutuhkan 743 detik sebelum penyetelan, dan hanya 46 detik setelah penyetelan.
Optimasi Penilaian Risiko Kredit BNPL melalui Integrasi Algoritma K-Means Clustering dan Random Forest untuk Segmentasi Pengguna di Ekosistem Fintech Khaerani A, Afifah
Indonesian Journal of Thousand Literacies Vol. 1 No. 5 (2023): Indonesian Journal of a Thousand Literacy
Publisher : Nindikayla Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.57254/ijtl.v1i5.80

Abstract

Buy Now Pay Later (BNPL) services have revolutionized digital credit access, yet they present new challenges in credit risk management due to the limitations of traditional financial data. This study aims to optimize credit risk assessment by integrating machine learning techniques, specifically K-Means Clustering for customer segmentation and Random Forest Classifier for default prediction (default_flag). Data were analyzed using Principal Component Analysis (PCA), which successfully retained 74.70% of the data variance to validate the cluster structure. The study identified three unique segments: The Safe Strategists, The High-Risk Youth, and The Affluent Late-Payers. The implementation of the Random Forest model demonstrated stable performance with an accuracy rate of 70% and a weighted recall of 70%. Feature Importance analysis revealed that digital behavioral variables, such as repayment_delay_days and app_usage_frequency, are significant predictors that compete with conventional indicators like credit_score. These findings emphasize the importance of transforming from static credit scoring to dynamic behavioral scoring to mitigate systemic risks within the Fintech ecosystem.
Optimasi Performa Web Service melalui Penguatan Logika Asynchronous JavaScript for Server-Side Development pada Pelatihan Nasional Bangkit 2024 Batch 2 Pilliang, Marzuki; Khaerani A, Afifah
Ekalaya: Jurnal Pengabdian Kepada Masyarakat Indonesia Vol. 4 No. 3 (2025): Ekalaya Journal
Publisher : Nindikayla Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.57254/eka.v4i3.150

Abstract

Web service efficiency in handling concurrent requests is a crucial parameter in large-scale application development. Server-side JavaScript, through Node.js, offers a solution via non-blocking architecture, yet its effectiveness heavily depends on the precision of asynchronous logic implementation by the developer. This Community Service (PkM) activity aims to optimize students' technical abilities in building high-performance web services within the 2024 Bangkit Academy Batch 2 Program. The implementation method was conducted through a national online workshop emphasizing asynchronous design patterns, event loop management, and race condition mitigation techniques. The results indicate an increase in participants' capabilities to reduce system latency through the efficient use of Promises and Async-Await. Technical evaluations prove that strengthening this logic not only enhances code execution speed but also ensures the reliability of web services in handling intensive workloads according to global financial and technology industry standards.
Akselerasi Kompetensi Backend Developer melalui Penguatan Logika Asynchronous JavaScript for Server-Side Development pada Program Bangkit Academy Batch 1 Tahun 2024 Pilliang, Marzuki; Khaerani A, Afifah
Ekalaya: Jurnal Pengabdian Kepada Masyarakat Indonesia Vol. 4 No. 3 (2025): Ekalaya Journal
Publisher : Nindikayla Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.57254/eka.v4i3.151

Abstract

The dominance of JavaScript in the modern web development ecosystem requires backend developers to master non-blocking programming paradigms to build scalable systems. However, the complexity of asynchronous logic often poses a cognitive barrier for novice developers in managing intensive I/O operations. This Community Service (PkM) activity aims to accelerate the technical competencies of student participants in the 2024 Bangkit Academy Batch 1 Program by strengthening Asynchronous JavaScript concepts on the server side. The implementation method was conducted online nationwide through expert-led instruction sessions, code reviews, and the implementation of callbacks, promises, and async-await within the Node.js environment. The results of the activity indicate a significant increase in participants' capabilities to design efficient and low-latency server workflows. Project-based evaluations prove that a profound understanding of asynchronous logic successfully enhances code quality and participants' technical readiness to face application development challenges at global industry standards.
Mitigasi Risiko Social Engineering dan Keamanan Identitas Digital pada Ekosistem Mobile Banking melalui Edukasi Preventif bagi Siswa SMA Kota Tangerang Rahman, Abdul; Wiwin, Neng; Khaerani A, Afifah
Ekalaya: Jurnal Pengabdian Kepada Masyarakat Indonesia Vol. 4 No. 3 (2025): Ekalaya Journal
Publisher : Nindikayla Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.57254/eka.v4i3.152

Abstract

The digital transformation in the banking sector has increased financial accessibility for the younger generation, yet it has also expanded vulnerabilities to cyberattacks based on psychological manipulation. High school students, as active users of mobile banking, often become primary targets of social engineering crimes due to limited literacy regarding digital identity security. This Community Service (PkM) activity aims to enhance students' awareness and technical capabilities in mitigating digital fraud risks within the banking ecosystem. The implementation method was conducted through expert-sharing sessions based on the experience of banking IT practitioners, phishing attack simulations, and education on protecting credentials such as PINs and OTPs. The results indicated a significant increase in students' awareness of recognizing information manipulation patterns and multi-layered identity protection techniques. The final evaluation proved that this preventive education successfully changed students' digital behavior to be more vigilant, which is a crucial factor in maintaining the integrity of the digital financial ecosystem in the Tangerang City area.
Akselerasi Literasi Digital dan Kapabilitas Strategis Mahasiswa dalam Menyongsong Visi Indonesia Emas 2045 Khaerani A, Afifah
Ekalaya: Jurnal Pengabdian Kepada Masyarakat Indonesia Vol. 4 No. 3 (2025): Ekalaya Journal
Publisher : Nindikayla Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.57254/eka.v4i3.153

Abstract

A national seminar titled "The Role of the Young Generation in Welcoming Indonesia Gold 2045" was organized as a strategic effort to educate and provide insights to the youth regarding their tangible contributions across various development sectors. This community service initiative was conducted at Salakanagara University, involving expert speakers in the field of informatics to discuss the relevance of technology in achieving the national vision. The methodology included socialization through material presentation, interactive discussion forums, and hybrid Q&A sessions (offline and online). Evaluation results indicated high participant enthusiasm with a total attendance of 105 people. Despite minor technical issues with the digital platform and space constraints, the activity successfully raised participant awareness of future challenges. Key recommendations include improving time management and infrastructure facilities for future events to optimize material delivery and participant interaction.