Efficient Tabular Dataset Preparations by the Aggregations in SQL: A Survey

Many data mining algorithms require the result to be transformed into tabular format. Tabular datasets are the suitable input for many data mining approaches. But the existing SQL aggregations cannot produce results in tabular form with more summarized details especially in horizontal tabular form....

Full description

Saved in:
Bibliographic Details
Published in:International journal of computer applications 2012-01, Vol.58 (15), p.17-20
Main Authors: V V, Jincy Annie, M Rexie, J A
Format: Article
Language:English
Subjects:
Agglomeration
Algorithms
Data mining
Format
Horizontal
Query languages
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Many data mining algorithms require the result to be transformed into tabular format. Tabular datasets are the suitable input for many data mining approaches. But the existing SQL aggregations cannot produce results in tabular form with more summarized details especially in horizontal tabular form. Here discuss several approaches to produce data sets in tabular format and also present an efficient method to produce results in horizontal tabular format. Alternative methods for the evaluation of new format are also shown here.
ISSN:0975-8887
0975-8887
DOI:10.5120/9358-3693