MySQL Database Research Articles

A Cutting-Edge Approach to Predictive Precision in Oncology Using a Geneto-Neuro-Fuzzy Hybrid Model

Purpose: This study introduces a pioneering hybrid model that combines genetic algorithms, neuro-fuzzy logic, and mobile agent technology to enhance predictive precision for early-stage prostate cancer diagnosis. Design/Methodology/Approach: One hundred and twenty records of prostate cancer patients were initially collected from the Delta State University Teaching Hospital, Oghara, Nigeria. Each patient’s record included relevant data on prostate disease, such as age, PSA levels, clinical history, symptom severity, biopsy results, and other demographic and clinical factors. This data was extracted and stored as rules in a MySQL database, with the MySQL Fuzzy Extension enabling fuzzy data storage and processing. Findings: Extensive simulations and clinical data analyses demonstrate the model’s superior sensitivity and specificity in detecting early-stage prostate cancer compared to traditional diagnostic methods. Medical expert evaluations validate the model’s effectiveness as a promising diagnostic alternative. Research Limitation: While results are promising, the study is limited to simulations and a controlled clinical dataset. Practical Implications: The system offers a practical, scalable early prostate cancer detection solution that could revolutionise current diagnostic practices. Social Implications: Potential social benefits include improved patient outcomes, reduced healthcare costs, and better quality of life. Originality/Value: This study presents an innovative integration of genetic algorithms, neuro-fuzzy systems, and mobile agent technology. This novel approach paves the way for advanced cancer diagnostics and precision medicine.

Design and construction of a website-based librarian application system in Bali

This study focuses on the development of a web-based application system related to the functional positions of librarians in Bali. This web-based application is designed as a one-stop service to provide essential functional position information for librarians. The primary research question asked is how to design and construct a web-based librarian application system in Bali. The objective of this study is to design, develop, and evaluate a system that supports librarians in managing their activities and credit scores. The development method used is the linear sequential (waterfall) method, which includes the stages of analysis, design, coding, implementation, testing, and maintenance. This system features a user interface with functions such as Home, Activity Details, Forms, and a List of Librarians, enabling librarians to manage various activities organized into categories of Expert Librarians and Skilled Librarians. Each activity comprises a menu for librarian type, education, library management, services, librarian system development, professional development, and task support, which are further broken down into sub-activities according to their categories. Application testing was carried out using the Black Box Testing method to ensure that all functions operated according to user needs. This system was implemented as a web-based application using PHP and MySQL databases, allowing librarians to access it online. The implementation results show that this application has run well and is able to meet the needs of librarians in managing their functional positions efficiently, simplifying the credit score submission process, and enhancing accuracy and efficiency in reporting.

GenSQLi: A Generative Artificial Intelligence Framework for Automatically Securing Web Application Firewalls Against Structured Query Language Injection Attacks

The widespread adoption of web services has heightened exposure to cybersecurity threats, particularly SQL injection (SQLi) attacks that target the database layers of web applications. Traditional Web Application Firewalls (WAFs) often fail to keep pace with evolving attack techniques, necessitating adaptive defense mechanisms. This paper introduces a novel generative AI framework designed to enhance SQLi mitigation by leveraging Large Language Models (LLMs). The framework achieves two primary objectives: (1) generating diverse and validated SQLi payloads using in-context learning, thereby minimizing hallucinations, and (2) automating defense mechanisms by testing these payloads against a vulnerable web application secured by a WAF, classifying bypassing attacks, and constructing effective WAF security rules through generative AI techniques. Experimental results using the GPT-4o LLM demonstrate the framework’s efficacy: 514 new SQLi payloads were generated, 92.5% of which were validated against a MySQL database and 89% of which successfully bypassed the ModSecurity WAF equipped with the latest OWASP Core Rule Set. By applying our automated rule-generation methodology, 99% of previously successful attacks were effectively blocked with only 23 new security rules. In contrast, Google Gemini-Pro achieved a lower bypass rate of 56.6%, underscoring performance variability across LLMs. Future work could extend the proposed framework to autonomously defend against other web attacks, including Cross-Site Scripting (XSS), session hijacking, and specific Distributed Denial-of-Service (DDoS) attacks.

A Multi-Functional Web Control Interface for Industrial Autonomous Mobile Robot Fleets

This study presents a multifunctional web-based interface developed to facilitate the control and management of autonomous mobile robot fleets in industrial automation. The system enables users to monitor the status of robots in real time, perform mapping, define restricted areas, plan virtual paths, and issue task commands. The developed interface communicates seamlessly with the ROS operating system and is built on a robust backend utilizing a MySQL database, offering a strong technical foundation. With its multi-user management feature, the system allows users to operate efficiently through role-based authorizations. The interface provides a user-friendly experience, ensuring low error rates, rapid decision-making, and high efficiency. Tests have demonstrated that the system delivers consistent performance in multi-robot scenarios and exhibits resilience against network connectivity issues. This study offers an innovative solution for the management of industrial mobile robots, contributing to digital transformation processes.

Penerapan Metode Waterfall Untuk Perancangan Sistem Inventory Pada PT.Raih Usaha Karya Mandiri

The inventory system is a crucial component for companies to facilitate the process of recording goods and generating reports in a structured, controlled, systematic, and interconnected manner. At PT Raih Usaha Karya Mandiri, the recording of goods entering and exiting the warehouse is still done manually, using a logbook form. This often leads to recording errors and data mix-ups, hindering access to information when needed. To address this issue, a web-based inventory system was developed using the waterfall system development method, which operates sequentially. The system was designed using a MySQL database and PHP programming language. The implementation results indicate that the developed inventory system simplifies the recording of goods movement, enhances stock data accuracy, and accelerates the process of creating inventory reports, there by supporting the work efficiency of PT Raih Usaha Karya Mandiri employees.

Sistem Kunci Elektronik Pintu Kos Menggunakan IoT Berbasis E-KTP

The increasing demand for boarding houses in urban areas presents challenges for owners, including ensuring security, managing access, and enforcing tenant compliance with rental agreements. This research introduces an IoT-based electronic door lock system utilizing e-KTP for boarding houses to address these challenges. The system facilitates efficient and secure room access management through integration with a web server for real-time monitoring and notifications. It employs an RFID reader to authenticate e-KTP cards, with the data processed by a NodeMCU microcontroller to control a solenoid lock. For emergency situations, a pushbutton is installed to allow access from inside the room. The system records all access events and sends notifications to users, including reminders for payment deadlines and rental expiration. All data is stored in a MySQL database and accessed through a user-friendly web interface designed for tenants and landlords. Testing demonstrates the system's reliability in granting authorized access and blocking unauthorized attempts. The push button ensures secure internal use. The integration of IoT technology enhances security, convenience, and administrative efficiency in managing rental housing.

Design of a Desktop Java-Based Introduction to Basic Electronic Components

The development of information technology has had a positive impact on the world of education, one of which is to simplify the learning process. In the field of electronics, understanding basic components is an important foundation for students and practitioners. This Java Desktop-based application design aims to introduce basic electronic components with an easy-to-understand interactive interface. In this software, it contains various information about basic electronic components such as Resistors, Capacitors, Transistors, Diodes, Push Buttons, which is equipped with detailed information about the specifications and basic functions of various electronic components. In addition, the app comes with visual illustrations in the form of images that support the understanding of physical and component symbols. To explain how components in a series work, the app presents interactive animations to clarify the concept of how each component works and functions. During the creation and testing of 5 times, which was carried out using 5 different basic components resulting in different circuits and explanations of how to work, these results then obtained data from these 5 components which were then entered into the MySQL Database. The data present in the Driver Database is displayed using the Desktop-Based Java Programming Language.

Account Login and Database Access Control System with Time Attendance Through Facial Recognition

The traditional method of recording attendance faces challenges, such as errors, lack of accuracy, and time consumption, leading to low efficiency and obsolescence. To address these issues, this study proposes the development of an automated attendance system that uses real-time face detection technology. The goal is to enhance efficiency, accuracy, and security by incorporating automated facial detection for attendance tracking. The attendance system is based on Haar Cascades face detection classifier technology for facial recognition. Attendance data is stored in a MySQL database that is managed through SQL programming. By detecting faces and updating attendance records in a timely manner, users can also access their pages. Face detection entails recognizing faces through real-time monitoring. When a face is detected, users are prompted to enter their names to register attendance as the system updates the MySQL database. Accuracy tests conducted under different conditions showed an accuracy rate of up to 97.44%. Attendance details are stored in a database containing the names of attendees, along with date and time stamps of their attendance. For improvement, it is proposed in the future to include security measures such as anti-impersonation and mask detection techniques along with incorporating deep learning principles. This will help enhance the security and effectiveness of the systems in situations.

PENERAPAN APLIKASI PERJALANAN DINAS DI KANTOR SEKRETARIAT DAERAH (SETDA) KOTA SERANG

This study aims to design and develop a business trip application at the Regional Secretariat of Serang City to facilitate the management of official travel processes. The application is designed to support the digitalization of administrative procedures, from travel requests, budget management, to trip reporting. The system development uses the Agile methodology, enabling rapid iteration based on user feedback. This web-based system is built using PHP programming language and MySQL database. The application is expected to improve efficiency, accuracy, and transparency in official travel management and minimize potential manual errors.

Design of Cashier Information System and Sales of Jaya Putra 04 Store Based on Website Using Waterfall Method

In the digital era, the need for effective and efficient information systems has become increasingly important to support business operations. This study aims to design and develop a web-based cashier information system for Toko Jaya Putra 04 using the Waterfall method. The system is designed to address challenges in manual transactions, such as long queues, recording errors, and lack of stock visibility. The research stages include requirements analysis, system design using Unified Modeling Language (UML), implementation with PHP programming language and MySQL database, testing using the Black Box Testing method, and system maintenance. The results show that this cashier information system can improve transaction process efficiency, reduce customer waiting times, and simplify stock management and financial reporting. This system is expected to be further developed with additional features, such as digital payment integration, customer loyalty programs, and enhanced data security. By implementing this system, Toko Jaya Putra 04 can enhance service quality and support more strategic business decision-making.

Sistem Informasi Manajemen Aset PT. Citra Putra Kebun Asri Jorong Estate Berbasis Web

Assets generally state that assets are resources controlled by the company as a result of past events where future economic benefits are expected to be obtained by the company. Company assets originate from transactions or other events that occurred in the past. Companies usually acquire assets through outlays in the form of purchases or self-production. The Head of Administration independently handles asset data collection and is still done manually using Microsoft Excel. Recording of asset items based on space, fields and conditions is not yet in the application, so the admin does not know the exact number of indoor asset items, fields and does not know the condition of asset items, if re-data of indoor asset items, fields and conditions takes a long time, it is necessary development of applications for recording indoor assets, fields and conditions of asset items. This condition can also lead to the possibility of data collection errors and also the length of time in searching for data if needed at any time. Asset Management Information System PT. Citra Putra Kebun Asri Jorong Estate Web-based using MySQL database. The designs used are Entity Relationship Diagrams (ERD), Data Flow Diagrams (DFD), and Flowcharts. The programming language used is Hypertext Preprocessor (PHP). The system development model used is the waterfall model. The functionality test used is Blackbox testing.

The Design of a Good Data Processing App Applying QR Code

Designing a good data processing application using QR Codes aims to increase efficiency and accuracy in data management. QR codes are a fast and easy technology for storing and scanning data, allowing users to quickly access information without entering data manually. This application is designed for various purposes, such as inventory, time and attendance management, and document tracking. The application design process includes user needs analysis, interface design, back-end development, and integration with QR code technology. The prototype method is used during the system development stage. The programming language used is a hypertext preprocessor with a MySQL database, and a framework is used to ensure that the application behaves as expected and can provide effective solutions in data processing. The results of this design are expected to significantly contribute to operational efficiency, reduce human error in data entry, and increase the speed of accessing and managing information. Apart from that, implementing QR codes in data processing applications is hoped to be widely used in various industries and business fields.

Designing information system for sea transportation website in South Bangka Regency to support smart city

Abstract South Bangka is city that located in Province of Bangka Belitung Islands which using ship for support transportation because have a lot of island. The various ship is using because South Bangka have a lot of islands from small until a big island. South Bangka is experiencing difficulties in managing existing sea transportation due to the large number of ships operating without being recorded by the South Bangka transportation service. Therefore, an information system is needed that is able to manage data and information related to sea transportation in South Bangka. This ship transportation system is using the programming PhP and MySQL for the ship database used. This information system is designed to support smart city features for South Bangka Regency, because the management of sea transportation for the islands of South Bangka is centralized, digital also electronic. This information system also accessed easily by the public using smartphones and the internet to give easiness for information about ship transportation.

Real-Time Load Monitoring System for Tuna Fishing Ships: A Solution to Combat Illegal Transshipment

Abstract Illegal fishing activities are the biggest challenge for Indonesia in protecting its territorial waters from illegal fish transhipment. To address this issue, a real-time load measurement system is needed on ships. Real-time measurement devices can also replace land-based measurement functions, thus improving the quality of catch during the transfer of tuna from the ship to the cold storage. The method used in this research is testing, which requires real data to support and simulate the implementation of the study. The research involves a prototype that utilizes a load cell as a sensor for detecting the mass of fish, and NodeMCU as a microcontroller programmed with Arduino IDE language. The prototype is integrated with Wi-Fi to send data to a MySQL database. The sensor circuit consists of four load cells, a junction box, and an HX711 amplifier. The results of the sensor experiment at a 12-degree tilt condition, which indicates the roll or trim condition of the ship, show a decrease in sensor accuracy and relatively unstable results compared to normal conditions. The average accuracy rate of sensor readings under normal conditions is 99.42%, while the average accuracy rate of sensor readings at a 12-degree tilt is 96.98%.

Perancangan Sistem Pendaftaran Keanggotaan Unit Kegiatan Mahasiswa (UKM) di UIN SMDD Bukittinggi Berbasis Web

The registration system for prospective members of the Student Activity Unit (UKM) makes the registration process which is often held every period of time more effective and provides facilities to students who want to register themselves into the Student Activity Unit (UKM) organization that they are interested in in terms of completeness of information and coverage of information dissemination announcements when Open Recruitment is held in each UKM. With this website application also helps many organizations save their energy from material and also their time in designing an Open Recruitment that is designed using the PHP programming language and MySQL database. The purpose of this research is to design a registration system for prospective new members of the Student Activity Unit (UKM) around the campus of the State Islamic University Sjech M. Djamil Djambek Bukittinggi, so that students who want to register themselves into an organization on campus, namely UKM, can get all the information they need starting from registration information, schedule announcements, requirements, and much more in the hope of connecting the many UKM with students on campus.

Perancaangan Sistem Informasi Apotik Berbasis Web: Optimalisasi Layanan Pelanggan

This research discusses the development and implementation of a "Web-Based Pharmacy Information System" which aims to improve the efficiency of customer service and drug inventory management. By using web technology, PHP programming language, and MySQL database, this system allows pharmacies to monitor drug stocks in real-time, manage patient information, and provide integrated services. The use of PHP and MySQL in developing this application allows the automation of administrative tasks, including drug stock tracking, orders, and patient data management. This system also facilitates customer service with easy access to drug information and online drug ordering services. The research results show that the implementation of the Web-Based Pharmacy Information System has succeeded in increasing pharmacy efficiency, reducing drug stock shortages, and improving customer service. This system supports integrated drug management by integrating patient data, drug stock and customer service in one platform. Overall, this system illustrates how the use of web, PHP, and MySQL technologies can optimize customer service and medication inventory management in the pharmacy context, providing major benefits to pharmacies and patients.

Implementation Of Weighted Aggregated Sum Product Assessment (Waspas) Method In Determining English Language Learning Levels At Vanka Speaking Course Sumbawa

English is an international language that plays a crucial role in global communication. English is very influential in aspects of life, ranging from the work sector to the education sector. Vanka Speaking Course Sumbawa is one of the course institutions in Sumbawa Regency that accepts participants from various levels, namely elementary to junior high school, with multiple levels and six levels of learning. Currently, Vanka Speaking Course Sumbawa has seven tutors with 142 students divided into 13 regular classes (117 people) and 12 private classes (25 people). In a language course like this, determining the student's learning level is a critical initial stage. This allows teachers to design learning programs with suitable modules and materials to meet the needs of each student. The course party still needs help determining the initial stage and learning level that suits the student's abilities. This study aims to apply the Weighted Aggregated Sum Product Assessment (WASPAS) Method in determining the level of English learning by selecting alternatives based on specific criteria. The development method designs the system using Rapid Application Development (RAD), PHP programming language, Laravel framework, MySQL database, and Unified Modeling Language (UML). After being built and tested using black box testing, this application can be run properly and help Vanka Speaking Course Sumbawa make decisions related to determining the level of English learning. The results of this study can improve the accuracy of assessment in determining the level of English learning in students and ultimately further improve the quality of learning at the Vanka Speaking Course.

Decision Support System For Determining Prospective Students' Department At Vocational School 1 Buer Using Simple Additive Weighting

Choosing a major is essential for students, especially junior high school students, who must choose the appropriate field. Vocational High School (SMK) is a formal education unit that organizes vocational education at the secondary education level as a continuation of junior high school. At SMK Negeri 1 Buer, the central determination system is carried out with a ranking system where the ranking system is carried out based on the order in which prospective students register for the primary major so that it cannot be determined according to the interests and talents of the students. The purpose of this major is so that students can be directed to receive lessons based on their abilities and skills. SMK Negeri 1 Buer has eight majors: Building Modeling and Information Design, Motorcycle Engineering and Business, Visual Communication Design, Light Vehicle Engineering, Welding Engineering, Industrial Electronics Engineering, Animation, and Graphic Engineering. Therefore, this decision support system can make it easier for schools to determine majors according to students' interests and talents. This study uses the Extreme Programming method as a system development method and Simple Additive Weighting for calculating the Decision Support System, using PHP as a programming language with the Codeigniter framework and MySQL database. With this SPK, SMKN 1 Buer can distribute students according to their interests and make it easier for students to choose majors according to their interests

QueryAI: A Conversational Interface for SQL Database Querying Using Natural Language Processing

QueryAI is an interface leveraging natural language for SQL database querying. By incorporating large language models (LLMs) and natural language processing (NLP) techniques, QueryAI enables users to query a MySQL database using English-based commands. This interface translates user inputs into SQL statements and presents the outcomes, offering access to those without SQL proficiency. This paper explores QueryAI's design, implementation, and potential applications in data analysis and business intelligence.

Design and Development of a Web-Based Correspondence Management Information System at Politeknik Negeri Tanah Laut

Correspondence at Politeknik Negeri Tanah Laut (Politala) is currently still done manually in the vertical delivery process between work units. This manual process results in inefficiency, especially in monitoring the status of documents such as Staff Review Documents. Staff Review is a document that must be made by the department to the director as a basis for requesting assignment letters, decrees, recommendation letters and the others. These documents often require repeated checking, causing delays in the workflow. In addition, paper-based correspondence archives increase the risk of losing documents and make it difficult to find them again. Therefore, the implementation of the Correspondence Management Information System (SiMantan) is needed to improve the efficiency of the correspondence administration process by providing electronic document management and real-time status monitoring. This information system is built using the waterfall development model and designed with the Unified Modeling Language (UML) in the form of Usecase Diagrams. While the programming language used is the PHP programming language with the Code Ignitor 3 framework and MySQL database. Functional testing of the system is carried out using the black box testing and user acceptance testing (UAT) method which shows that all features in the information system function properly according to the expected specifications.