Preparing Data Sets for the Data Mining Analysis Using the Most Efficient Horizontal Aggregation Method in SQL

Provided by: International Journal of Computer Applications
Topic: Data Management
Format: PDF
A huge amount of time is needed for making the dataset for the data mining analysis because data mining practitioners required to write complex SQL queries and many tables are to be joined to get the aggregated result. The traditional SQL aggregations prepare the data sets in vertical layout that is; they return result on one column per aggregated group. But for the data mining project, the data set to be required in horizontal layout. In order to transform the data into suitable form the existing three horizontal aggregation methods are used.

Find By Topic