(Publisher of Peer Reviewed Open Access Journals)

International Journal of Advanced Computer Research (IJACR)

ISSN (Print):2249-7277    ISSN (Online):2277-7970
Volume-3 Issue-12 September-2013
Full-Text PDF
Paper Title : Horizontal Aggregation in SQL to Prepare Dataset for Generation of Decision Tree using C4.5 Algorithm in WEKA
Author Name : Mayur N. Agrawal, Ankush M. Mahajan, C.D. Badgujar, Hemant P. Mande, Gireesh Dixit
Abstract :

In this paper we are taking a Database Table, a database is an organized collection of data. We are performing a Horizontal Aggregation on that particular Database Table; there are three methods from which we are performing Horizontal Aggregation. These three methods give us the output as the dataset of that particular database table. A Dataset is a collection of data, usually presented in tabular form. By providing these dataset as an input to the C 4.5 algorithm in WEKA, we are generating Decision tree for that database table. Three methods for Horizontal aggregation are SPJ, PIVOT and CASE. C4.5 is the Decision tree Generation Algorithm which generates Decision tree.

Keywords : Aggregation, PIVOT, SPJ, CASE, Dataset.
Cite this article : Mayur N. Agrawal, Ankush M. Mahajan, C.D. Badgujar, Hemant P. Mande, Gireesh Dixit, " Horizontal Aggregation in SQL to Prepare Dataset for Generation of Decision Tree using C4.5 Algorithm in WEKA " , International Journal of Advanced Computer Research (IJACR), Volume-3, Issue-12, September-2013 ,pp.164-169.