Preparation of Datasets for Data Mining Analysis Using Horizontal Aggrega- tion

Abstract- Data aggregation is a process in which information is gathered and expressed in a summary form, and which is used for purposes such as statistical analysis. A common ag-gregation purpose is to get more information about particular groups based on specific variables such as age, name, phone number, address, profession, or income. Most data mining al-gorithms takes as input data set with a horizontal layout. Sig-nificant effort is required to prepare summary data set in a relational database with normalized tables. For preparing data sets suitable for data mining analysis, we have to write complex SQL queries, operation of joining tables and column aggrega-tion. Horizontal aggregation can be performing by using oper-ator, it can easily be implemented inside a query processor, much like a select, project and join. PIVOT operator on tabu-lar data that exchange rows, enable data transformations use