A Review on Techniques for Horizontal Aggregations in SQL to Prepare Data Sets for Data Mining

Download Now
Provided by: International Journal of Advanced Research in Computer Science and Software Engineering (IJARCSSE)
Format: PDF
Preparing a data set for analysis is the most time consuming task in a data mining project, which requires many complex SQL queries, joining tables and aggregated columns. Existing SQL aggregations have limitations to prepare data sets as they return one column per aggregated group. Manual effort is required to build data sets, where a horizontal layout is required. Horizontal aggregations function is proposed which is an extension to SQL aggregate functions to produce aggregations in tabular form, returning a set of numbers instead of one number per row.
Download Now

Find By Topic