An Efficient Approach for Building Dataset in Data Mining
Data mining is one of the emerging field in research. Preparing a dataset is one of the important task in data mining. To analyze data efficiently, data mining systems are widely using datasets with columns in horizontal tabular layout. In normal, a significant manual effort is required to build data sets, where a horizontal tabular layout. Building a datasets for analysis is normally a most time consuming task. Existing SQL aggregations have limitation to build data sets because they return one column for aggregated group using group functions. The authors propose simple, yet powerful, methods to generate SQL code to return aggregated columns in a horizontal tabular layout, returning a set of numbers instead of one number per row.