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 409
- Downloads 12
Improvement in the Production of Powder Coating Process of Fan Blades through PDCA Review
Plan-Do-Check-Act (PDCA) cycle is a spiral iterative scientific approach for achieving continuous improvement of quality whether in the process, product or service in any organization. This is paper review on the PDCA a...
Detecting Dodgy Transactions through High Value Networks in Economic Services
The purpose of this paper is to detect the dodgy or suspicious transactions in financial era with the help of data mining technique and also to detect more suspicious transactions in suspicious transactions. K mean tech...
A Review on Enhancing the Performance of MPPT for Single Stage PV-Grid Connected System Using Particle Swarm Optimization Technique
The scaling of maximum power point tracking (MPPT) system is suggested. The optimal operating point of a solar module is known as the maximum power point (MPP) and it changes with its own characteristic as well as cell...
Impact of Mechanical Properties & Microstructures on Aluminium Alloys (aa6061- aa7075) by using Friction Ftir Welding Process
Recently many reports on Friction Stir Welding (FSW) of various dissimilar systems such as Aluminium alloys AA6061 and AA7075, has been reported. FSW of Aluminium alloys has captured important attention from manufacturi...
Survey Paper on Online Election System
An electronic voting (e-voting) system is a voting system in which the election data is recorded, stored and processed primarily as digital information. There are two types of election: On-Line and Offline. In online el...