Skip to the main content

Preliminary communication

https://doi.org/10.31803/tg-20210205101347

Ensemble Machine Learning Approaches for Detection of SQL Injection Attack

Umar Farooq orcid id orcid.org/0000-0002-3786-2574 ; Department of Computer Science & Technology (Cyber Security), Central University of Punjab, City Campus, Mansa Road, Bathinda 151001, Punjab, India


Full text: english pdf 1.825 Kb

page 112-120

downloads: 1.959

cite


Abstract

In the current era, SQL Injection Attack is a serious threat to the security of the ongoing cyber world particularly for many web applications that reside over the internet. Many webpages accept the sensitive information (e.g. username, passwords, bank details, etc.) from the users and store this information in the database that also resides over the internet. Despite the fact that this online database has much importance for remotely accessing the information by various business purposes but attackers can gain unrestricted access to these online databases or bypass authentication procedures with the help of SQL Injection Attack. This attack results in great damage and variation to database and has been ranked as the topmost security risk by OWASP TOP 10. Considering the trouble of distinguishing unknown attacks by the current principle coordinating technique, a strategy for SQL injection detection dependent on Machine Learning is proposed. Our motive is to detect this attack by splitting the queries into their corresponding tokens with the help of tokenization and then applying our algorithms over the tokenized dataset. We used four Ensemble Machine Learning algorithms: Gradient Boosting Machine (GBM), Adaptive Boosting (AdaBoost), Extended Gradient Boosting Machine (XGBM), and Light Gradient Boosting Machine (LGBM). The results yielded by our models are near to perfection with error rate being almost negligible. The best results are yielded by LGBM with an accuracy of 0.993371, and precision, recall, f1 as 0.993373, 0.993371, and 0.993370, respectively. The LGBM also yielded less error rate with False Positive Rate (FPR) and Root Mean Squared Error (RMSE) to be 0.120761 and 0.007, respectively. The worst results are yielded by AdaBoost with an accuracy of 0.991098, and precision, recall, f1 as 0.990733, 0.989175, and 0.989942, respectively. The AdaBoost also yielded high False Positive Rate (FPR) to be 0.009.

Keywords

Boosting; ensemble learning; Light GBM; SQL injection; web security

Hrčak ID:

253030

URI

https://hrcak.srce.hr/253030

Publication date:

3.3.2021.

Visits: 4.311 *