Abstract:Abstract: The development of digital learning systems requires not only effective content delivery but also database consistency and performance, particularly when used at scale by lecturers and students. Weaknesses in database…
atabase design can lead to data duplication, relational violations, and transaction failures that compromise system reliability. This study designed the Royal Mengajar application using PHP and MySQL, supported by JavaScript, HTML, and Bootstrap 5. The Crowdsourced Academic Content model enables lecturers to contribute learning materials openly, while students evaluate them through a user rating system. The objective of this research is to design and optimize the database architecture of the Royal Mengajar application by implementing multiple control mechanisms—namely views, triggers, transactions, and constraints—to enhance data efficiency, consistency, and integrity in digital learning environments. Database optimization focuses on the use of views to improve query efficiency, triggers to maintain automatic consistency, transactions to ensure atomicity in multi-table operations, and constraints to preserve data integrity. The results show that views reduced the average query execution time to 0.12 seconds, triggers maintained consistency without manual intervention, and constraints achieved 100% referential integrity. The application of these mechanisms significantly improved system speed, reduced data redundancy, and enhanced information reliability, thus reinforcing the sustainability of Royal Mengajar as a community-driven learning platform
Keywords: crowdsourced academic content; constraint; database optimization; trigger.
Abstrak: Pengembangan sistem pembelajaran digital tidak hanya menuntut penyajian materi, tetapi juga konsistensi serta kinerja basis data ketika sistem digunakan secara masif oleh dosen dan mahasiswa. Kelemahan rancangan database dapat menimbulkan duplikasi data, pelanggaran relasi, dan kegagalan transaksi yang memengaruhi keandalan sistem. Penelitian ini merancang aplikasi Royal Mengajar berbasis PHP dan MySQL dengan dukungan JavaScript, HTML, dan Bootstrap 5. Model Crowdsourced Academic Content memungkinkan dosen berkontribusi secara terbuka, sedangkan mahasiswa melakukan evaluasi melalui user rating system. Tujuan penelitian ini adalah untuk merancang dan mengoptimalkan basis data aplikasi Royal Mengajar melalui penerapan berbagai mekanisme pengendali, seperti view, trigger, transaction, dan constraint, guna meningkatkan efisiensi, konsistensi, dan integritas data dalam sistem pembelajaran digital. Optimalisasi database difokuskan pada penerapan view untuk efisiensi query, trigger untuk menjaga konsistensi otomatis, transaction untuk memastikan atomicity pada operasi multi-tabel, serta constraint guna menjamin integritas data. Hasil pengujian menunjukkan view menurunkan rata-rata waktu eksekusi query menjadi 0,12 detik, trigger menjaga konsistensi tanpa intervensi manual, dan constraint memastikan integritas referensial tercapai 100%. Penerapan mekanisme ini berdampak pada peningkatan kecepatan sistem, berkurangnya redundansi, serta keandalan informasi yang lebih tinggi, sehingga mendukung keberlanjutan Royal Mengajar sebagai platform pembelajaran berbasis kontribusi komunitas.
Kata kunci: basis data; optimasi; trigger; constraint; crowdsourced academic content.
Abstract:Abstract: The rice plant, Oryza sativa, is a major food source in Indonesia. This plant is processed into rice, a staple food for the Indonesian people. Rice growth is crucial to ensure the rice produced is of good quality.…
ty. One part of the rice plant that is susceptible to disease is the leaves, which can inhibit growth and reduce rice quality. Therefore, early detection and accurate classification of rice diseases are crucial to minimize these negative impacts. This has driven the development of a Deep Learning model capable of high-performance automatic classification. This study aims to create a rice leaf classification model using the CNN algorithm and several transfer learning architectures such as ResNet101, VGG16, and Xception. A dataset of 859 rice leaf images collected from the Kaggle website was then processed using augmentation techniques to a total of 2,439 images, plus 215 smartphone photos for external data validation. Thus, the total dataset increased to 2,656 images, covering four categories: leafblast, brownspot, healthy, and hispa. The model was processed in two stages: on the initial dataset (Non-Augmented Dataset) and the Augmented Dataset. The best experimental results were obtained using the ResNet architecture, with a training accuracy of 96.17% and a validation accuracy of 95.22%. Based on the research results, the rice plant disease classification model using deep learning demonstrated good performance.
Keywords: convolutional neural network; deep learning; fine-tuning; image classification; resnet; rice plant
Abstract:Abstract: Land registration in Indonesia often encounters challenges in transparency, data integrity, and centralized bureaucracy. Manual and semi-digital systems remain vulnerable to manipulation and delays. The National…
l Land Agency has initiated digitalization, but several challenges remain, particularly in ensuring transparency, efficiency, and security of land ownership data. Blockchain technology offers a potential solution through its decentralized and immutable characteristics. This study adopted a design and development method consisting of system analysis, requirements identification, architecture design, implementation, and black-box testing. The developed decentralized application (DApp) integrates smart contracts, NFTs, and IPFS to manage land certificates. Core functions such as minting, transfer, splitting, and self-custody were implemented and successfully tested, with all scenarios producing expected results. The findings demonstrate that blockchain integration can enhance security, reduce duplication, and streamline land administration. The study contributes a functional prototype with practical implications for modernizing land registration in Indonesia while identifying scalability and regulatory adaptation as areas for further research.
Keywords: blockchain; decentralized application; land registration; NFT; smart contract.
Abstract:Abstract: INET Computer Palembang, as a computer training institution, faces difficulties in understanding participant characteristics due to variations in age, educational background, and chosen course packages. This study…
udy aims to analyze participant criteria and group them based on similarities using the K-Means Clustering algorithm. The data used were historical records of course participants from 2022 to 2025. The research process followed the CRISP-DM stages, starting from data cleaning and transformation, determining the optimal number of clusters using the Elbow Method, to evaluating cluster quality with the Davies-Bouldin Index. The implementation was carried out using Python and the scikit-learn library. The results show that the optimal number of clusters is k=5 with a Sum of Squared Errors (SSE) value of 1064.66 and a Davies-Bouldin Index (DBI) score of 0.820, indicating good cluster quality. The resulting clustering provides a structured profile of participants and demonstrates that K-Means is effective in segmenting course participants. These findings are expected to assist the institution in designing more targeted training programs.
Keywords: clustering; data mining; elbow method; k-means; computer course
Abstract:The development of digital technology encourages universities to improve effectiveness and efficiency in data management, particularly in recording and reporting faculty performance. Some lecturers still face difficulties…
s in reporting their performance in the SISTER application due to challenges in locating documents scattered across various archives, which often leads to issues such as delays in reporting, low information accuracy, and lack of transparency of faculty performance documents for institutional needs. This study aims to optimize the digitalization of faculty performance documents based on cloud computing using the Agile Unified Process (AUP) approach, which is implemented in the development of a cloud-based system by utilizing Google Drive as the storage medium for digital faculty performance documents. The AUP methodology was chosen for its ability to combine flexible iterative and incremental principles, allowing the system to adapt quickly and continuously to user needs. Testing using Equivalence Partitioning, based on the functional and non-functional requirements of the system, has shown results in accordance with expectations.
Abstract:Abstract: The global transition towards sustainable food systems faces significant challenges in vegetarian food supply chains, including transparency issues, distribution inefficiencies, and quality verification problems.…
s. This research proposes VegeChain development, a decentralized marketplace ecosystem based on smart contracts designed to transform vegetarian food supply chains and accelerate Meatless, Balanced, Green (MBG) program adoption. Using mixed-method methodology integrating blockchain system design, stakeholder analysis, and economic simulation, this research develops a comprehensive technology framework combining blockchain transparency, smart contract automation, and sustainable tokenomics with novel mathematical models. The system implements dynamic pricing algorithms based on Automated Market Maker (AMM) mechanisms, multi-objective optimization for supply chain efficiency, and reputation-based consensus protocols. Simulation results demonstrate that VegeChain implementation can improve supply chain efficiency by 35%, reduce food waste by 28%, and increase consumer trust by 42% measured through validated stakeholder satisfaction surveys (n=456) using 5-point Likert scales with statistical significance p<0.001. Technical innovations include Byzantine Fault Tolerant consensus with 99.9% reliability, gas optimization achieving 67% cost reduction, and real-time quality verification algorithms with 98.7% accuracy.
Keywords: smart contracts; supply chain optimization; automated market makers; blockchain technology; sustainable tokenomics
Abstract:Giving awards is essential to motivate students; however, selecting outstanding students at the junior high school level is often conducted manually and subjectively, which can lead to unfairness and prolonged processing…
time. This study develops a Decision Support System (DSS) that integrates the Analytical Hierarchy Process (AHP) and the Technique for Order Preference by Similarity to Ideal Solution (TOPSIS) to support objective and transparent student selection. A quantitative descriptive approach was employed, with data collected through questionnaires, interviews, and documentation at two state junior high schools in Banjarmasin City. Seven assessment criteria were applied: attendance, behavior, uniform neatness, extracurricular participation, academic grades, competition achievements, and disciplinary records. AHP was used to determine the weight of each criterion, while TOPSIS ranked students based on these weights. The web-based system was developed using PHP and MySQL and evaluated using the Technology Acceptance Model (TAM). Results show that academic grades had the highest weight (28.5%), followed by attendance (22.3%) and competition performance (15.2%). The TAM evaluation yielded average scores of 4.32 for Perceived Ease of Use, 4.40 for Perceived Usefulness, 4.15 for Attitudes Towards Use, and 4.28 for Behavioral Intention to Use. The DSS produces accurate rankings, is well-received by users, and offers an efficient, fair, and replicable solution for data-driven educational governance in the digital era.
Abstract:Abstract: Teacher performance appraisal is a very important aspect in improving the quality of education today, but often occurs during the assessment process of subjectivity constraints and lack of a structured system,…
in this study aims to build a data structure modeling and facilitate the school MAS Islamiyah Hessa Air Genting in the assessment to determine the best teacher transparently and measurably by using the Technique for Order Preference by Similarity to Ideal Solution (TOPSIS) algorithm. The TOPSIS method was chosen because it is able to provide ranking results based on the closeness of alternatives to the ideal solution. In this modeling, assessment criteria data such as pedagogical, professional, personality, social competencies, as well as other indicators such as teacher discipline and achievement are modeled structurally in a relational database. The results show that the designed data structure is able to support the decision-making process efficiently and objectively.
Keywords: data structure; decision support system; teacher assessment; topsis; ranking.
Abstrak: Penilaian kinerja guru merupakan aspek yang sangat penting dalam peningkatan mutu pendidikan saat ini, namun sering terjadi saat proses penilaian kendala subjektivitas dan kurangnya sistem yang terstruktur, dalam penelitian ini bertujuan untuk membangun pemodelan struktur data serta mempermudah pihak sekolah MAS Islamiyah Hessa Air Genting dalam penilaian untuk menentukan guru terbaik secara transparan dan terukur dengan menggunakan algoritma Technique for Order Preference by Similarity to Ideal Solution (TOPSIS). Metode TOPSIS dipilih karena mampu memberikan hasil perankingan berdasarkan kedekatan alternatif terhadap solusi ideal. Dalam pemodelan ini, data kriteria penilaian seperti kompetensi pedagogik, profesional, kepribadian, sosial, serta indikator lain seperti kedisiplinan dan prestasi guru dimodelkan secara terstruktur dalam basis data relasional. Hasil penelitian menunjukkan bahwa struktur data yang dirancang mampu mendukung proses pengambilan keputusan secara efisien dan objektif.
Kata kunci: struktur data; topsis; penilaian guru; sistem pendukung keputusan; perangkingan
Abstract:Abstract: The development of information technology encourages businesses to take over digital systems in business operations, even in the sales process. The Point of Sales (POS) system is the leading solution for recording…
ing transactions, managing stock, and creating sales reports efficiently. This study aims to develop a POS application based on a website and make it easier for administrators to manage sales transactions, making them faster and more efficient. This system is made with a structured Agile Development method, requirements, design, development, testing, deployment, and implementation. The framework used is the Laravel framework, with system testing conducted using BlackBox. The test results show that the system is on track and that the efficiency of the transaction and reporting process can be increased. A web-based basis allows users to manage their business more easily in real time because this application is flexible and can be used on various devices.
Keywords: agile model;laravel;point of sales; websites
Abstrak: Pengembangan teknologi informasi mendorong bisnis untuk mengambil alih sistem digital dalam operasi bisnis, bahkan dalam proses penjualan. Sistem Point of Sales (POS) adalah solusi utama untuk merekam transaksi, mengelola stok dan membuat laporan penjualan secara efisien. Tujuan dari penelitian ini adalah untuk mengembangan aplikasi POS berdasarkan situs web dan memudahkan administrator dalam mengelola transaksi penjualan, membuatnya lebih cepat dan lebih efisien. Sistem ini dibuat dengan metode Agile Development yang terstruktur, requirement, design, development, testing, deployment, dan implementation serta kerangka kerja yang digunakan yaitu framework Laravel dengan pengujian sistem menggunakan Blackbox. Hasil pengujian menunjukkan bahwa sistem berada di jalur dan bahwa efisiensi proses transaksi dan pelaporan dapat meningkat. Dengan berbasis web memungkinkan pengguna untuk lebih mudah mengelola bisnisnya secara real time, karena aplikasi ini fleksibel melalui berbagai perangkat.
Kata kunci: model agile;laravel;point of sales;website
Abstract:Abstract: This study aims to develop a Deep Learning-based Traffic Flow Detector to automatically and accurately observe traffic flow. Conventional traffic observation is often conducted manually or via CCTV, but it is prone…
rone to human error and difficult to use for real-time trend analysis. In this study, the YOLOv4 method is used to detect four types of vehicles (cars, motorcycles, buses, trucks). To continuously track vehicle movement and address occlusion issues, the Deep SORT algorithm is implemented. The YOLOv4 model used is a pre-trained model and was tested on seven CCTV video recordings obtained from the official website of the Pekanbaru City Transportation Department. The system was implemented on a limited device, the Nvidia Jetson Nano, as a simulation of direct CCTV integration. Test results showed a highest precision of 98%, but the maximum accuracy achieved was only 26%. This low accuracy is influenced by several factors, including video resolution, detection model quality, and lighting conditions. Nevertheless, the system demonstrates potential to support future traffic management and engineering decisions but still requires further optimization, including improving video resolution and quality, retraining the model with a more representative local dataset, using lighter and more accurate detection models, and optimizing the tracking algorithm.
Keywords: deep learning; deepsort; NVIDIA Jetson NANO; traffic flow; YOLOv4
Abstrak: Penelitian ini bertujuan mengembangkan Traffic Flow Detector berbasis Deep Learning untuk mengobservasi arus lalu lintas secara otomatis dan akurat. Observasi lalu lintas konvensional sering dilakukan secara manual atau melalui CCTV, namun rentan terhadap human error dan sulit digunakan untuk menganalisis tren secara real-time. Pada penelitian ini digunakan metode YOLOv4 untuk mendeteksi empat jenis kendaraan (mobil, motor, bus, truk). Untuk melacak pergerakan kendaraan secara berkelanjutan dan mengatasi masalah occlusion, digunakan algoritma Deep SORT. Model YOLOv4 yang digunakan merupakan pre-trained model dan diujikan pada tujuh rekaman video CCTV yang diambil dari situs resmi Dinas Perhubungan Kota Pekanbaru. Sistem ini diimplementasikan pada perangkat terbatas Nvidia Jetson Nano sebagai simulasi penerapan langsung pada CCTV. Hasil pengujian menunjukkan presisi tertinggi mencapai 98%, namun akurasi tertingginya hanya sebesar 26%. Rendahnya akurasi dipengaruhi oleh beberapa faktor seperti resolusi video, kualitas model deteksi, serta kondisi pencahayaan. Meski demikian, sistem ini menunjukkan potensi untuk membantu pengambilan keputusan dalam manajemen dan rekayasa lalu lintas di masa depan, namun masih membutuhkan optimasi lebih lanjut, seperti peningkatan kualitas video input, pelatihan ulang model dengan dataset lokal, penggunaan model deteksi yang lebih ringan dan akurat serta pengoptimalan algoritma pelacakan.
Kata kunci: deep learning deepsort; Nvidia Jetson Nano; traffic flow; YOLOv4