cover
Contact Name
Muhammad Wali
Contact Email
muhammadwali@amikindonesia.ac.id
Phone
+6285277777449
Journal Mail Official
ijsecs@lembagakita.org
Editorial Address
Jl. Teuku Nyak Arief No. 7b 23112, Kota Banda Aceh, Banda Aceh, Provinsi Aceh
Location
,
INDONESIA
International Journal Software Engineering and Computer Science (IJSECS)
ISSN : 27764869     EISSN : 27763242     DOI : https://doi.org/10.35870/ijsecs
Core Subject : Science,
IJSECS is committed to bridge the theory and practice of information technology and computer science. From innovative ideas to specific algorithms and full system implementations, IJSECS publishes original, peer-reviewed, and high quality articles in the areas of information technology and computer science. IJSECS is a well-indexed scholarly journal and is indispensable reading and references for people working at the cutting edge of information technology and computer science applications..
Articles 535 Documents
Performance Analysis of Oracle Database 23ai on SELECT Queries and VIEW Statements Under Intensive Iterations Yosafat Stephen Suryadarma; Dian Widiyanto Chandra
International Journal Software Engineering and Computer Science (IJSECS) Vol. 6 No. 3 (2026): DECEMBER 2026
Publisher : Lembaga Komunitas Informasi Teknologi Aceh (KITA), Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35870/ijsecs.v6i3.8351

Abstract

The rapid growth of data volume demands efficient data management techniques, where appropriate query writing strategies become a crucial factor in maintaining system performance. This study aimed to analyze the performance of SELECT and VIEW commands on Oracle Database 23ai, specifically under intensive benchmarking involving thousands of iterations and massive workloads. An experimental quantitative method was implemented using a Java-based application utilizing the Operating System and Hardware Information (OSHI) library to monitor system resource usage in real time. Testing was conducted on a simulation dataset generating 40,000 rows of joined query results derived from a 40,000-row orders table and a 10,000-row customers table (~10.44 MB), with workload variations ranging from 10 to 10,000 iterations. Performance metrics evaluated included response time as well as CPU, RAM, and disk utilization. The results demonstrated that the SELECT command achieved superior performance at low iteration scales (10–100 iterations) with faster response times. Conversely, the VIEW command demonstrated more optimal execution at high iteration scales (1,000–10,000 iterations), yielding lower average execution times than SELECT. In terms of hardware utilization, VIEW consistently maintained more efficient RAM management across all iteration levels. The performance stability of both commands was governed by the database buffer cache mechanism and the operational transition from hard parse to soft parse after the initial execution phase. This study concludes that selecting between SELECT and VIEW must strictly account for the execution scale: SELECT is recommended for low-scale queries requiring immediate response, whereas VIEW provides a more sustainable solution for enterprise systems executing repetitive, large-scale workloads.
Implementation of a Web-Based Sales Information System for Culinary MSMEs: A Case Study of Bakmi Jogja and Mie Ayam Bangka Alya Kamila; Fatchurrachman Fatchurrachman; Mesra Betty Yel
International Journal Software Engineering and Computer Science (IJSECS) Vol. 6 No. 3 (2026): DECEMBER 2026
Publisher : Lembaga Komunitas Informasi Teknologi Aceh (KITA), Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35870/ijsecs.v6i3.8352

Abstract

Micro, small, and medium enterprises (MSMEs) play a vital role in the local economy, yet many still rely on manual recording of sales transactions and financial reports, increasing the risk of calculation errors and delaying report preparation. This operational constraint was identified at Bakmi Jogja and Mie Ayam Bangka, a culinary MSME outlet in Cipinang Besar Selatan, East Jakarta, that offers two flagship menu lines within a single business establishment. This study aimed to design, implement, and evaluate a web-based sales information system to address these operational challenges. A descriptive qualitative case-study method was applied, with empirical data gathered through interviews, direct observation, and literature review. System development followed the Prototype model comprising communication, quick planning, modeling, prototype construction, and deployment with user feedback. The system was developed using the CodeIgniter 4 framework, a MySQL/MariaDB database, and the Midtrans payment gateway for QRIS-based digital payments, followed by deployment on commercial cloud hosting for actual operational adoption rather than offline simulation. Black box testing evaluating authentication, product management, transaction recording, payment integration, order-status tracking, promotional banner management, and financial reporting yielded valid results across all twelve test scenarios spanning seven functional modules. As early empirical evidence, the system logged five operational transactions over a seven-day observation window, four of which were completed with confirmed revenue of IDR 224,000, identifying Bakmi Jogja Godog Special as the top-selling menu item. These findings demonstrate that the system transitioned manual record-keeping to automated, database-backed transactions, accelerated financial report generation from approximately one week to an on-demand summary, and provided a digital storefront facilitating online ordering and marketing for the enterprise.
Multiclass Electrical Fault Classification in Three-Phase Power Systems Using Random Forest, Support Vector Machine, and XGBoost Sri Mardiyati; Pandhu Pramarta
International Journal Software Engineering and Computer Science (IJSECS) Vol. 6 No. 3 (2026): DECEMBER 2026
Publisher : Lembaga Komunitas Informasi Teknologi Aceh (KITA), Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35870/ijsecs.v6i3.8397

Abstract

Electrical fault classification in three-phase power systems remains challenging because different fault conditions can exhibit similar current and voltage characteristics, limiting the diagnostic capability of conventional binary fault detection. This study aimed to compare the performance of Random Forest, Support Vector Machine, and Extreme Gradient Boosting (XGBoost) for multiclass electrical fault classification and to identify the most effective and stable model. The publicly available Electrical Fault Detection and Classification dataset obtained from the Kaggle repository was used in this study. The dataset contains 7,861 observations with six electrical features comprising three-phase currents (Ia, Ib, and Ic) and voltages (Va, Vb, and Vc), which were used to classify six operating conditions: Normal, Line-to-Ground, Line-to-Line, Double Line-to-Ground, Three-Phase, and Three-Phase-to-Ground faults. The models were evaluated using accuracy, precision, recall, F1-score, and five-fold stratified cross-validation, complemented by confusion-matrix and feature-importance analyses. Random Forest achieved the best test performance with an accuracy of 86.78% and an F1-score of 86.76%, while cross-validation produced a mean accuracy of 87.55% and a mean F1-score of 87.53%. Class-level analysis revealed that Three-Phase and Three-Phase-to-Ground faults were the most difficult conditions to distinguish because of substantial overlap in their electrical characteristics. The findings demonstrated that Random Forest provided the most effective and stable classification performance and that combining performance, stability, and class-level analyses provided deeper insight into multiclass electrical fault diagnosis.
A Completeness-Driven Enterprise Architecture for Integrated Smart-Township Operations Using TOGAF ADM, ArchiMate, and the Zachman Framework Stephen Edlin; Erick Dazki; Handri Santoso; Januponsa Dio Firizqi; Richardus Eko Indrajit
International Journal Software Engineering and Computer Science (IJSECS) Vol. 6 No. 3 (2026): DECEMBER 2026
Publisher : Lembaga Komunitas Informasi Teknologi Aceh (KITA), Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35870/ijsecs.v6i3.8489

Abstract

Master-planned townships represent a predominant model of urban expansion in Indonesia, each governed by an operational entity that concurrently coordinates residents, commercial tenants, estate-management teams, and third-party service providers. However, the operational systems supporting these developments remain predominantly fragmented—characterized by estate dues tracked on disparate spreadsheets, resident inquiries and incident reports handled via informal messaging channels, and gate access logged manually—depriving township operators of an integrated, auditable, and data-rich operational platform. Objective: This study establishes a completeness-driven enterprise architecture (EA) framework for integrated smart-township operations. Method: Grounded in Design Science Research, the architecture was developed using the TOGAF Architecture Development Method across Phases A to D, modeled in ArchiMate 3 using the Archi modeling tool, and systematically validated through cross-layer consistency verification, an As-Is versus To-Be gap analysis, and a Zachman 5W1H completeness assessment. Results: The Architecture Vision establishes end-to-end alignment between five stakeholder groups, six strategic operational goals, and their requisite resources. Three core processes—estate dues billing, facility booking with smart access, and resident service with security incident response—are traced from business workflows through application services to underlying cloud and cyber-physical infrastructure, with shared services providing modular integration boundaries. Technology-layer specifications formalize external payment gateways and IoT network connections. The Zachman completeness evaluation indicates that 20 of the 24 cells achieve full coverage, while the remaining four cells (three partial and one weak) converge exclusively within the temporal (When) dimension. Conclusion: The developed enterprise architecture provides an extensible, auditable blueprint for operator-managed townships with an empirically documented coverage profile, wherein the identified temporal gaps establish an explicit empirical trajectory for operational lifecycle scheduling and governance extensions.
Enterprise Architecture Design for a Human Resource Information System in a Tire Manufacturing Company Naura Anasya; Januponsa Firizqi; Erick Dazki; Handri Santoso; Richardus Indrajit
International Journal Software Engineering and Computer Science (IJSECS) Vol. 6 No. 3 (2026): DECEMBER 2026
Publisher : Lembaga Komunitas Informasi Teknologi Aceh (KITA), Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35870/ijsecs.v6i3.8501

Abstract

Large manufacturing companies run many human resource (HR) procedures to manage a sizeable workforce, from recruitment and onboarding to attendance, leave, career changes, and training. In practice, these procedures are often supported by a mix of manual steps and several separate applications that are added over time without a single architectural plan. The result is duplicated data entry, fragmented records across departments, and limited traceability between HR objectives and the systems that support them. This study designs an enterprise architecture (EA) for the human resource information system (HRIS) of a large tire manufacturing company, kept anonymous for confidentiality, using the TOGAF Architecture Development Method (Preliminary Phase through Phase F) and ArchiMate 3.1 within a design science research approach. Guided by eight contextualised architecture principles, eighteen official internal HR work-procedure documents were analysed and structured into six core business capabilities across the motivation, business, application, and technology layers, followed by an as-is versus to-be gap analysis. The resulting reference architecture resolves four critical architectural gaps: establishing a single governed employee data repository, unifying multi-level approval workflows, digitising manual administrative forms, and replacing manual multi-plant attendance reconciliation with a scheduled interface between biometric devices and the HRIS Core linked to payroll. Evaluated against four design science criteria—consistency, completeness, traceability, and applicability—the architecture provides end-to-end traceability from managerial drivers to database infrastructure and defines an actionable four-stage, twelve-month migration roadmap. The study contributes a validated, reusable EA model for enterprise HRIS in a labour-intensive manufacturing environment, addressing an empirical gap in prior TOGAF-based case literature.