Article Per Year (5 Year)
p-Index From 2020 - 2025
0.408
P-Index
This Author published in this journals
All Journal Jurnal Teknik Informatika (JUTIF) Jurnal ABDIMAS MUTIARA
Napitupulu, Fajrul Malik Aminullah
Unknown Affiliation
Chemistry Computer Science & IT Medicine & Pharmacology Nursing Other

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

Found 2 Documents
Search

 1 
Performance Optimization of ERD Designs Using Cost-Based Optimization for Large-Scale Query Processing Lubis, Juanda Hakim; Handayani, Sri; Mawengkang, Herman; Napitupulu, Fajrul Malik Aminullah
Jurnal Teknik Informatika (Jutif) Vol. 6 No. 3 (2025): JUTIF Volume 6, Number 3, Juni 2025
Publisher : Informatika, Universitas Jenderal Soedirman

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.52436/1.jutif.2025.6.3.4523

Abstract

The rapid growth of stored data, particularly on magnetic disks, is doubling annually for each department within a company, creating a pressing need for efficient database management. While database design is a fundamental step in establishing a high-performance system, it alone is insufficient to ensure optimal efficiency. Query optimization plays a critical role in improving data transaction speed, reducing query execution time, and enhancing overall system responsiveness. This study evaluates various relational database models under different data volumes to analyze their impact on query performance. Using the Cost-Based Optimizer method and access time measurements, we assess query costs and determine the factors influencing performance. The results indicate that among the three database models analyzed, ERD-3 consistently delivers superior performance, especially in handling complex queries. This is attributed to its modular structure, strategic indexing, and reduced full table scans, which collectively minimize query execution costs. Additionally, several key factors significantly affect query performance, including record count, attribute size, query complexity, primary and unique key usage, indexing strategies, order-by clauses, index sequences, and SQL function application. This research contributes to the field of database optimization by demonstrating that ERD structuring and cost-based query analysis significantly improve system efficiency in large-scale environments. These findings emphasize the necessity of a well-structured, scalable database model and efficient query processing techniques to accommodate large-scale data growth. The study’s conclusions provide a foundation for advanced optimization strategies, ensuring that modern database systems remain efficient and adaptable to evolving data demands.
PENINGKATAN KOMPETENSI PEMROGRAMAN BERORIENTASI OBJEK MELALUI PELATIHAN BAHASA JAVA BAGI SISWA SMKN 3 MEDAN Napitupulu, Fajrul Malik Aminullah; Riah Ukur Ginting; Juanda Hakim Lubis; Akhyar Lubis
Jurnal Abdimas Mutiara Vol. 6 No. 2 (2025): JURNAL ABDIMAS MUTIARA (IN PRESS)
Publisher : Universitas Sari Mutiara Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.51544/jam.v6i2.6141

Abstract

Kegiatan pengabdian masyarakat ini bertujuan untuk meningkatkan kompetensi siswa SMK dalam pemrograman berorientasi objek (Object-Oriented Programming/OOP) menggunakan bahasa Java. Pelatihan dilaksanakan pada siswa kelas XI Rekayasa Perangkat Lunak (RPL) SMKN 3 Medan dengan pendekatan praktik langsung (hands-on) selama satu hari penuh. Materi pelatihan meliputi dasar-dasar OOP, pembuatan kelas dan objek, serta konsep inheritance dan polymorphism. Hasil pelatihan menunjukkan peningkatan pemahaman siswa terhadap konsep OOP, ditunjukkan melalui post-test dan evaluasi proyek sederhana. Diharapkan kegiatan ini dapat memberikan kontribusi nyata terhadap penguatan kompetensi siswa dalam bidang pemrograman modern yang relevan dengan kebutuhan industri.
Co-Authors Akhyar Lubis Handayani, Sri Herman Mawengkang Juanda Hakim Lubis Juanda Hakim Lubis Riah Ukur Ginting