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 415
- Downloads 12
slugMobile robot Navigation Techniques: A Survey
This paper describes the developments of different basic techniques for mobile robot navigation during the last 10 years. Now a day’s mobile robots are vastly used in many industries for performing different activities....
V/F Speed Control of Induction Motor by using LZ Source Inverter
This paper presents L-Z source inverter used to control the speed of an induction motor using the V/f method. Capacitors using Z source inverters may result in large volume, expensive cost, inrush current and resonance...
Generation High Voltage: A Technique for Laboratory Educational Works
In this paper a method is discussed to generate high voltage DC up to 110kV using Cockroft-Walton Voltage Multiplier for study and research at educational laboratory. As High Voltage DC (HVDC) transmission is becoming m...
Concept of Subnets in Computer Networking
An organization can subdivide its host address space into groups called subnets. The subnet ID is generally used to group hosts based on the physical network topology. Subnets can simplify routing. IP subnet broadcasts...
Design and Implementation of Sensor Network to Monitor Environmental Parameters of Blower Unit of Cotton Yarn Manufacturing Industry
In textile industry, monitoring of the environmental parameters such as temperature and humidity is essential. To maintain the quality of the cotton yarn, the environmental temperature and humidity is maintained at the...