ortizontal Aggregation in SQL for Data Mining Analysis to Prepare Data Sets
Journal Title: International Journal of Modern Engineering Research (IJMER) - Year 2013, Vol 3, Issue 4
Abstract
: Preparing a data set for analysis is generally the most time consuming task in a data mining project, requiring many complex SQL queries, joining tables and aggregating columns. Existing SQL aggregations have limitations to prepare data sets because they return one column per aggregated group. In general, a significant manual effort is required to build data sets, where a horizontal layout is required. We propose simple, yet powerful, methods to generate SQL code to return aggregated columns in a horizontal tabular layout, returning a set of numbers instead of one number per row. This new class of functions is called horizontal aggregations. Horizontal aggregations build data sets with a horizontal denormalized layout (e.g. point-dimension, observation-variable, instance-feature), which is the standard layout required by most data mining algorithms. We propose three fundamental methods to evaluate horizontal aggregations: CASE: Exploiting the programming CASE construct; SPJ: Based on standard relational algebra operators (SPJ queries); PIVOT: Using thePIVOT operator, which is offered by some DBMSs. Experiments with large tables compare the proposed query evaluation methods. Our CASE method has similar speed to the PIVOT operator and it is much faster than the SPJ method. In general, the CASE and PIVOT methods exhibit linear scalability, where as the SPJ method does not.
Authors and Affiliations
B Susrutha, J. Vamsi Nath
Keywords
Related Articles
- EP ID EP141140
- DOI -
- Views 108
- Downloads 0
Properties of Glass Fibre Reinforced Geopolymer Concrete
This paper presents results of an experimental program to determine mechanical properties of Glass fibre reinforced Geopolymer Concrete which contains fly ash, alkaline liquids, fine & course aggregates & g...
Comparison between Chemically Treated Sisal Fiber with Al2O3 and Fe2O3: -It’s Dielectric Loss
Aluminum oxide and iron oxide synthesized through sintering route. The present research work deals with ferrite and aluminum composite prepared using chemical reactions. Aluminum nitrate, ferric nitrate a...
Transmission Error in Gear
The power transmission by the gears is mostly used in the industries, automobile gearbox, robotics office automation etc. and this is possible mostly by the gearing. Gearing is one of the most critical components in mech...
Results from set-operations on Fuzzy soft sets
In this paper considering a class of Fuzzy-Soft Sets, seven set operations are defined and several relations arising from these set-operations are established using matrix representation of fuzzy soft sets.
Numerical Analysis of Fin Side Turbulent Flow for Round and Flat Tube Heat Exchangers
Numerical three dimensional simulation of turbulent flow in round and flat tube fin heat exchangers having two rows of staggered arrangement has been carried out to investigate fluid flow and heat transfer characte...