Using Text Classification Techniques to identify anti-patterns in SQL queries

Authors

  • Dibyanshu Chatterjee Department of computer science and engineering, Ms Ramaiah University of Applied Sciences, Bangalore
  • Niveditha CA Application Software Analyst, Accenture, Bangalore

Keywords:

Anti-patterns, SQL, text classification techniques, relational database

Abstract

A significant issue with utilizing social information bases, is formulating and writing proficient SQL
queries. Some basic blunders known as anti-patterns are quite common in SQL queries and can genuinely affect its
execution time and at times, the database's general execution. This paper manifests machine learning methods and
identifies anti-patterns by approaching the issue as a text classification issue. Our outcome is a model dependent on a
convolutional neural network that can be utilized to order a SQL query into zero, one or numerous anti-pattern classes.

Published

2020-11-25

How to Cite

Dibyanshu Chatterjee, & Niveditha CA. (2020). Using Text Classification Techniques to identify anti-patterns in SQL queries. International Journal of Advance Engineering and Research Development (IJAERD), 7(11), 32–36. Retrieved from https://ijaerd.org/index.php/IJAERD/article/view/4756