A New Approach for Data Preparation Which Makes the Data Mining Simpler

Provided by: International Journal of Communication and Computer Technologies (IJCCTS)
Topic: Data Management
Format: PDF
In data mining, preparing a data set for analysis is generally the most time consuming task, it requires many complex SQL queries, joining tables and aggregating columns. Existing SQL aggregations have limitations to prepare data sets because they return one column per aggregated group. In general, a significant manual effort is required to build data sets, where a horizontal layout is required. 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.

Find By Topic