ResearchBib Share Your Research, Maximize Your Social Impacts
Sign for Notice Everyday Sign up >> Login

An Horizontal Aggregation Approach for Preparation of Data Sets in Data Mining

Journal: International Journal of Engineering Sciences & Research Technology (IJESRT) (Vol.2, No. 4)

Publication Date:

Authors : ; ;

Page : 854-858

Keywords : Dataset; Aggregation.;

Source : Downloadexternal Find it from : Google Scholarexternal


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 l generate SQL code to return aggregated columns in a horizontal tabular layout, returning a set of numbers instead of one number per row. This new class of functions is called horizontal aggrega data sets with a horizontal denormalized layout, which is the standard layout required by most data mining algorithms.

Last modified: 2014-10-02 23:08:19