Article Per Year (5 Year)
p-Index From 2021 - 2026
0.562
P-Index
This Author published in this journals
All Journal Applied Engineering: Jurnal Rekayasa dan Sains Terapan
Darmawan Yudhanegara
Digitech University, Bandung, Indonesia

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

Found 3 Documents
Search

 1 
Query Performance Optimization in MySQL Databases: An Experimental Analysis of Normalization and Indexing Risman Kurniawan; Sahal Husmah; Darmawan Yudhanegara
Applied Engineering: Jurnal Rekayasa dan Sains Terapan Vol. 1 No. 1 (2026): Applied Engineering
Publisher : GRM Academic Press

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.67710/appliedengineering.v1i1.6

Abstract

The rapid growth of information systems has increased the demand for database architectures that are able to provide fast, accurate, consistent, and efficient data access. However, many small- and medium-scale information systems still encounter performance problems caused by suboptimal database design, including data redundancy, update anomalies, inconsistent records, and slow query execution. These problems become more critical when the volume of stored data increases and database transactions involve frequent retrieval, insertion, and updating operations. This study aims to analyze the effect of normalization and indexing techniques on database performance optimization in a relational database environment. An experimental method was applied by comparing query execution performance before and after optimization. The experiment was conducted using MySQL as the database management system with a dataset consisting of 50,000 records. Several query operations were tested, including SELECT, INSERT, and UPDATE, to evaluate the impact of structural design improvement and index implementation on query response time. The results indicate that normalization improves database structure by reducing redundancy, minimizing data anomalies, and supporting better data consistency. In addition, indexing substantially improves retrieval performance, particularly in SELECT operations, with query execution time reduced by up to 70% after optimization. Nevertheless, the implementation of indexes must be carefully planned because excessive or inappropriate indexing may increase storage requirements and affect write operations. This study contributes practical insights for database designers, developers, and system administrators in optimizing relational database performance through appropriate schema design and indexing strategies, particularly for small- and medium-scale information systems.
QoS Optimization in 5G Networks Using Network Slicing: A Systematic Review of Algorithms, Efficiency, and Security Issues Muhammad Fachri Husaini; Yadi Sukma Priharyadi; Darmawan Yudhanegara
Applied Engineering: Jurnal Rekayasa dan Sains Terapan Vol. 1 No. 1 (2026): Applied Engineering
Publisher : GRM Academic Press

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.67710/appliedengineering.v1i1.11

Abstract

The emergence of 5G networks has created a growing demand for adaptive Quality of Service (QoS) optimization mechanisms due to the wide range of service requirements, including eMBB, mMTC, and uRLLC. Network slicing offers a strategic solution by logically separating network resources to ensure stable and reliable performance for each service category. This study applies a Systematic Literature Review (SLR) approach to synthesize and evaluate scientific findings related to optimization algorithms, resource efficiency, and security issues in network slicing. A total of 30 studies published between 2020 and 2025 were analyzed through a rigorous selection process using inclusion–exclusion criteria and a Quality Assessment Checklist (QAC). The results indicate that artificial intelligence-based algorithms, particularly Reinforcement Learning, significantly improve throughput and reduce latency but require substantial computational resources. Meanwhile, spectrum and energy efficiency are enhanced by adaptive orchestration techniques, although most studies still focus on single QoS parameters. Security analysis shows that cross-slice attacks remain a major threat, and integrated security frameworks are rarely implemented. This study highlights the need for a unified intelligent orchestration model that simultaneously integrates algorithmic optimization, energy efficiency, and slice-aware security to support reliable 5G and future 6G networks.
Requirements Analysis and Initial Use Case Design of a Web-Based Student Data Management Information System at SMP Negeri 37 Bandung Annisa Nur Rohmah; Muhammad Khali Fauzy; Micky Ardian Ananta; Darmawan Yudhanegara
Applied Engineering: Jurnal Rekayasa dan Sains Terapan Vol. 1 No. 1 (2026): Applied Engineering
Publisher : GRM Academic Press

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.67710/appliedengineering.v1i1.12

Abstract

Student data management is an essential component of school administration because it supports identity recording, administrative reporting, and information retrieval for institutional decision-making. However, in many schools, student data are still managed manually or using simple spreadsheet-based applications, which may cause data duplication, input errors, slow data retrieval, and inefficiency in report preparation. This study aims to analyze the requirements and develop an initial use case design for a web-based student data management information system at SMP Negeri 37 Bandung. The study employed a descriptive qualitative approach focusing on the early stage of the information system development cycle, namely requirement analysis. Data were collected through observation, interviews with school administrative staff, and literature study. The collected data were analyzed descriptively to identify the current condition of student data management, functional requirements, non-functional requirements, user roles, and initial data structure. The results show that the proposed system should provide several main functions, including adding student data, editing student data, deleting student data, displaying student data, searching student data, and printing student data reports. The system also needs to fulfill non-functional requirements related to accessibility, security, usability, and reliability. The proposed use case design identifies administrative staff as the main actor responsible for managing student data through the system. This study contributes an initial requirement analysis and use case design that can serve as a foundation for further system design, database development, interface design, implementation, and testing.
Co-Authors Annisa Nur Rohmah Micky Ardian Ananta Muhammad Fachri Husaini Muhammad Khali Fauzy Risman Kurniawan Sahal Husmah Yadi Sukma Priharyadi