"A Recommendation System for Execution Plans"

Authors

Ms. Pratibha V. Waje (Assistant Professor), SVIT, Nashik, Maharashtra, India.

Dr. R. Jain (Professor), CSJMU, Kanpur, India.

Abstract

In this paper, we discuss an approach for execution plan recommendation systems. We propose a textual representation of our SQL queries and use it to build a Features Extractor module. Then, we present a straightforward solution to identify query similarity. This solution relies only on the comparison of the SQL statements. Next, we show how to build an improved solution enabled by machine learning techniques. The improved version takes into account the features of the queries’ execution plans. By comparing machine learning algorithms, we find that the improved solution using Classification Based on Associative Rules (CAR) identifies similarity.