Year: 2019
Type: article
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 leveraged 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 network that can be used to classify a SQL query into zero, one or many anti-patterns classes.
Authors: Abdou Rahmane Ousmane, Hongwei Xie
Institution: Taiyuan University of Technology
Language: English
Subfield: Information Systems
Field: Computer Science
Domain: Physical Sciences
Open Access status: diamond
OpenAlex ID: W2942290805
