p-Index From 2021 - 2026
6.692
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) Proceedings of Annual International Conference Syiah Kuala University - Life Sciences & Engineering Chapter Bulletin of Electrical Engineering and Informatics Jurnal Infinity Journal of Telematics and Informatics SAMUDERA Scientific Journal of Informatics CESS (Journal of Computer Engineering, System and Science) Register: Jurnal Ilmiah Teknologi Sistem Informasi Jurnal Teknologi Informasi dan Komunikasi InfoTekJar : Jurnal Nasional Informatika dan Teknologi Jaringan Sinkron : Jurnal dan Penelitian Teknik Informatika JOURNAL OF INFORMATICS AND TELECOMMUNICATION ENGINEERING JURNAL MEDIA INFORMATIKA BUDIDARMA Jurnal Pilar Nusa Mandiri Abdimas Talenta : Jurnal Pengabdian Kepada Masyarakat Jurnal Inotera MATRIK : Jurnal Manajemen, Teknik Informatika, dan Rekayasa Komputer JISTech (Journal of Islamic Science and Technology) Building of Informatics, Technology and Science Jurnal Mantik MES: Journal of Mathematics Education and Science Jurnal Varian International Journal of Advances in Data and Information Systems Computer Science and Information Technologies Journal of Innovation Information Technology and Application (JINITA) Randwick International of Social Science Journal Journal of Research in Mathematics Trends and Technology Jurnal Teknik Informatika (JUTIF) Journal of Applied Data Sciences Journal for Lesson and Learning Studies International Journal of Humanities Education and Social Sciences Jurnal MathEducation Nusantara International Journal of Community Service Implementation Jurnal Infinity
Claim Missing Document
Check
Articles

Found 2 Documents
Search
Journal : Jurnal Teknik Informatika (JUTIF)

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.
Evaluating the Impact of Model Complexity on the Accuracy of ID3 and Modified ID3: A Case Study of the Max_Depth Parameter Asrianda, Asrianda; Mawengkang, Herman; Sihombing, Poltak; K. M. Nasution , Mahyuddin
Jurnal Teknik Informatika (Jutif) Vol. 6 No. 5 (2025): JUTIF Volume 6, Number 5, Oktober 2025
Publisher : Informatika, Universitas Jenderal Soedirman

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

Abstract

The complexity of decision tree structures has a direct impact on the generalization capability of classification algorithms. This study investigates and evaluates the performance of the classical ID3 algorithm and its modified version in the context of tree depth. The primary objective is to identify the optimal accuracy point and assess the algorithms' robustness against overfitting. Experiments were conducted across tree depths ranging from 1 to 20, with accuracy used as the main evaluation metric. The results indicate that both algorithms achieved peak performance at depth 3, followed by a notable decline. While the classical ID3 algorithm exhibited a gradual decrease in accuracy, the modified ID3 showed a sharp drop and performance stagnation between depths 11 and 20. These findings suggest that the modified ID3 algorithm enhances sensitivity in selecting informative attributes but also increases the risk of overfitting in the absence of structural regularization mechanisms. Therefore, the study recommends the implementation of regularization strategies such as pruning and cross-validation to mitigate performance degradation caused by model complexity. This research not only contributes to the theoretical understanding of how tree depth influences classification performance but also offers practical insights for developing adaptive, stable, and accurate decision tree-based classification systems.
Co-Authors , Rahmad Sembiring Abi Rafdi Afdhaluzzikri, Afdhaluzzikri Afnaria, Afnaria Ahmad Zaki Mubarak, Ahmad Zaki Al Khowarizmi Anggi Anatasia Kinanti Anugreni, Fera Arjon Turnip Asrianda Asrianda Azmi, Zulfian - Badawi, Afif Buaton, Relita Budhiarti, Erna Christefa, Dea Christian Sinaga, Christian Dadang Priyanto Dedi Siswo Defri Muhammad Chan Deny Jollyta Efendi, Syahril Elly Rosmaini Ermawati Ermawati Erna B N Erna Budhiarti Nababan Fatma Sari Hutagalung Firmansyah Firmansyah Firmansyah Firmansyah Fitrie, Rosa Hadistio, Ryan Rinaldi Handayani, Sri Hartama, Dedy Hasugian , Paska Marto Hengki Tamando Sihotang Hengki Tamando Sihotang Heni Pujiastuti Herawati, Elvina Heri Gustami Husain Husain Husain Husain Ignazio Ahmad Pasadana Iin Parlina Indah Purnama Sari Juanda Hakim Lubis Juanda Hakim Lubis K. M. Nasution , Mahyuddin Lestari, Valencya lili Tanti Lismardiana Lismardiana Lusi Herlina Siagian M Safii M Zarlis Mahyuddin K. M Nasution Mardiningsih Mardiningsih, Mardiningsih Marpongahtun Marwan Ramli Maya Silvi Lydia Mochamad Wahyudi Muhammad Arif Satria Nasution Muhammad Zarlis Muhammad Zarlis Muhammad Zarlis Muhammad Zarlis, Muhammad Muliawan Firdaus Napitupulu, Fajrul Malik Aminullah Nuraini Nuraini Oktaviana Bangun Opim Salim Sitompul Ovirianti, Nurul Huda Pasaribu, Suhendri Poltak Sihombing Prandana, Randy Pujiastuti, Lise Putri, Mimmy Sari Syah Rahman, Silvi Anggraini Resti, Lady Ichwana Roma Rezeki Ryan Rinaldi Hadistio Saib Suwilo Saib Suwilo Santoso, Ahmad Imam Sarif, Muhammad Irfan Sawaluddin Nasution Sawaluddin Sawaluddin, Sawaluddin Sri Handayani Sugiyarmasto Sugiyarmasto Sutarman Sutarman Sutarman Sutarman Sutarman Syahmrani, Aghni Syahputra, Muhammad Romi Syahril Effendi Tanjung, Ilyas Tulus Tulus Tulus Tulus Vinsensia, Desi Weber, Gerhard Wilhelm Wiryanto Wiryanto Wisnu Irsandi Pratama Yuliska Zakarias Situmorang Zarkasyi, Muhammad Imam Zarlis, M Zarlis, M Zoelkarnain Rinanda Tembusai Zulfian Azmi