International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
|
Volume 58 - Issue 15 |
Published: November 2012 |
Authors: Jincy Annie V.V, J. A. M. Rexie |
![]() |
Jincy Annie V.V, J. A. M. Rexie . Efficient Tabular Dataset Preparations by the Aggregations in SQL: A Survey. International Journal of Computer Applications. 58, 15 (November 2012), 17-20. DOI=10.5120/9358-3693
@article{ 10.5120/9358-3693, author = { Jincy Annie V.V,J. A. M. Rexie }, title = { Efficient Tabular Dataset Preparations by the Aggregations in SQL: A Survey }, journal = { International Journal of Computer Applications }, year = { 2012 }, volume = { 58 }, number = { 15 }, pages = { 17-20 }, doi = { 10.5120/9358-3693 }, publisher = { Foundation of Computer Science (FCS), NY, USA } }
%0 Journal Article %D 2012 %A Jincy Annie V.V %A J. A. M. Rexie %T Efficient Tabular Dataset Preparations by the Aggregations in SQL: A Survey%T %J International Journal of Computer Applications %V 58 %N 15 %P 17-20 %R 10.5120/9358-3693 %I Foundation of Computer Science (FCS), NY, USA
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.