Detecting anti-patterns in SQL Queries using Text Classification Techniques
Journal: International Journal of Advanced Engineering Research and Science (Vol.6, No. 4)Publication Date: 2019-04-10
Authors : Abdou Rahmane Ousmane Hongwei Xie;
Page : 305-309
Keywords : SQL; relational database; text classification techniques.;
Abstract
A major problem with using relational databases, is writing efficient SQL queries. Some common errors known as anti-patterns are frequent in SQL queries and can seriously impact the query execution time and sometimes, the database general performance. This paper shows how ma-chine learning techniques can be lever-aged to detect anti-patterns in SQL queries by approaching the problem as a text classification problem. Our result is a model based on a convolutional neural net-work that can be used to classify a SQL query into zero, one or many anti-patterns classes.
Other Latest Articles
- Origin and branching of the phrenic nerve (Sus scrofa domesticus Linnaeus, 1758) of the Pen Ar Lan Line
- The Interdisciplinary Practice of High School Teachers of Nature Sciences: Focusing on the Environment in full-time School
- T-ISO: A Standard Proposal for Green IT Indicators Oriented to Higher Education Institutions
- Reduction of Emissions from Common-rail Diesel Engine using Mahua and Pongamia Methyl Esters
- Mesophillic Anaerobic Co-Digestion of Horse Dung, Plantain Peel and Egg Sheel at Different Climatic Conditions
Last modified: 2019-04-26 13:26:08