Optimization of Horizontal Aggregation in SQL by Using C4.5 Algorithm
For efficient analysis of some data mining system and algorithms, data is required in the horizontal aggregated format. In a relational database, datasets are highly normalized and major efforts are required to compute aggregation when they are expected in horizontal form which is suitable for some data mining, statistical and machine learning algorithm. Query optimization techniques used for vertical (standard) aggregation is not suitable for horizontal aggregation. That's why the authors propose an optimization technique for horizontal aggregation.