International Journal of Computer Applications |
Foundation of Computer Science (FCS), NY, USA |
Volume 58 - Number 15 |
Year of Publication: 2012 |
Authors: Jincy Annie V.v, J. A. M. Rexie |
10.5120/9358-3693 |
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
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.