An Horizontal Aggregation Approach for Preparation of Data Sets in Data Mining
Journal Title: International Journal of Engineering Sciences & Research Technology - Year 30, Vol 2, Issue 4
Abstract
In Data Mining, Preparing a data set for analysis is generally the most time consuming task, it requires 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 l 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 aggrega data sets with a horizontal denormalized layout, which is the standard layout required by most data mining algorithms.
Authors and Affiliations
Mayur N. Agrawal
Keywords
Related Articles
- EP ID EP153783
- DOI -
- Views 76
- Downloads 0
A REIVEW ON EXTENSIVE SECURITY OF COMMERCIAL WEB SSO SYSTEMS
The research of this paper are focused on extensive security analysis of commercial web SSO systems. Single signon solutions are a safe and great alternative to credential loss. In this paper we observe advantages...
INSOLUBLE RESIDUE ANALYSIS OF LIMESTONE IN KOLHAN GROUP
The data from the insoluble residue analysis of nearly ninety eight samples collected from different horizons fully corroborate the petrogenetic evidences obtained from the petrographic and field features of the Ko...
EXPERIMENTAL STUDY OF BLAST FURNACE SLAG CONCRETE
The study presents the experimental investigation carried out to evaluate effects of replacing fine aggregate with that of blast furnace slag on various concrete properties. The basic objective of this study was to ide...
REMOVAL OF Cr (VI) FROM AQUEOUS SOLUTION USING GRANULARACTIVATED CHARCOAL PREPARED FROM CORDIA MACLEODII TREEBARK AND SURFACE MODIFIED GRANULAR ACTIVATED CHARCOAL: ACOMPARATIVE STUDY VIA SPECTROSCOPIC CHARACTERIZATIONS
Granular Activated Charcoal (GAC) was prepared by using Cordia macleodii tree bark and was tested for theremoval of Chromium (VI). All the experiments were carried out in batch process. To enhance its metal ionsadsorptio...
DEVELOPMENT OF IMAGE PROCESSING AND ITS APPLICATIONS ON CRYPTOGRAPHY
The importance of embedded applications on image and video processing, communication and cryptography domain has been taking a larger space in current research era. Improvement of pictorial information for betterm...