International Journal of Emerging Trends & Technology in Computer Science
A Motivation for Recent Innovation & Research
ISSN 2278-6856
www.ijettcs.org

Call for Paper, Published Articles, Indexing Infromation Survey on Different Techniques in SQL to Prepare Dataset for Data Mining, Authors : Shaila Eksambekar , Prof. Suhasini Itkar, International Journal of Emerging Trends & Technology in Computer Science (IJETTCS), www.ijettcs.org
Volume & Issue no: Volume 4, Issue 2, March - April 2015

Title:
Survey on Different Techniques in SQL to Prepare Dataset for Data Mining
Author Name:
Shaila Eksambekar , Prof. Suhasini Itkar
Abstract:
Abstract One of the basic tasks in data mining activity is data preprocessing and preparing dataset. Efficient data analysis can be made easier with datasets having columns in horizontal tabular layout. This paper presents an overview of data preprocessing and dataset preparation techniques using SQL. To prepare dataset if we use SQL aggregations they return one column per aggregated group. This is the limitation of SQL aggregation. In this paper we have proposed need of effective and optimized usage of SQL to build dataset using horizontal aggregations. Also if the result of horizontal aggregation i.e. horizontal layout is integrated with K-means clustering algorithm we can get proper clusters. Keywords: Data Preprocessing, Dataset, Aggregation, SQL, relational DBMS, SPJ, CASE, PIVOT, K-means
Cite this article:
Shaila Eksambekar , Prof. Suhasini Itkar , " Survey on Different Techniques in SQL to Prepare Dataset for Data Mining " , International Journal of Emerging Trends & Technology in Computer Science (IJETTCS), Volume 4, Issue 2, March - April 2015 , pp. 158-162 , ISSN 2278-6856.
Full Text [PDF]                          Home