Downloads: 113 | Views: 124
M.Tech / M.E / PhD Thesis | Computer Science & Engineering | India | Volume 3 Issue 7, July 2014
Horizontal Aggregation in SQL to Prepare Datasets and Decision Tree
Krupali R. Dhawale | M. S. Gayathri
Abstract: Data mining is similar to discovering an innovative idea. When data are structured under RDBMs it will be very critical task to make it out. Many data mining concepts and algorithms are used to create prepared datasets in tabular format which consist complex queries, joining tables in data mining. Tabular format take proper input to prepare data sets but existing SQL aggregations having limited capacity to prepare data sets and it is very time consuming task. They return one column per aggregated group. Hence fundamental methods are used to determine horizontal aggregation to signify an outline made by SQL code to return in a horizontal tabular format by using SPJ, CASE and PIVOT methods. This group of new function is called as horizontal aggregation. Aim of this work is to present classification on prepared datasets and further, generating the decision tree by using C4.5 algorithm to reduce the time constraints. Proposed work might be useful for the programmers to interpret the knowledge in the form of decision tree.
Keywords: aggregations, SQL, pivoting, data preparations
Edition: Volume 3 Issue 7, July 2014,
Pages: 1561 - 1567
Similar Articles with Keyword 'aggregations'
Survey Paper, Computer Science & Engineering, India, Volume 4 Issue 11, November 2015Pages: 1666 - 1668
Survey Paper on Cube Computation Techniques
Amar Sawant  | Madhav Ingle 
M.Tech / M.E / PhD Thesis, Computer Science & Engineering, India, Volume 5 Issue 6, June 2016Pages: 1539 - 1542
Privacy Based Association Rules in Secure Horizontal Database
Zameena R | Nitha L Rozario