Improved Methodology for Mining Datasets

Abstract: In the preparation of the datasets or database we use joins, aggregations of the columns. In this, traditional methods transforming the retrieved rows are called horizontal aggregations. In this aggregations all sql aggregations are performed but we don’t apply aggregation methods on file or image data. For this problem we introduced a method that retrieves the columns that it searches the given patterns in the sql query. It reduces the complexity of the nested queries. 1