Volume : III, Issue : I, January - 2014

Aggregation to Prepare Data Mining Sets for Analysis

Sreekar. E, Ramesh. J

Abstract :

Aggregate functions perform a calculation on a set of values and return a single value. Except for COUNT, aggregate functions ignore null values. Aggregate functions are frequently used with the GROUP BY clause of the SELECT statement. All aggregate functions are deterministic. This means aggregate functions return the same value any time that they are called by using a specific set of input values. The OVER clause may follow all aggregate functions except GROUPING and GROUPING_ID. Aggregate functions can be used as expressions only in the select list of a SELECT statement (either a sub query or an outer query) and A HAVING clause. We 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. Managing large datasets except DBMS support can be a difficult job. Trying different subsets of data points and dimensions is more convenient, faster and easier to do inside a relational database with SQL queries than outside with alternative handler. Horizontal aggregation can be performing by using handler, this will be able to simply be alive or implement within a doubt analyzer, a large amount similar to a choose plan and unite.

Keywords :

Article: Download PDF   DOI : 10.36106/ijsr  

Cite This Article:

Sreekar.E, Ramesh. J Aggregation to Prepare Data Mining Sets for Analysis International Journal of Scientific Research, Vol.III, Issue.I January 2014

Number of Downloads : 680

References :