Horizontal Aggregation in SQL to Prepare Datasets and Decision Tree
International Journal of Science and Research (IJSR)

International Journal of Science and Research (IJSR)
www.ijsr.net | Open Access | Fully Refereed | Peer Reviewed International Journal

ISSN: 2319-7064

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

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

Share this Article

How to Cite this Article?

Krupali R. Dhawale, M. S. Gayathri, "Horizontal Aggregation in SQL to Prepare Datasets and Decision Tree", International Journal of Science and Research (IJSR), https://www.ijsr.net/search_index_results_paperid.php?id=20141311, Volume 3 Issue 7, July 2014, 1561 - 1567

71 PDF Views | 66 PDF Downloads

Download Article PDF



Similar Articles with Keyword 'aggregations'

M.Tech / M.E / PhD Thesis, Computer Science & Engineering, India, Volume 3 Issue 7, July 2014

Pages: 1561 - 1567

Horizontal Aggregation in SQL to Prepare Datasets and Decision Tree

Krupali R. Dhawale, M. S. Gayathri

Share this Article

Survey Paper, Computer Science & Engineering, India, Volume 4 Issue 11, November 2015

Pages: 1666 - 1668

Survey Paper on Cube Computation Techniques

Amar Sawant, Madhav Ingle

Share this Article

M.Tech / M.E / PhD Thesis, Computer Science & Engineering, India, Volume 5 Issue 6, June 2016

Pages: 1539 - 1542

Privacy Based Association Rules in Secure Horizontal Database

Zameena R, Nitha L Rozario

Share this Article

Research Paper, Computer Science & Engineering, Kuwait, Volume 6 Issue 7, July 2017

Pages: 987 - 996

Shelf Space Allocation Problem Using LNS Solver

Dina Hamad Alghurair, Hedaya Ghanim Alshammar

Share this Article

Research Paper, Computer Science & Engineering, India, Volume 2 Issue 1, January 2013

Pages: 158 - 161

Architecture for Analysis of Multi-Dimensional Data using Standalone Desktop based Cluster

Suja P Mathews, Sunu George

Share this Article

Similar Articles with Keyword 'SQL'

Research Paper, Computer Science & Engineering, India, Volume 4 Issue 9, September 2015

Pages: 1621 - 1623

Column Oriented Database: Implementation and Performance Analysis

Vibha Shukla, Dr. Rajdev Tiwari

Share this Article

Survey Paper, Computer Science & Engineering, India, Volume 3 Issue 12, December 2014

Pages: 1591 - 1593

Virtual Fruits Market

Kalyani P. Khodaskar

Share this Article

Research Paper, Computer Science & Engineering, India, Volume 4 Issue 5, May 2015

Pages: 2827 - 2831

Constraint Generation Tool for White-box Testing

Kshamata Shenoy, Madhuri Rao, S. S Mantha

Share this Article

Research Paper, Computer Science & Engineering, India, Volume 3 Issue 5, May 2014

Pages: 1443 - 1445

Natural Language Interface to Databases: A Survey

Manika Tyagi

Share this Article

Survey Paper, Computer Science & Engineering, India, Volume 3 Issue 6, June 2014

Pages: 506 - 509

A Random Walk through the Dark Side of NoSQL Databases in Big Data Analytics

Kudakwashe Zvarevashe, Tatenda Trust Gotora

Share this Article
Top