Journal of the Institute of Electronics and Information Engineers (전자공학회논문지)

The Institute of Electronics and Information Engineers (대한전자공학회)
권호 표지
DOI QR코드

DOI QR Code

Counter Measures by using Execution Plan Analysis against SQL Injection Attacks

실행계획 분석을 이용한 SQL Injection 공격 대응방안

  • 하만석 (국민대학교 비즈니스IT전문대학원) ;
  • 남궁정일 (국민대학교 비즈니스IT전문대학원) ;
  • 박수현 (국민대학교 비즈니스IT전문대학원)
  • Received : 2015.12.22
  • Accepted : 2016.01.22
  • Published : 2016.02.25
Download PDF
⟨ Previous Next ⟩

Abstract

SQL Injection attacks are the most widely used and also they are considered one of the oldest traditional hacking techniques. SQL Injection attacks are getting quite complicated and they perform a high portion among web hacking. The big data environments in the future will be widely used resulting in many devices and sensors will be connected to the internet and the amount of data that flows among devices will be highly increased. The scale of damage caused by SQL Injection attacks would be even greater in the future. Besides, creating security solutions against SQL Injection attacks are high costs and time-consuming. In order to prevent SQL Injection attacks, we have to operate quickly and accurately according to this data analysis techniques. We utilized data analytics and machine learning techniques to defend against SQL Injection attacks and analyzed the execution plan of the SQL command input if there are abnormal patterns through checking the web log files. Herein, we propose a way to distinguish between normal and abnormal SQL commands. We have analyzed the value entered by the user in real time using the automated SQL Injection attacks tools. We have proved that it is possible to ensure an effective defense through analyzing the execution plan of the SQL command.

최근 들어 급증하고 있는 보안 관련 사고들로 인하여 개인정보 및 기업정보의 관리에 대한 대책 마련이 시급한 가운데 있다. 보안 관련 사고 가운데 SQL Injection 공격은 가장 널리 악용되고, 오래된 전통적인 해킹 기법 중 하나이다. 최근까지도 웹 해킹을 시도하는 유형 중에서 높은 비중을 차지하고 있으며 그 공격 형태 또한 복잡해지고 있다. 많은 site에서 SQL Injection 공격에 대한 보완을 하여 이전보다 피해가 많이 줄어들기는 했으나 SQL Injection 공격에 의한 악의적인 관리자 권한 획득 및 비정상적인 로그인 등으로 인하여 여전히 많은 피해가 발생하고 있다. 더욱이 향후 사물인터넷 및 센서 빅데이터 환경이 널리 보급되면 수많은 디바이스들과 센서들이 연결되고 데이터의 양이 폭발적으로 증가하게 될 것이다. 그렇게 되면 현재보다 SQL Injection 공격에 의한 피해 규모는 더욱 커질 것이다. SQL Injection 공격에 대응하기 위해서는 많은 시간과 비용이 발생하게 되므로 시스템의 성능을 떨어뜨리지 않으면서도 신속정확하게 SQL Injection 공격을 판별하여 방어해야 할 것이다. 본 논문에서는 SQL Injection 공격에 대응하기 위하여 데이터 분석 및 기계학습을 통하여 웹로그 데이터를 검사하여 비정상적인 패턴의 입력값인 경우 SQL 명령어의 실행 계획을 분석하여 정상적인 SQL 명령어와 비정상적인 SQL 명령어를 판별하는 방안을 제시한다. 실험 및 성능 평가를 위해 사용자의 입력 또는 SQL Injection 공격툴에 의하여 입력되는 값을 실시간으로 실행계획을 분석하여 효과적으로 차단할 수 있음을 보여주었다.

Keywords

References

  1. JUSTIN CLARKE, "SQL Injection : Attacks and Defense", Elsevier Inc. 2009
  2. Seong-Ho Choi, "Defense method against SQL injection attack by hacking tools", Graduate School of Information&Technology, Sogang University, 2010
  3. M.Amutha Prabakar, M.KarthiKeyan, K. Marimuthu, "An Efficient Technique For Preventing SQL Injection Attack Using Pattern", IEEE Computer Society, 2013.5
  4. In-Yong Lee, Jae-Ik Cho, Kyu-Hyung Cho, Jong-sub Moon, "A Method for SQL Injection Attack Detection using the Removal of SQL Query Attribute Values", Journal of The Korea Institute of Information Security and Cryptology Vol.18, No.5, pp.136-140, 2009.
  5. Jeom-Goo Kim, Si-Choon Noh, "A Study of Step-by-step Countermeasures Model through Analysis of SQL Injection Attacks Code", Journal of information and security Vol.12, No.1, 2012
  6. Lwin Khin Shar, Hee Beng Kuan Tan, "Defeating SQL Injection", IEEE Computer Society, 2013.3
  7. Mun-Joo Lee, "A study on the intrusion detection and countermeasure system for mass SQL injection", Graduate School of Information, Chung-ang University, 2011
  8. Debabrata Kar, Suvasini Panigrahi, "Prevention of SQL Injection Attack Using Query Transformation and Hashing", IEEE Computer Society, 2012.3
  9. Joon-Seon Ahn, Yeong-Min Kim, Jang-Wu Jo, "Development of a String Injection Vulnerability Analyzer for Web Application Programs", The KIPS transactions. Part A. Vol.15-A, No.3, pp.181-182, 2008
  10. Korea Information Security Agency, "Research on inserting malicious code through an automated SQL Injection Attack", 2008
  11. Incheon Paik, "Improving Malicious Web Code Classification with Sequence by Machine Learning", IEIE Transactions on Smart Processing & Computing Vol.3 No.4, pp.319-324, 2014.10 https://doi.org/10.5573/IEIESPC.2014.3.5.319
  12. Z. Lashkaripour, "A Simple and Fast Technique for Detection and Prevention of SQL Injection Attacks", International Journal of Security and Its Applications Vol.7, No.5, pp.53-66, 2013 https://doi.org/10.14257/ijsia.2013.7.5.05
  13. F. Valeur, D. Mutz, G. Vigna, "A Learning-Based Approach to the Detection of SQL Attacks", In Proceedings of the Conference on Detection of Intrusious and Malware and Vulnerability Assessment, pp 123-140, 2005.
  14. Huang.Y, Huang.S, Lin.T, Tasi.C, "Web application security assessment by fault injection and behavior monitoring", In Proceedings of the 12th international Conference on World Wide Web, pp.148-159, 2003
  15. Ju-Hwa Park, "A study of the preventive measures to counteract the SQL injection attacks on the web programed in Java", Grauduate School of Sungkyunkwan University, 2010
  16. Jong-Cheol Lee, "Oracle Query tuning method using a Hint", Graduate School of Technology Management, Kyunghee University, 2008
  17. http://users.aber.ac.uk/pds7/csic_dataset/csic2010http.html
  18. https://github.com/ron190/jsql-injection
  19. Young-Sun Kim, Choon-Weon Seo, "Design and Implimentation of Intrusion Detection System on Contents Security", Journal of The Institute of Electronics and Information Engineers Vol.52, No.11, pp.164-168, 2015 https://doi.org/10.5573/IEIE.2015.52.11.164