International Journal of Advanced Research in Computer Science and Software Engineering (IJARCSSE)
Knowledge discovery is the major task of data mining. The challenge is to model a suitable data. Centralized database management is achieved through data warehousing, mainly to improve efficiency while extracting and on data preparation. Data presentation is important phase in analysis. So data is collected and represented in the form of vertical or horizontal dataset. To prepare a dataset which is horizontally aggregated from various databases three major techniques were used such as SPJ, PIVOT and CASE, which make pre-processing easier through query tool. In this paper with horizontal aggregation, the analysis process is combined and pre-processed using apriori algorithm.