Main Article Content
Abstract
The most time consuming and tidies job is preparing a data set for analysis using table joins, blending and various queries. The traditional aggregations (SQL) have various limitations because the outcome is one column per group (aggregated group). Due to this, data sets are prepared manually, where ever horizontal aggregation is required. Horizontal aggregation is known as new class of functions, which is required in various data mining algorithms. This paper discussed various fundamental methods to evaluate horizontal layout ( aggregation) such as SPJ with relational algebra operators, CASE using some programming CASE structures and PIVOT using some DBMS operators