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

Saved in:
Bibliographic Details
Main Author: Tung, Tean Thong
Format: Final Year Project / Dissertation / Thesis
Published: 2024
Subjects:
Online Access:http://eprints.utar.edu.my/6558/1/20ACB01238_FYP.pdf
http://eprints.utar.edu.my/6558/
Tags: Add Tag
No Tags, Be the first to tag this record!
_version_ 1850177522450300928
author Tung, Tean Thong
author_facet Tung, Tean Thong
author_sort Tung, Tean Thong
building UTAR Library
collection Institutional Repository
content_provider Universiti Tunku Abdul Rahman
content_source UTAR Institutional Repository
continent Asia
country Malaysia
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.
format Final Year Project / Dissertation / Thesis
id my-utar-eprints.6558
institution Universiti Tunku Abdul Rahman
publishDate 2024
record_format eprints
spelling my-utar-eprints.65582025-11-13T12:45:00Z Detection of SQL injection attack using machine learning Tung, Tean Thong T Technology (General) 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/6558/1/20ACB01238_FYP.pdf Tung, Tean Thong (2024) Detection of SQL injection attack using machine learning. Final Year Project, UTAR. http://eprints.utar.edu.my/6558/
spellingShingle T Technology (General)
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)
url http://eprints.utar.edu.my/6558/1/20ACB01238_FYP.pdf
http://eprints.utar.edu.my/6558/
url_provider http://eprints.utar.edu.my