International Journal of Advanced Research in Computer Science and Software Engineering (IJARCSSE)
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.