slugDatasets Preparation in SQL Using Horizontal Aggregation
Journal Title: International Journal for Research in Applied Science and Engineering Technology (IJRASET) - Year 2014, Vol 2, Issue 4
Abstract
Data mining is largely used in preparing data sets for data mining analysis. But it is so much time consuming process. It requires large amount of manual effort. Data mining is largely used domain for getting the patterns from historical database or stored database. Large amount of effort is required to prepare datasets that may be input for data mining algorithm. As we already have some aggregation function MAX,MIN,SUM,COUNT,AVG which are not efficient for making datasets in data mining analysis. This aggregate function have drawback as they return single value single value per aggregated group in that table.In data mining analysis when we requires data in horizontal layout that tine we require hard effort.So we are developing simple but powerful tool to get SQL code to return combined columns in horizontal layout form,which returns group of numbers instead of one number per row. This new group of tool or function is said to be horizontal aggregation.From third queries we will get output output data which is suitable for various data mining operations. It means this paper gives horizontal aggregation using some constructs that include SQL queries. Here we are using three functions which is Grouping column, Horizontal column, Aggregate column. User have to give this as input.So that user get the output which is suitable for data mining analysis.
Authors and Affiliations
Sonali Karle, Swati Avhad, Ashlesha Shelar, Prof. Suvarna Pawar, Kajal Dighe
Keywords
Related Articles
- EP ID EP17831
- DOI -
- Views 398
- Downloads 12
Efficient Multi Review Classification using feature extraction technique in the Micro Reviews
Although the content of micro-blogging sites has been studied extensively, micro-reviews are a source of content that has been largely overlooked in the literature. In this paper we study micro-reviews, and we show how...
Image Enhancement Using Recursive Adaptive Gamma Correction
The “Adaptive Approach for Historical or Degraded Document Binarization” is that in which Libraries and Museums obtain in large gathering of ancient historical documents printed or handwritten in native languages. Typic...
Automation System for Household Electronic Devices Using Touch Interface
Today, we face a lot of problems when it comes to household circuits. For example, if the Air Conditioner is set for three hours in the night time and once it switches off, the person has to wake up and turn on the fan....
Performance Comparison of Cryptanalysis Techniques over DES
The primary requirement of a good encryption technique is that it is either impossible or difficult to deduce the plaintext out of a ciphertext without the knowledge of key. Cryptanalysis is the technique that violates...
Suggesting Pesticides for Farmers using Data Mining
Agriculture plays a vital role in India’s economy. Virtually fifty eight % of the rural people rely upon the Agriculture. One amongst the challenges that Indian farmers encounter nowadays is how to use the pesticides in...