Putu Sugiartawan

Nowadays, closed-circuit television (CCTV) cameras are deployed worldwide to monitor movements of humans and other objects to improve the efficiency and safety of societies. Therefore, their proper placement is crucial for achieving effective surveillance coverage. Additionally, their proper placement is significantly important for maximizing visual coverage while reducing installation/management costs. For this task, digital twin is a useful technology, since it can simulate coverage and blind spots while freely changing camera locations. To implement digital twin, 3D modelling of a structure including a complex room is a key issue. In this paper, we propose a 3D indoor modelling method using 360° panoramic images and show its application to a CCTV camera placement optimization. This method constructs a structured 3D model of a target room from captured 360° panoramic images using a 3D Gaussian Splatting reconstruction method based on a visual simultaneous localization and mapping (VSLAM) framework. The Inertial Measurement Unit (IMU) is used together to improve the camera position estimation accuracy. The model construction is anchored using a GNSS/GPS reference to establish global spatial coordinates. As an application of the generated 3D model, optimal locations of a given number of CCTV cameras are determined by combining ray-casting visibility analysis and a greedy optimization algorithm in the virtual environment, maximizing visual coverage while minimizing blind spots and avoiding excessive overlap between camera views. For evaluations, we applied the proposed method to three rooms in Okayama University, Japan, and seven rooms in the Indonesian Institute of Business and Technology, Indonesia. After optimizing camera locations in the virtual environment, the cameras were actually installed in the rooms according to the recommended positions. The performance was evaluated using visibility coverage, blind spot reduction, and Root Mean Squared Error (RMSE) between the estimated and actual camera positions, where promising results were achieved.

Today, relational databases are widely used in information systems. SQL (structured query language) is taught extensively in universities and professional schools across the globe as a programming language for its data management and accesses. Previously, we have studied a web-based programming learning assistant system (PLAS) to help novice students learn popular programming languages by themselves through solving various types of exercises. For SQL programming, we have implemented the grammar-concept understanding problem (GUP) and the comment insertion problem (CIP) for its initial studies. In this paper, we propose an SQL Query Description Problem (SDP) as a new exercise type for describing the SQL query to a specified request in a MySQL database system. To reduce teachers’ preparation workloads, we integrate a generative AI-assisted SQL query generator to automatically generate a new SDP instance with a given dataset. An SDP instance consists of a table, a set of questions and corresponding queries. Answer correctness is determined by enhanced string matching against an answer module that includes multiple semantically equivalent canonical queries. For evaluation, we generated 11 SDP instances on basic topics using the generator, where we found that Gemini 3.0 Pro exhibited higher pedagogical consistency compared to ChatGPT-5.0, achieving perfect scores in Sensibleness, Topicality, and Readiness metrics. Then, we assigned the generated instances to 32 undergraduate students at the Indonesian Institute of Business and Technology (INSTIKI). The results showed an average correct answer rate of 95.2% and a mean SUS score of 78, which demonstrates strong initial student performance and system acceptance.

Nowadays, dried Moringa leaves (M. oleifera) are increasingly in demand due to their health benefits. High-quality ones have shown remarkable positive effects as antioxidants, antidiabetics, and anti-inflammatory agents. However, in the industry, the quality classification process into six categories is performed manually by farmers, which is time-consuming and error-prone. Particularly, the two highest categories of Class A and Class B are hard to distinguish, since they are visually similar. In this paper, to automate the classification process, we introduce a new high-resolution dataset, extract color and texture features using the Gray-Level Co-occurrence Matrix (GLCM) method, and present a two-stage classification method using the Light Gradient Boosting Machine (LightGBM) algorithm with them. The experimental results show that the proposal improved classification accuracy from 82% by the baseline algorithm to 90% while maintaining high processing efficiency, demonstrating its potential for real-time and scalable industrial applications in dried Moringa leaves quality grading.

Purpose: The use of the concept of knowledge management can manage the knowledge of the teacher or lecturer and then it can be conveyed to the studentsDesign/methodology/approach: Knowledge Management SystemFindings/result: The application of the Knowledge Management System at the INSTIKI LMS was able to increase student learning satisfaction. The results of the questionnaire assessment show that student learning satisfaction increases after implementing INSTIKI e-learning, the average value of studentOriginality/value/state of the art: Implementation of Knowledge Management System on INSTIKI campus

The increasing development of information technology, brings developments to the pattern of life of the Indonesian people, especially the pattern of consumption and shipping of goods. Indonesian society is greatly facilitated and spoiled in getting the desired goods and services. This development was caused by the spread of online shopping providers in Indonesia, which can be accessed via smartphones and computers. Indonesia has a very high number of smartphone users, judging from the number of unique audiences at the end of the second quarter, the data obtained from MMX Multi-platform, June 2017. One of the models used in this study is the Profile Matching method, the method can overcome problems ranking by giving weights based on matching two profiles examined on the criteria of each cell phone. The criteria obtained by the user will be the profile value which is then matched with the conformity profile provided by DM. This study uses three decision makers, including economists, IT experts, and the public. To combine the three decisions used the BORDA method approach. The BORDA method is a voting method that can resolve group decision making, wherein its application each decision maker (DM) provides a rating based on the alternative choices available. Furthermore, this research will use the approach of profile matching and BORDA methods in choosing the best marketplace. The results showed that Sophie's marketplace was ranked first.