Detection of SQL injection attack using machine learning

The rapid proliferation of online services has led to a significant increase in the utilisation of the internet. User data is considered the most precious asset of the firm; nonetheless, databases are susceptible to many assaults and dangers. SQL injection (SQLI) refers to a specific type of securit...

Full description

Bibliographic Details
Main Author: Tung, Tean Thong
Format: Final Year Project / Dissertation / Thesis
Published: 2024
Subjects:
Online Access:http://eprints.utar.edu.my/6685/
http://eprints.utar.edu.my/6685/1/fyp_CS_2024_TTT.pdf
_version_ 1848886745557368832
author Tung, Tean Thong
author_facet Tung, Tean Thong
author_sort Tung, Tean Thong
building UTAR Institutional Repository
collection Online Access
description The rapid proliferation of online services has led to a significant increase in the utilisation of the internet. User data is considered the most precious asset of the firm; nonetheless, databases are susceptible to many assaults and dangers. SQL injection (SQLI) refers to a specific type of security vulnerability that occurs when unauthorised SQL code is inserted into web applications to compromise databases, leading to potential consequences such as data breaches, server disruptions, and data loss within an organisational context. Based on the literature review findings, it has been observed that conventional techniques employed for detecting SQLI attacks often exhibit limitations in their effectiveness and suffer from various drawbacks. This work presents a novel real-time system for detecting SQLI attacks. The system utilises a machine learning approach to train and enhance its ability to identify and prevent SQLI attacks accurately. The machine learning algorithms employed in this study encompass Convolutional Neural Networks (CNN), Logistic Regression, Naïve Bayes Classifier, Support Vector Machine, and Random Forest. The system covers multiple stages: project pre-development, data pre-processing, feature selection, machine learning model selection, model training, model testing, implementation, and assessment. Integrating this system into the backend of the web application server would augment the safety and security measures of the online application. The system will undergo real-time monitoring through periodic analysis of website traffic statistics. Upon detection of a SQLI attack, the system will generate and transmit a comprehensive report to promptly warn the network administrator of the occurrence of the attack. This notification enables the administrator to undertake the necessary measures to address the vulnerability by applying appropriate patches to the web application.
first_indexed 2025-11-15T19:43:23Z
format Final Year Project / Dissertation / Thesis
id utar-6685
institution Universiti Tunku Abdul Rahman
institution_category Local University
last_indexed 2025-11-15T19:43:23Z
publishDate 2024
recordtype eprints
repository_type Digital Repository
spelling utar-66852024-10-23T06:47:08Z Detection of SQL injection attack using machine learning Tung, Tean Thong T Technology (General) TD Environmental technology. Sanitary engineering The rapid proliferation of online services has led to a significant increase in the utilisation of the internet. User data is considered the most precious asset of the firm; nonetheless, databases are susceptible to many assaults and dangers. SQL injection (SQLI) refers to a specific type of security vulnerability that occurs when unauthorised SQL code is inserted into web applications to compromise databases, leading to potential consequences such as data breaches, server disruptions, and data loss within an organisational context. Based on the literature review findings, it has been observed that conventional techniques employed for detecting SQLI attacks often exhibit limitations in their effectiveness and suffer from various drawbacks. This work presents a novel real-time system for detecting SQLI attacks. The system utilises a machine learning approach to train and enhance its ability to identify and prevent SQLI attacks accurately. The machine learning algorithms employed in this study encompass Convolutional Neural Networks (CNN), Logistic Regression, Naïve Bayes Classifier, Support Vector Machine, and Random Forest. The system covers multiple stages: project pre-development, data pre-processing, feature selection, machine learning model selection, model training, model testing, implementation, and assessment. Integrating this system into the backend of the web application server would augment the safety and security measures of the online application. The system will undergo real-time monitoring through periodic analysis of website traffic statistics. Upon detection of a SQLI attack, the system will generate and transmit a comprehensive report to promptly warn the network administrator of the occurrence of the attack. This notification enables the administrator to undertake the necessary measures to address the vulnerability by applying appropriate patches to the web application. 2024-01 Final Year Project / Dissertation / Thesis NonPeerReviewed application/pdf http://eprints.utar.edu.my/6685/1/fyp_CS_2024_TTT.pdf Tung, Tean Thong (2024) Detection of SQL injection attack using machine learning. Final Year Project, UTAR. http://eprints.utar.edu.my/6685/
spellingShingle T Technology (General)
TD Environmental technology. Sanitary engineering
Tung, Tean Thong
Detection of SQL injection attack using machine learning
title Detection of SQL injection attack using machine learning
title_full Detection of SQL injection attack using machine learning
title_fullStr Detection of SQL injection attack using machine learning
title_full_unstemmed Detection of SQL injection attack using machine learning
title_short Detection of SQL injection attack using machine learning
title_sort detection of sql injection attack using machine learning
topic T Technology (General)
TD Environmental technology. Sanitary engineering
url http://eprints.utar.edu.my/6685/
http://eprints.utar.edu.my/6685/1/fyp_CS_2024_TTT.pdf