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

Abstract

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.