Back to results

Iowa State University

Detecting SQLIA using execution plans

Abstract

dc:description.abstract

<p>SQLIA, SQL Injection Attacks are one of the most common threats for web applications. In these types of attacks, the attacker alters the queries to the database via specially crafted input strings, resulting in illegal access to the database. In our paper we present a new approach to detect SQL injection attacks by using the Execution Plans in MS SQL Server. An Execution plan, generated by the query optimizer, explains how queries are executed in the database server. The database administrators extensively use execution plans to optimize SQL queries. In our approach we use execution plan to detect SQL injection attacks by observing the changes in the structure of query executed in the database. Two execution plans are generated for the same query, one during the development phase i.e. from the query written by the developer and another during the run time i.e. when the user executes the query written by the developer. These two execution plans are compared to detect SQLIA. In this paper we show how our approach detects various types of SQLIA and compare our approach with other tools that has been successful in identifying SQLIA. We also show how our approach can be extended to other databases like MYSQL, Oracle etc. and propose a futuristic model, which detects SQLIA in all relational databases.</p>

Degree

thesis:*
Name thesis:degree_name
Master of Science
Level thesis:degree_level
thesis
Discipline thesis:degree_discipline
Computer Engineering
Department dc:contributor.department
Department of Computer Science
Year dc:date.issued
2016

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Nagarajan, Sriram
Advisors dc:contributor.advisor
  • Johnny S. Wong
  • Samik Basu

Rights

Language dc:language.iso
en

Identifiers

dc:identifier.*
Identifier
archive/lib.dr.iastate.edu/etd/15098/
Dc Identifier Other
6105
8882696
Mods Identifier Filename
archive/lib.dr.iastate.edu/etd/15098/Nagarajan_iastate_0097M_15566.pdf|||Fri Jan 14 20:35:37 UTC 2022

Chain of custody

source
Harvested from
Iowa State University
Base URL
dr.lib.iastate.edu/server/oai/request
Last updated
2026-11-18
Source record
OAI-PMH GetRecord
related terms
citation

Nagarajan, Sriram. Detecting SQLIA using execution plans. thesis thesis, 2016. https://dr.lib.iastate.edu/handle/20.500.12876/29282