Skip to Main Content
Frequently Asked Questions
Submit an ETD
Global Search Box
Need Help?
Keyword Search
Participating Institutions
Advanced Search
School Logo
Files
File List
Klock_Honors_Thesis-OHIO-ETD.pdf (564.97 KB)
ETD Abstract Container
Abstract Header
Quality of SQL Code Security on StackOverflow and Methods of Prevention
Author Info
Klock, Robert
ORCID® Identifier
http://orcid.org/0000-0001-9153-3715
Permalink:
http://rave.ohiolink.edu/etdc/view?acc_num=oberlin1625831198110328
Abstract Details
Year and Degree
2021, BA, Oberlin College, Computer Science.
Abstract
This paper explores the frequency at which SQL/PHP posts on the website Stackoverflow.com contain code susceptible to SQL Injection, a common database vulnerability. Specifically, we analyze whether other users give notice of the vulnerability or provide an answer that is secure. The majority of questions analyzed were vulnerable to SQL Injection and were not corrected in their answers or brought to the attention of the original poster. To mitigate this, we present a machine learning bot which analyzes the poster’s code and alerts them of potential injection vulnerabilities, if necessary.
Committee
Cynthia Bagier Taylor (Advisor)
Pages
9 p.
Subject Headings
Computer Science
Keywords
StackOverflow
;
SQL Injection
;
Security
;
Text mining
;
Machine learning
Recommended Citations
Refworks
EndNote
RIS
Mendeley
Citations
Klock, R. (2021).
Quality of SQL Code Security on StackOverflow and Methods of Prevention
[Undergraduate thesis, Oberlin College]. OhioLINK Electronic Theses and Dissertations Center. http://rave.ohiolink.edu/etdc/view?acc_num=oberlin1625831198110328
APA Style (7th edition)
Klock, Robert.
Quality of SQL Code Security on StackOverflow and Methods of Prevention.
2021. Oberlin College, Undergraduate thesis.
OhioLINK Electronic Theses and Dissertations Center
, http://rave.ohiolink.edu/etdc/view?acc_num=oberlin1625831198110328.
MLA Style (8th edition)
Klock, Robert. "Quality of SQL Code Security on StackOverflow and Methods of Prevention." Undergraduate thesis, Oberlin College, 2021. http://rave.ohiolink.edu/etdc/view?acc_num=oberlin1625831198110328
Chicago Manual of Style (17th edition)
Abstract Footer
Document number:
oberlin1625831198110328
Download Count:
329
Copyright Info
© 2021, some rights reserved.
Quality of SQL Code Security on StackOverflow and Methods of Prevention by Robert Klock is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. Based on a work at etd.ohiolink.edu.
This open access ETD is published by Oberlin College Honors Theses and OhioLINK.