Prepare and Optimize Data Sets for Data Mining Analysis

Getting ready a data set for examination is usually the tedious errand in a data mining task, needing numerous complex SQL queries, joining tables and conglomerating sections. Existing SQL aggregations have limitations to get ready data sets since they give back one section for every amassed bunch. As a rule, a significant manual exertion is obliged to construct data sets, where a horizontal layout is needed. The authors propose straightforward, yet effective methods to generate SQL code to return totaled sections in a horizontal even layout, giving back a set of numbers rather than one number for every line. This new class of functions is called horizontal aggregations.

Provided by: International Journal of Emerging Technology and Advanced Engineering (IJETAE) Topic: Data Management Date Added: Nov 2013 Format: PDF

Download Now

Find By Topic